<div>
Try this<br />
<br />
=IF(ISERROR(IF(FIND(&quot;PL&quot;,P<wbr />5,1),O5*0.<wbr />5,IF(FIND(<wbr />&quot;SN&quot;,P5,1)<wbr />,IF(AND(AM<wbr />5&gt;10,I5&lt;1.<wbr />25),O5*15,<wbr />O5*10),0))<wbr />),0,IF(FIN<wbr />D(&quot;PL&quot;,P5,<wbr />1),O5*0.5,<wbr />IF(FIND(&quot;S<wbr />N&quot;,P5,1),I<wbr />F(AND(AM5&gt;<wbr />10,I5&lt;1.25<wbr />),O5*15,O5<wbr />*10),0)))<br />
<br />
Sid
</div>


Try this

=IF(ISERROR(IF(FIND("PL",P5,1),O5*0.5,IF(FIND("SN",P5,1),IF(AND(AM5>10,I5<1.25),O5*15,O5*10),0))),0,IF(FIND("PL",P5,1),O5*0.5,IF(FIND("SN",P5,1),IF(AND(AM5>10,I5<1.25),O5*15,O5*10),0)))

Sid

<div>
The above formula is for Excel 2003. For 2007/2010 try this<br />
<br />
=IFERROR(IF(FIND(&quot;PL&quot;,P5,1<wbr />),O5*0.5,I<wbr />F(FIND(&quot;SN<wbr />&quot;,P5,1),IF<wbr />(AND(AM5&gt;1<wbr />0,I5&lt;1.25)<wbr />,O5*15,O5*<wbr />10),0)),0)<wbr /><br />
<br />
Sid
</div>


The above formula is for Excel 2003. For 2007/2010 try this

=IFERROR(IF(FIND("PL",P5,1),O5*0.5,IF(FIND("SN",P5,1),IF(AND(AM5>10,I5<1.25),O5*15,O5*10),0)),0)

Sid

<div>
<div class="content wysiwyg-content">
Hello trying to build a formula to do the following<br />
If cell P5 contains &quot;PL&quot; anywhere in that cell then take O5*.5, else if P5 does not contain PL, but there is a 'SN&quot; and AM5 is greater than 10 and &nbsp;I5 is less than 1.25 then O5*15, else O5*10. if niether PL or SN then 0.
</div>
</div>


Hello trying to build a formula to do the following
If cell P5 contains "PL" anywhere in that cell then take O5*.5, else if P5 does not contain PL, but there is a 'SN" and AM5 is greater than 10 and  I5 is less than 1.25 then O5*15, else O5*10. if niether PL or SN then 0.

Excel Formula

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