Need to create blank computation column

  • Thread starter Thread starter Randy
  • Start date Start date
R

Randy

Ok, let's try again. This time I'm breaking it down to a
simple problem so that I don't confuse anyone:

I have 3 cells in a row. In cell x I have a variable. In
cell y I have a variable. In cell z I have a formula:
=x*y . Now if the user is presented with variable x and
nothing for variable y, and the formula is already in
place, cell z will display 0. But I want the user to be
presented with a blank field instead, until such time
he/she enters in a variable for cell y. Therefore, I need
to know what command will tell cell z to display a figure
only if the computation is greater than 0. Any ideas?
Thank you.
 
This will display a blank if the computation would result
in 0.
=IF(X1*Y1=0,"",X1*Y1)
 
Back
Top