I got number -3569.6322124015200000 in A1
I got number 4157.93943509912000000 in A2
Both cells have been formated as number 16 dp to allow me to see whats going on
If I use Round in both cells, such as
In cell B1 =ROUND(A1,2) / Now displays -3569.6300000000000000
in cell B2 =ROUND(A2,2) / Now displays 4157.9400000000000000
Now I add both cells together
In cell B3 =B1+B2 / displays 588.3099999999999999 !!!!!!
So how is that possible if indeed the rounding is occuring to 2 dps in cells
B3 should display 588.3100000000000000 because both B1 and B2 were rounded to 2dps
Thats means when I do the comparison operation (B1+B2=588.31) it returns FALSE!!!!
B1+B2 should return 588.310000000000000 not 588.3099999999999999
does anyone know whats going on here??
Bookmarks