Help with an equation

J

Jeff

Is there a way to not have the answer to an equation show in a cell.?
An exaple of what I have now is cell D1 contains: =B1*C1 , and I dont
want anything to show in D1 until something is put into B1 and C1. It shows
'$ -' right now and I just want it to be blank.
 
B

Bernard Liengme

=if(count(b1:c1)=2,B1*C1,"")
BTW - we talk of 'formulas' not 'equations' - the later have something on
both sides of the =
best wishes
 
D

Dave Peterson

You could check for either cell:
=if(b1="","",b1*c1)
or
=if(c1="","",b1*c1)

or you could check for numbers in both cells:
=if(count(b1:c1)<2,"",b1*c1)

I bet you clicked the $ icon on the toolbar to format the cell as Currency Style
(Accounting format).

This is the same as a custom format of:
_($* #,##0.00_);_($* (#,##0.00);_($* "-"??_);_(@_)

You could hide the 0's by using:
_($* #,##0.00_);_($* (#,##0.00);;_(@_)

But this will hide the 0's if either b1 or c1 is 0.
 
Top