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

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

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

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