Why doesn't Excel's total match the rounded numbers I can see?
TechnologyI tried a small example in a materials sheet: two cells contain 1.24 each, but display one decimal place as 1.2. Their total displays as 2.5, while adding the visible figures suggests 2.4.
Microsoft distinguishes changing displayed decimal places from changing a number through rounding. Excel's rounding guidance
A colleague suggested “Set precision as displayed.” Should I use that, or decide where an explicit rounding step belongs? I want the report to be understandable without quietly changing the precision of the whole workbook.