Need to create blank computation column

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

 

[Chip Pearson]

Randy,

Try something like

=IF(OR(A1="",B1=""),"",A1*B1)

 

[Eva Shanley]

This will display a blank if the computation would result
in 0.
=IF(X1*Y1=0,"",X1*Y1)