Possibly, with your IFs set to return zeros instead of ""s, a simple way to
get a clean look would be just to suppress extraneous zeros from showing on
the sheet, via:
Click Tools Options View tab Uncheck "Zero values" OK
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Brad Stevenson" wrote in message
...
I am trying to format an IF function to relay information from one cell to
the other. If I use the value of 0 (zero) in the "true if false" portion
of
my function, then my SUM function for the row works fine... but I want the
cell to be blank if there is no info to relay. However, when I use the ""
for blank, then I get the #value figure in my SUM function.

The SUM function is from a worksheet which was formatted by someone else,
and I cannot change it. Is there a way to change the IF function to
perform
a cell blank if false, but not to put the #value in my SUM function?

Thks.