Can you help me again?

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

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.

--
Andy.


wrote in message
...
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, I'm confused I still get 0 rather than blank, UGH!
-----Original Message-----
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.

--
Andy.


wrote in message
...
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," ")


.

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.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

wrote ...
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," ")

Anonymous...

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


---
Message posted from http://www.ExcelForum.com/