Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Editing formula results so zeros appear blank
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Editing formula results so zeros appear blank
=if(yourformula=0,"",yourformula)
is pretty common 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 -- Dave Peterson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Editing formula results so zeros appear blank
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Editing formula results so zeros appear blank
One trick is to allow the formula to return a zero, but "hide" it by
means of conditional formatting on that cell - if the cell content is zero then print with a white foreground (which on a white background will not show). Hope this helps. Pete On Jan 15, 12:55*am, 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 |
#5
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Editing formula results so zeros appear blank
welcome, Holly.
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Holly" wrote in message ... Thankyou -- Cheers, Holly |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Editing formula results so zeros appear blank
I have a similar problem as this but want to return an actual blank cell not
an empty string (""). Any ideas? "Pete_UK" wrote: One trick is to allow the formula to return a zero, but "hide" it by means of conditional formatting on that cell - if the cell content is zero then print with a white foreground (which on a white background will not show). Hope this helps. Pete On Jan 15, 12:55 am, 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 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Editing formula results so zeros appear blank
If a cell has a formula all it can do is display a value from that formula
There is no way the formula can delete itself. best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Brian" wrote in message ... I have a similar problem as this but want to return an actual blank cell not an empty string (""). Any ideas? "Pete_UK" wrote: One trick is to allow the formula to return a zero, but "hide" it by means of conditional formatting on that cell - if the cell content is zero then print with a white foreground (which on a white background will not show). Hope this helps. Pete On Jan 15, 12:55 am, 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hiding the results of a formula generated from a blank cell | Excel Discussion (Misc queries) | |||
Screen goes blank when editing cells | Excel Discussion (Misc queries) | |||
sum of blank cells returns zeros | Excel Worksheet Functions | |||
References to Blank Cells turn into Zeros | Excel Worksheet Functions | |||
I want blank cells, but they're all zeros now that I have formatted them | Excel Discussion (Misc queries) |