IF Formulas
If it is merely a display of the value "0" that you want to eliminate but
don't care if the content of the cell is "0" then under Tools\Options\View
uncheck the Zero values box
--
EarlyBirdie
"MrReeLady" wrote:
I'm still relatively new to the formulas - can't do anything too complex yet
so this should be an easy one for all you experts out there.
I have cells that have basic Sum formula. If there is no value in any of
the preceding cells, the total cell shows $0.
I believe I can create a formula that says if the value is 0 then leave
blank. I don't want to see the $0.
Thanks!
|