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