How can I replace zeros with blank spaces during calculations plea
Hi!
Try this:
=IF(Z80.5,Z8,"")
That will leave the cell "blank". Not to be confused with EMPTY.
Biff
"Ted" wrote in message
...
I am trying to get excel to sum totals, but exclude answers that are
outside
of a certain range. I can get it to do this by using =IF(Z80.5,Z8,0).
However, I need it to display absolutely nothing in the cells, rather than
a
zero because it alters future calculations. Has anyone any ideas please??
Ted
|