I prepared a data profile that included classifying the data and then using SUM to add up the values.

I prepared another analysis as preparation to draw a histogram and then used SUM to add up the values.

Then I created a very simple IF statement to check that total 1 = total 2 … they didn’t agree. For some reason, although ALL values have only two decimal places, when added together, total 1 could be expanded to …247.900883 while total 2 could be expanded to 247.90003.

As a workaround I amended the IF statement:

=IF(INT(A1)=INT(B1),”Reconciled”,”Error”) … that worked

and so did this:

=IF(ROUND(A1,3)=ROUND(B1,3),”Reconciled”,”Error”) but =IF(ROUND(A1,4)=ROUND(B1,4),”Reconciled”,”Error”) did NOT work, for what is probably an obvious reason!