View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default 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.