BTW, XL does not actually distinguish between upper and lower case when using
IF formulas.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Lars-Åke Aspelin" wrote:

On Mon, 5 Jan 2009 12:17:01 -0800, Luke M
wrote:

=IF(F8="n","",IF(F7=50,"NA",F5*F4))


If you want to accept either "n" or "N" as no, you can modify this to

=IF(LOWER(F8)="n","",IF(F7=50,"NA",F5*F4))
or
=IF(LOWER(F8)="n"," ",IF(F7=50,"NA",F5*F4))
if you really want " " and not "" as the "blank" result.

Hope this helps / Lars-Åke