View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default formula shows false

I realize I needed to be clearer with my question. I have the following formula
=IF(AND(A2="poplar",B2=1),2*C2*D2/144+0.05*C2*D2/144) this returns the word
FALSE in the target cell. Once I enter the correct information it will do the
math. Is there a way to not see the word FALSE on the sheet? I would rather
see a blank cell, or a 0.

Thanks,
Mike