Help with an equation

[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.

 

[Sean Timmons]

=IF(B1*C1=0,"",B1*C1)

Will show nothing until a value is available.

 

[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

 

[Gaurav]

=IF(OR(B1="",C1=""),"",B1*C1)

 

[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.