Help with an equation
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.
Jeff wrote:
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.
--
Dave Peterson
|