hard20 pts · first answer countsexcelcalculation

A difference of -2.78E-17

A reconciliation formula =0.5-0.4-0.1 shows 0, but =(0.5-0.4-0.1)*1 shows -2.78E-17, so an IF(…=0) check fails. Why?

A.One of the values was typed as text by mistakeB.Decimals are stored in binary, so tiny errors appearC.Excel cannot subtract more than two numbersD.The cell format is set to scientific notation by default

Discussion 0

Join free to post in the discussion.

A difference of -2.78E-17

Discussion 0

Related questions