Display a blank instead of a zero

[Phillip]

I have an IF statement formula. If the formula results in FALSE, I would like it to leave the cel empty instead of placing the number 0 in it. I have tried using "" and I have tried using " " but it still puts a zero in. Here are the formulas I've tried

IF(A1:A100=Z1, 1, " "
IF(A1:A100=Z1, 1, ""

Is there a way to leave a cel blank if the number result is a zero?

Thank you very much!

 

[Dave R.]

On my computer, they give blanks if the value of Z1 isn't in A1 so that part
seems to be working, but I don't know what your formula is trrying to do
though, the most it would do is look at A1....

I have an IF statement formula. If the formula results in FALSE, I would

like it to leave the cel empty instead of placing the number 0 in it. I have
tried using "" and I have tried using " " but it still puts a zero in. Here
are the formulas I've tried:

 

[Phillip]

Ooops. Sorry, I don't think I properly defined the problem. The IF formula I'm using functions properly. If the result is TRUE then it displays the number 1 in the cel. If the result is FALSE it displays the number 0 in the cel. I would like the cel to remain empty when the result is FALSE. In other words, instead of putting the number zero in the cel as the result, I would just like the cel to remain empty. Any way to do this

The formulas I've tried using are more correctly entered as

IF(A1=Z1, 1, " "
IF(A1=Z1, 1, ""

Thanks again

----- Dave R. wrote: ----

On my computer, they give blanks if the value of Z1 isn't in A1 so that par
seems to be working, but I don't know what your formula is trrying to d
though, the most it would do is look at A1...

I have an IF statement formula. If the formula results in FALSE, I woul

like it to leave the cel empty instead of placing the number 0 in it. I hav
tried using "" and I have tried using " " but it still puts a zero in. Her
are the formulas I've tried

 

[Dave R.]

Phillip,
Either of your 2 formulas will return a blank-appearing cell when A1 does
not equal Z1, though I would stick with the 2nd one that uses "" opposed to
" ". I have no idea why your cell would show 0 instead of appearing blank. A
quick test you can do, instead of "" or " ", try "blank" and see if the word
"blank" shows up there.

If I had to guess, I'd say it might be related to your cell or workbook
formatting but I don't know all the innerds of Excel as some people around
here do. I'd try creating a new workbook for yourself, put 100 in A1, put
100 in B1, then type that formula into C1 to see what it gives you (a 1).
Then change either A1 or B1 and C1 should be blank. If not, try looking
under Options for something related to blank cells and 0.

Good luck.

Ooops. Sorry, I don't think I properly defined the problem. The IF formula

I'm using functions properly. If the result is TRUE then it displays the
number 1 in the cel. If the result is FALSE it displays the number 0 in the
cel. I would like the cel to remain empty when the result is FALSE. In other
words, instead of putting the number zero in the cel as the result, I would
just like the cel to remain empty. Any way to do this?