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?
=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?