Help with an equation
 

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.

Help with an equation
 

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

Will show nothing until a value is available.

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

Help with an equation
 

=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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Jeff" wrote in message
...
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.

Help with an equation
 

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


"Jeff" wrote in message
...
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.

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