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. Apr 9 in Others 81 views

## 1 answer to this question.

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.

• 63,000 points

## why linux is more secure than any other operating system?

First thing i would like to tell ...READ MORE

## I want to make Excel read a value in Calc and copy it to my sheet in Excel

Here is the sample code that will allow ...READ MORE

## Why this Excell formula that take the value of a cell and concatenate to the value or another cell is not working?

If J17's value is a true or ...READ MORE

## Is there a maximum number of formula fields allowed in Excel (2010)

See http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010073849.aspx for limits on specs it doesn't indicate ...READ MORE

## Multiplying cells and sum then for a range

Use SUM() as an Array formula:  =SUM(IFERROR((AB22:AB1100 = ...READ MORE

## INDEX formula in Excel, Top 10, repeats previous value

Try this formula in cell W4: =IF(V3=V4,INDEX(INDIRECT("I"&MATCH(W3,I:I,0)+1&":I26"),MATCH(V4,INDIRECT("R"&MATCH(W3,I:I,0)+1&":R26"),0)),INDEX(\$I\$2:\$I\$26,MATCH(V4,\$R\$2:\$R\$26,0))) The calculation ...READ MORE