Hi - I'm stumped by this problem ... Excel 2007 on Win7 Pro 32



I have a simple test: =IF(G262=J265,"OK","ERROR")

My problem: both G262 and J265 contain the value 8805.13, but instead of OK, I get ERROR!

G262 gets its value from a sum =SUM(G2:G261)

J265 gets its value from an addition: =E262+F262+I262+J262

I have ensured all fields have the same format (was currency, tried number, made no difference).

I have also tried forcing for Value (e.g. IF(VALUE(G262)=VALUE(J265),"OK","ERROR") but that makes no difference.

But, if I manually type 8805.13 in G262, the IF works as it should!!!

What is going on here???