if with false outcome

[Jan Kalop]

What is wrong if in worksheet "SUMS" in cell A1 value (from simple formula =SUM(A10:A20) is 9 and in worksheet "Totals" the same formula =SUM(SUMS!A10:A20) and with exactly
the same value 9 in cell C1, give false, when if in cell D1 of worksheet "Totals" is formula =IF(SUMS!A1=TOTALS!C1,"OK","??") and as result, it come ??.
I have check conditional formatting and many other combination and I can't fine what is wrong. Anybody can help with any suggestion, please.
Every value in A10:A20 in worksheet SUMS is with two decimal places and some are negative value.
All cells with SUM formula in both worksheets are formatted as number with two decimal places as well.

 

[Legacy 386498]

Would it be possible for you to share your workbook so I can assist you.

 

[sandy666]

formatting doesn't change decimals

maybe use --FIXED() function which has 2 decimals by default without any parameters

 

[Peter_SSs]

It is quite likely a floating-point arithmetic issue. What happens if you try this formula instead?

=IF(ROUND(SUMS!A1,2)=ROUND(Totals!C1,2),"OK","??")

 

[Jan Kalop]

It is quite likely a floating-point arithmetic issue. What happens if you try this formula instead?

=IF(ROUND(SUMS!A1,2)=ROUND(Totals!C1,2),"OK","??")

Yes ....thankyou very much, but I stiil do not understad why this is happening, because I have a lot of very similar calculation involve both worksheets and all working without any problem, but that one, cell A1 (worksheet SUMS) and C1 (worksheet Totals) gave me a headache.

 

[Peter_SSs]

but I stiil do not understad why this is happening

Did you read the article I linked to?

 

[Jan Kalop]

Did you read the article I linked to?

yes thanks, I am getting into, looks very complex and I don't know how I will digest that, anyhow not now because it is late at my place, but I will dig into tomorrow. Thanks for helping .