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