Hide Formula Results

[Sherry]

I know I've done this before, but I can't find how to do
it now. I am using Excel 2003, and I have a 30 row colum
with formulas to calculate the two previous columns. I
do not want it to show anything in the cells where the
formulas are if there are no entries in the previous
columns. Does anybody know how to do this?

Thanks,
Sherry

 

[JulieD]

Hi Sherry

if i'm understanding correctly, use an IF statement
e.g.
=IF(AND(A1="",B1=""),"",A1+B1)
this says if both A1 or B1 are empty then display nothing, otherwise display
the value of A1 + B1

Hope this helps
Cheers
julieD