<div>
Thank you, this worked,<br />
=IF(ISERROR(FIND(&quot;RESIDENC<wbr />E&quot;,AK2,1))<wbr />=TRUE,AM2,<wbr />AM2+3)<br />
<br />
how do I add to the formula<br />
RESIDENTIAL<br />
RESIDENT
</div>


<div>
Or you can also try this....<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-41715987-1"><span>=IF(OR(ISNUMBER(SEARCH({&quot;Residence&quot;,&quot;Resident&quot;,&quot;Residential&quot;},AK2))),AM2+3,AM2+2)</span>
</code></pre>
</div>


<div>
@Subodh Tiwari (Neeraj)...Thumbs Up ....this is how i learnt .....Thanks <br />
@ Wass_QA &nbsp;mine formula wont work for your all condition.
</div>


<div>
@itjockey<br />
<br />
Glad you found it helpful. :)
</div>


<div>
Don't know if this would have helped but your original formula had incorrect character lengths for two of the options:<br />
<br />
LEFT(AK2,<b>10</b>)=&quot;RESIDENCE&quot; &nbsp;but RESIDENCE = 9<br />
LEFT(AK2,<b>11</b>)=&quot;RESIDENTIAL&quot; correct as RESIDENTIAL = 11<br />
LEFT(AK2,<b>9</b>)=&quot;RESIDENT&quot; but RESIDENT = 8
</div>


<div>
<div class="content wysiwyg-content">
Hello,<br />
can you please help,<br />
I'm trying to say, if left of cell like then<br />
=IF(LEFT(AK2,10)=&quot;RESIDENC<wbr />E&quot;,AM2+3,I<wbr />F(LEFT(AK2<wbr />,11)=&quot;RESI<wbr />DENTIAL&quot;,A<wbr />M2+3,IF(LE<wbr />FT(AK2,9)=<wbr />&quot;RESIDENT&quot;<wbr />,AM2+3,AM2<wbr />)))<br />
<br />
it seems to work only on exact words.<br />
Example<br />
if the cells was <br />
RESIDENCE_____<br />
RESIDENTIAL ---<br />
RESIDENT yes<br />
<br />
formula doesn't work.<br />
thanks
</div>
</div>


Hello,
can you please help,
I'm trying to say, if left of cell like then
=IF(LEFT(AK2,10)="RESIDENCE",AM2+3,IF(LEFT(AK2,11)="RESIDENTIAL",AM2+3,IF(LEFT(AK2,9)="RESIDENT",AM2+3,AM2)))

it seems to work only on exact words.
Example
if the cells was 
RESIDENCE_____
RESIDENTIAL ---
RESIDENT yes

formula doesn't work.
thanks

Excel formula if

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.