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