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