View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gaurav[_4_] Gaurav[_4_] is offline
external usenet poster
 
Posts: 36
Default 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.