Microsoft Office Forums - View Single Post - IF formula returns wrong result

Thread: IF formula returns wrong result

View Single Post

Old

09-07-2012, 12:45 AM

mashley

mashley is offline

mashley uses Windows 7 32bit

Windows 7 32bit mashley uses Office 2007

mashley uses Office 2007

Office 2007

Novice

The original poster

Join Date: Sep 2012

Posts: 3

mashley is on a distinguished road

Default

OK, I have found that if I evaluate the formula, I can see that

G262 gets a value of 8805.1300000000001 while J265 is 8805.13.

But stepping into the evaluation, SUM(G2:G261) = 8805.13, yet this is fed to the IF as 8805.1300000000001.

What is going on here?

Reply With Quote