| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Making a 0 invisible with a formiula
I have put a formula in in a worksheet and wish to make the 0 invisible when it comes up. The worksheet is already in the don't display mode. I tried the make the 0 white and that did not work . the formula that I am using =if(B8<=149,"1","0") can anybody help.
Thank You Last edited by marvin : September 18th 09 at 11:58 PM |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making a 0 invisible with a formiula
I'd drop those double quotes so that the numbers are treated as numbers--not
text. =if(B8<=149,1,0) (and try the formatting once more) But maybe you could make the cell look empty: =if(B8<=149,1,"") marvin wrote: I have put a formula in in a worksheet and wish to make the 0 invisible when it comes up. The worksheet is already in the in the don't display mode. I tried the make the 0 white and that did not work . the formula that I am using =if(B8<=149,"1","0") can anybody help. Thank You -- marvin -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Making a 0 invisible with a formiula
maybe
=if(B8<=149,"1","") susan On Sep 18, 9:18*am, marvin wrote: I have put a formula in *in a worksheet and wish to make the 0 invisible when it comes up. *The worksheet is already in the in the don't display mode. I tried the make the 0 white and that did not work . the formula that I am using =if(B8<=149,"1","0") can anybody help. * Thank You -- marvin |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Making a 0 invisible with a formiula
Get rid of the double quote marks which make Excel think the 1 or 0 is text.
=IF(B8<=149,1,0) Gord Dibben MS Excel MVP On Fri, 18 Sep 2009 14:18:35 +0100, marvin wrote: I have put a formula in in a worksheet and wish to make the 0 invisible when it comes up. The worksheet is already in the in the don't display mode. I tried the make the 0 white and that did not work . the formula that I am using =if(B8<=149,"1","0") can anybody help. Thank You |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| text is invisible | Excel Discussion (Misc queries) | |||
| Invisible sheets | Excel Worksheet Functions | |||
| Invisible Spreadsheet | Excel Discussion (Misc queries) | |||
| Making Border of Frozen Panes Invisible | Excel Discussion (Misc queries) | |||
| Invisible bar on bar chart | New Users to Excel | |||
Hybrid Mode
