Can you help me again?

[Guest]

I'm using the formula below rather than getting blank if
the statement is false, I'm getting a zero, can you help?


=IF(-K17>=K16,-K17-K16-K40," ")

 

[Andy B]

Hi

The only way I can get a zero is if the TRUE portion resolves to zero! If
it's false I get a blank.

 

[Guest]

Andy, I'm confused I still get 0 rather than blank, UGH!

 

[David McRitchie]

Hi ....................,
I generated random data for K16, K17, K40 and I get space
D24: =IF(-K17>=K16,-K17-K16-K40," ")
22 D25: =K16
33 D26: =K17
4 D27: =K40

0 D24: =IF(-K17>=K16,-K17-K16-K40," ")
0 D25: =K16
0 D26: =K17
0 D27: =K40


formula is same as
=IF((-K17)>=K16, (-K17)-K16-K40," ")

too much guesswork, no name (anonymous) , none descriptive subject
and above all what values do you have for K17, K16, K40.

Also Excel keeps track of more decimal places that you see and
there are also base 2 base 10 considerations

Depends on the language, but Excel refers to a blank as an
empty cell and an empty cell can never be empty. So you might
want to say space rather than blank when talking about Excel.

 

[Llobid]

Anonymous...

The formula seems to work fine when I tried it. You might try takin
the space out from between your quotes ("" instead of " ")...althoug
that shouldn't matter. You might also check to see how the formula cel
is formatted. I can't imagine what kind of formatting might cause thi
problem, but check it out. Another possible troubleshooting tip woul
be to insert another column adjacent to the one where the formula i
now. Rewrite the formula in that column and see if it works. If so, tr
copying and pasting the information from the first column to th
second...then delete the first