=IF AND or OR
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
|