Excel Rounding & Precision: ROUND, MROUND, CEILING, Currency & Floating-Point Traps
ROUND vs number formats, ROUNDUP/TRUNC/INT with negatives, MROUND and CEILING for prices, cases and time, VAT per line vs per invoice, penny allocation, floating-point comparisons and percentages that add to 100%, in 8 hands-on labs at one roastery.
The first lesson is free — no account needed.
About this course
An Excel rounding and precision course for anyone whose invoices, price lists or reports are a cent off, built on one fictional coffee roastery. You see why a sum of rounded lines differs from a rounded sum and which belongs on the invoice, count boxes with ROUNDUP and full boxes with TRUNC instead of INT when returns make quantities negative, set prices to the nearest 5 cents with MROUND and to .99 charm prices with CEILING, round up to full cases and to started quarter hours, compare VAT rounded per line with VAT on the invoice total, split a freight bill so the cents add up with the largest remainder method, compare amounts with hidden decimals safely, make rounded percentages add to exactly 100% and build "$48k" labels with TEXT without changing the values. The first lab is free.
Lessons
- ROUND vs Display Formatting: Sum of Rounded vs Rounded SumFree
- ROUNDUP, ROUNDDOWN, TRUNC & INT with Negative Numbers Pro
- MROUND, CEILING & FLOOR: Price Points, Case Sizes & 15-Minute Billing Pro
- Currency Rounding & VAT: Per Line vs Per Invoice Pro
- Rounding Differences & Penny Allocation (Largest Remainder) Pro
- Floating-Point Surprises: Hidden Decimals & Safe Comparisons Pro
- Percentages That Must Add to 100% Pro
- TEXT for Display vs Value & a Chart of Rounding Error Pro