Easy: ROUND vs displayed decimals
Unit prices have more decimals than the 0.00 display. Line = Qty*Unit keeps hidden precision; printed SUM of displayed digits can disagree. ROUND each line to 2 decimals.
Unit मध्ये hidden decimals आहेत. Display 0.00 पण SUM पूर्ण precision वापरते. ROUND(...,2) वापरा.
Unit में hidden decimals हैं। Display 0.00 पर SUM पूरी precision लेता है। ROUND(...,2) करें।
Why → What → How
Why: Finance printouts vs Excel totals is a classic trust-breaker.
What: Four lines; broken uses raw product. Fixed wraps ROUND(...,2).
How:
- Open Invoice.
- Compare formula bar decimals vs display.
- Change Line to =ROUND(B*C,2).
- Agree print and SUM.
Ravindra Bagale’s Tip
Display format never changes stored precision — ROUND (or banker’s rules your finance team specifies) does.
Ravindra Bagale’s Tip – मराठी
Display format stored value बदलत नाही — ROUND बदलते.
Ravindra Bagale’s Tip – हिंदी
Display format stored value नहीं बदलता — ROUND बदलता है।
Bugs explained (with mini examples)
Bug 1 — Display ≠ storage
Bug 2 — SUM of full precision
Practice tasks (12)
- Task 1. Show formula bar for Unit of Croissant.Hint: >2 decimals.
- Task 2. Broken Line formula.Hint: =B*C.
- Task 3. Fixed Line formula.Hint: =ROUND(B*C,2).
- Task 4. Why printouts drift.Hint: Hidden precision.
- Task 5. Interview sentence.Hint: “We needed ROUND to match the printout.”
- Task 6. Apply ROUND to all lines.Hint: Fill.
- Task 7. Does formatting alone fix SUM?Hint: No.
- Task 8. Accounting ROUND vs TRUNC.Hint: Know the policy.
- Task 9. Add a line and keep ROUND.Hint: Habit.
- Task 10. Check total after fix.Hint: SUM of rounded.
- Task 11. Bonus: use ROUND on the total only — discuss tradeoff.Hint: Line vs total.
- Task 12. Document the rule.Hint: Team note.
In-browser formula check
Type the fixed formula you would put in the named cell. We check formula text — open the workbook for full recalculation.
Step-by-step solution (try first)
- D5:D8 =ROUND(B*C,2).
- SUM matches a 2-decimal printout.
Quick quiz