Posted to microsoft.public.excel.worksheet.functions
|
|
Editing formula results so zeros appear blank
Thankyou
--
Cheers,
Holly
"Max" wrote:
2 thoughts:
a. Switch off zeros display in the sheet via clicking:
Tools Options View tab Uncheck Zero values OK
b. Use something like this: =IF(yourformula=0,"",yourformula)
(a) gives a neat uncluttered look, easy to apply & retains the underlying
zero values
(b) converts the formula returns of zeros to null strings: "", which appear
"blank"
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Holly" wrote:
Hi All,
Just wondering if anyone has found a way for a formula result which
calculates to zero to show as a blank cell.
--
Cheers,
Holly
|