Re: Excel 2004 not processing IF correctly

Tech-Archive recommends: Speed Up your PC by fixing your registry

Can't give you an explanation, but thought you might like to know that the
same thing happens in XL 2003 on a PC. That suggests that there is some sort
of logical reasoning behind it, but I have no idea what :(

--
Regards |:>)
Bob Jones
[MVP] Office:Mac

<piersd@xxxxxxxxx> wrote in message
news:1178653919.542224.114460@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I have a spread*** as follows

Col A (numeric, 3dp) value =0.996
Col B (numeric, 3dp) value = 1.001
Col C (Numeric, 3DP) formula = ABS( ColB - ColA)
Col D (General) formula = IF ( ColC >= 0.005, "Y","N")

Col D gives answer of "N", which is clearly wrong.

If you modify ColC to be = ROUND(ABS( ColB - ColA ) ,3)
it gives the correct answer whats up with that?



.

Quantcast