Jan Kalop
Active Member
- Joined
- Aug 3, 2012
- Messages
- 389
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.
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.