Blank formula fields

[danielle]

I have the below IF statement in e.g. F1 where F1 should display the answer of B1 * E1.

=IF((B21*E21)>0,"","")

Now what I want is if the answer of B1 * E1 is greater than zero I want the answer to show. If the answer is zero I want the cell, in this case F1, to be blank.

Possible?

I can get the blank to show but then I can't get the answer to show.

Any ideas?

 

[svmac]

Try:

IF((B21*E21)>0,(B21*E21),"")

 

[danielle]

Thanks that formula worked. I originally had that formula but with "(B1*E1)" so the cell was actualloy showing up (B1*E1)!