Cell formulas display "0" (zero's)
Maybe this:
=IF(Z3+A4<0,Z3+A4,"")
Regards,
Per
"Lenny" skrev i meddelelsen
...
How can I get excel to not display a 0 (zero) in a cell with a simple
calculation like:
Z3+A4. I don't want the cells to display zeros before it displays the
calculation when entries are made into the formula cells and I don't want
to
have to make the entries white to hide them. There's gotta be a way to
not
show this value.
My thanks
Lenny
|