If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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," ") |
#2
|
|||
|
|||
Can you help me again?
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," ") |
#3
|
|||
|
|||
Can you help me again?
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," ") . |
#4
|
|||
|
|||
Can you help me again?
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," ") |
#5
|
|||
|
|||
Can you help me again?
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/ |
Thread Tools | |
Display Modes | |
|
|