Making a 0 invisible with a formiula

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
 
D

Dave Peterson

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,"")
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Array formula - nee help 0
VBA for Dependents shortcut menu 0
need help in fine-tuning a formula that removes blank cells in a column range 3
If using =MOD(ROW(),2)=0 conditional formatting and want diff fill 1
Sum of values in column A based on 0/1 of column B 2
Autofilling dates 3
Conditional Formatting for #DIV/0! 6
if cell in other worksheet meets criteria, then leave blank. 1

Top