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

0 votes

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.

enter image description here

Apr 9 in Others by Kithuzzz
• 38,010 points
119 views

1 answer to this question.

0 votes

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.

answered Apr 9 by narikkadan
• 63,160 points

Related Questions In Others

0 votes
1 answer

why linux is more secure than any other operating system?

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

answered Jul 12, 2018 in Others by kristena1234
• 160 points
1,987 views
0 votes
1 answer

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

answered Oct 27, 2022 in Others by narikkadan
• 63,160 points
173 views
0 votes
1 answer
0 votes
1 answer

Excel COUNTIF formula

Please see MS Excel: COUNTIF Function (WS) You should ...READ MORE

answered Sep 29, 2022 in Others by narikkadan
• 63,160 points
345 views
0 votes
1 answer

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

answered Sep 30, 2022 in Others by narikkadan
• 63,160 points
261 views
0 votes
1 answer

Multiplying cells and sum then for a range

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

answered Oct 2, 2022 in Others by narikkadan
• 63,160 points
385 views
0 votes
1 answer

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

answered Oct 8, 2022 in Others by narikkadan
• 63,160 points
453 views
0 votes
1 answer

Is there a reason why these bars wont line up in my excel chart?

STEPS Hover your mouse over any of the ...READ MORE

answered Nov 8, 2022 in Others by narikkadan
• 63,160 points
206 views
0 votes
1 answer

Excel-VBA - How to identify Target range (more than 1 cell) is deleted in a Worksheet_Change function?

You misunderstand the purpose of the function ...READ MORE

answered Sep 23, 2022 in Others by narikkadan
• 63,160 points
2,621 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP