medium10 pts · first answer countsexcelroundingformatting

Total is off by 0.01

Three cells each contain =10/3 and are formatted to 2 decimals, showing 3.33. Their SUM shows 10.00, but 3.33 + 3.33 + 3.33 is 9.99. Why?

A.Formatting hides decimals; the stored values are not roundedB.SUM always rounds results up to the next whole numberC.Excel adds 0.01 to fix display rounding errorsD.The cells were formatted as text before the SUM was entered

Discussion 0

Join free to post in the discussion.

Total is off by 0.01

Discussion 0

Related questions