Why is my excel calculation bringing back a value other than zero

Question

I have a spreadsheet in Excel with data organized in 3 rows and 4 columns and structured as currency with 2 decimal spaces. The following formula, IFERROR(C2-(A2+B2),"" appears in the fourth column. I want to use conditional formatting to make the D value turn red if it is greater than 0. Except for the final row, this works for all rows. When I "insert special values" into the following cell after copying the data from column D, D4 returns 5.96046E-08 rather than zero, as it did for the previous cells. Any assistance in deciphering why this is taking place would be highly appreciated.

Answer 1

Column D's formula should be changed so that the result is rounded to the right amount of decimal places. Use the ROUND function, for instance, if you are working with currency and two decimal places:

=IFERROR(ROUND(C2-(A2+B2), 2), "")

This will eliminate the issue of minor inaccuracies by rounding the calculation's result to two decimal places.