Rounding Issue

[Excel_77]

Hi All,

I have three values feeding into three cells on a separate tab (tab 2)

Overall Total - 650,281.44
Value 1 - 311126.58
Value 2 - 339154.86

On tab 2, the overall total is recording as £650,281, it has been set to turn yellow if this value does not equate to value 1 and 2 being added so clearly we have a rounding issue here.

How can this be resolved?

 

[AlanY]

try to change the CF formula to something like

=ROUND(Total,0)=ROUND(Value1+Value2,0)

 

[Scott T]

You may be running into the floating point error
https://support.microsoft.com/en-us...ithmetic-may-give-inaccurate-results-in-excel

You should be able to use round to round it to two decimals.