Strange compare result

[MDOC]

Cell H520 contains this formula:
=IF(H507=P522,"Ally Savings totals: match.","Ally Savings totals: NO MATCH!")

H507 contains a summed formula for a range of rows and correctly shows the value of $991.50.
P522 contains a summed formula for a different range of different rows and correctly shows the value of $991.50.
Yet the result of the H520 cell formula returns false instead of true when both H507 and P522 are compared.
So I evaluated each part of that formula through "Evaluate Formula" button in the formula menu item of Excel 2007:

H507 evaluates to $991.500000000001 instead of $991.50,
which triggers a false Boolean result instead of true.
P522 correctly evaluates to $991.50.
Both H507 and P522 are formatted in "Accounting" format.

See the evaluate box:
formula-error.jpg


How do I fix this?

[MrShorty]

The cause is standard computer round off error inherent in all computer calculations.

Around here, the first suggestion is to use the ROUND() function somewhere in there. Either put the ROUND() function around the SUM() function in H507 or put the ROUND function around the H507 reference in the IF() function. Considering that this sort of thing is part of all computer calculations, you probably also need to put a ROUND() function around P522 (and any other formulas in the sheet that could possibly be effected by round off error).

[chief_abound]

https://support.microsoft.com/en-au/...int-arithmetic

[MDOC]

The cause is standard computer round off error inherent in all computer calculations.

Around here, the first suggestion is to use the ROUND() function somewhere in there. Either put the ROUND() function around the SUM() function in H507 or put the ROUND function around the H507 reference in the IF() function. Considering that this sort of thing is part of all computer calculations, you probably also need to put a ROUND() function around P522 (and any other formulas in the sheet that could possibly be effected by round off error).

Thanks, this worked. I put it around the sum function in H507. Will consider putting it in other places.