Making a 0 invisible with a formiula

  • Thread starter Thread starter marvin
  • Start date Start date
M

marvin

I have put a formula in in a worksheet and wish to make the 0 invisibl
when it comes up. The worksheet is already in the in the don't displa
mode. I tried the make the 0 white and that did not work . the formul
that I am using =if(B8<=149,"1","0") can anybody help.

Thank Yo
 
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,"")
 
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
 
Back
Top