Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"IF" stmt says two cells are different but they are NOT
I need help troubleshooting an IF stamtent that is determining that the
values in two cells are different. The statement is literally =IF((K5+K18-K37)=(I5+I18-I37),"Balances","Out of Balance") The "K" series and the "I" series all evaluate to exactly the same thing so the statement should be evaluating as TRUE but evaluates as FALSE. I have removed as many variables as possible - for instance the series are the results of other calculations, but I've dummied it down to just looking at the values and it still tays they aren't equal. I've seen this type of thing before related to the cell formats, but in this case the formats are identical. I'm at the end of my rope - anybody out there have anything left??? Most appreciated - Steve |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
"IF" stmt says two cells are different but they are NOT
How many digits of precisions are your calculations using?
Perhaps you are viewing data in currency format but the calculation itself is calculating thousandths, ten-thousandths, etc., of precision. This could account for the unequal values. Dave stebro wrote: I need help troubleshooting an IF stamtent that is determining that the values in two cells are different. The statement is literally =IF((K5+K18-K37)=(I5+I18-I37),"Balances","Out of Balance") The "K" series and the "I" series all evaluate to exactly the same thing so the statement should be evaluating as TRUE but evaluates as FALSE. I have removed as many variables as possible - for instance the series are the results of other calculations, but I've dummied it down to just looking at the values and it still tays they aren't equal. I've seen this type of thing before related to the cell formats, but in this case the formats are identical. I'm at the end of my rope - anybody out there have anything left??? Most appreciated - Steve |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
"IF" stmt says two cells are different but they are NOT
I have to ask first, have you typed into the cell =K5+K18-K37, then in
another cell, =I5+I18-I37? If they show as matching, you may want to round in case that's the issue... =IF(ROUND((K5+K18-K37,0)=ROUND(I5+I18-I37,0),"Balances","Out of Balance") "stebro" wrote: I need help troubleshooting an IF stamtent that is determining that the values in two cells are different. The statement is literally =IF((K5+K18-K37)=(I5+I18-I37),"Balances","Out of Balance") The "K" series and the "I" series all evaluate to exactly the same thing so the statement should be evaluating as TRUE but evaluates as FALSE. I have removed as many variables as possible - for instance the series are the results of other calculations, but I've dummied it down to just looking at the values and it still tays they aren't equal. I've seen this type of thing before related to the cell formats, but in this case the formats are identical. I'm at the end of my rope - anybody out there have anything left??? Most appreciated - Steve |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
"IF" stmt says two cells are different but they are NOT
Thanks Dave for your assistance. All cells involved in this computation are
out-of-the-box "Numeric, 2 decimal places, comma for thousands". Also if it matters I'm using Excel 2003. Steve "Dave F" wrote: How many digits of precisions are your calculations using? Perhaps you are viewing data in currency format but the calculation itself is calculating thousandths, ten-thousandths, etc., of precision. This could account for the unequal values. Dave stebro wrote: I need help troubleshooting an IF stamtent that is determining that the values in two cells are different. The statement is literally =IF((K5+K18-K37)=(I5+I18-I37),"Balances","Out of Balance") The "K" series and the "I" series all evaluate to exactly the same thing so the statement should be evaluating as TRUE but evaluates as FALSE. I have removed as many variables as possible - for instance the series are the results of other calculations, but I've dummied it down to just looking at the values and it still tays they aren't equal. I've seen this type of thing before related to the cell formats, but in this case the formats are identical. I'm at the end of my rope - anybody out there have anything left??? Most appreciated - Steve |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
"IF" stmt says two cells are different but they are NOT
"I need help troubleshooting an IF stamtent that is determining that the
values in TWO cells are different." i maybe confused with this =IF(AND(K5=I5,K18=I18,K37=I37),"Balances","Out of Balance") happy holidays dribler2 "stebro" wrote: I need help troubleshooting an IF stamtent that is determining that the values in two cells are different. The statement is literally =IF((K5+K18-K37)=(I5+I18-I37),"Balances","Out of Balance") The "K" series and the "I" series all evaluate to exactly the same thing so the statement should be evaluating as TRUE but evaluates as FALSE. I have removed as many variables as possible - for instance the series are the results of other calculations, but I've dummied it down to just looking at the values and it still tays they aren't equal. I've seen this type of thing before related to the cell formats, but in this case the formats are identical. I'm at the end of my rope - anybody out there have anything left??? Most appreciated - Steve |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
"IF" stmt says two cells are different but they are NOT
try look at the decimals, - format values with fx. 10-20 decimals
"stebro" skrev: I need help troubleshooting an IF stamtent that is determining that the values in two cells are different. The statement is literally =IF((K5+K18-K37)=(I5+I18-I37),"Balances","Out of Balance") The "K" series and the "I" series all evaluate to exactly the same thing so the statement should be evaluating as TRUE but evaluates as FALSE. I have removed as many variables as possible - for instance the series are the results of other calculations, but I've dummied it down to just looking at the values and it still tays they aren't equal. I've seen this type of thing before related to the cell formats, but in this case the formats are identical. I'm at the end of my rope - anybody out there have anything left??? Most appreciated - Steve |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
"IF" stmt says two cells are different but they are NOT
Sean - you get the prize. I modified your response to round to two places
instead of zero, but this worked. I can't say I understand, since everything is formatted the same, but it does work, so now I can get on with more productive things. This forum is wonderful! Steve "Sean Timmons" wrote: I have to ask first, have you typed into the cell =K5+K18-K37, then in another cell, =I5+I18-I37? If they show as matching, you may want to round in case that's the issue... =IF(ROUND((K5+K18-K37,0)=ROUND(I5+I18-I37,0),"Balances","Out of Balance") "stebro" wrote: I need help troubleshooting an IF stamtent that is determining that the values in two cells are different. The statement is literally =IF((K5+K18-K37)=(I5+I18-I37),"Balances","Out of Balance") The "K" series and the "I" series all evaluate to exactly the same thing so the statement should be evaluating as TRUE but evaluates as FALSE. I have removed as many variables as possible - for instance the series are the results of other calculations, but I've dummied it down to just looking at the values and it still tays they aren't equal. I've seen this type of thing before related to the cell formats, but in this case the formats are identical. I'm at the end of my rope - anybody out there have anything left??? Most appreciated - Steve |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
"IF" stmt says two cells are different but they are NOT
Couldn't help but to respond. Thank you for the prize!
The reason seems to be that the cells you are checking, though formatted to 2 decimal points, still retain values that extend beyond 2 decimal points. Unfortunately, formatting does not remove these dditional decimal places... "stebro" wrote: Sean - you get the prize. I modified your response to round to two places instead of zero, but this worked. I can't say I understand, since everything is formatted the same, but it does work, so now I can get on with more productive things. This forum is wonderful! Steve "Sean Timmons" wrote: I have to ask first, have you typed into the cell =K5+K18-K37, then in another cell, =I5+I18-I37? If they show as matching, you may want to round in case that's the issue... =IF(ROUND((K5+K18-K37,0)=ROUND(I5+I18-I37,0),"Balances","Out of Balance") "stebro" wrote: I need help troubleshooting an IF stamtent that is determining that the values in two cells are different. The statement is literally =IF((K5+K18-K37)=(I5+I18-I37),"Balances","Out of Balance") The "K" series and the "I" series all evaluate to exactly the same thing so the statement should be evaluating as TRUE but evaluates as FALSE. I have removed as many variables as possible - for instance the series are the results of other calculations, but I've dummied it down to just looking at the values and it still tays they aren't equal. I've seen this type of thing before related to the cell formats, but in this case the formats are identical. I'm at the end of my rope - anybody out there have anything left??? Most appreciated - Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need to paste link from 4 vertical cells to 4 horizontal cells? | Excel Discussion (Misc queries) | |||
Merge Cells | Excel Discussion (Misc queries) | |||
Use the Merge & Center Button with unprotected Cells - sheet prote | Setting up and Configuration of Excel | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |