Percentages That Must Add to 100%
This lesson is part of the course
In this lesson
Juniper's channel mix rounded to whole percentages adds up to 101%. You round the shares, show the total, adjust the largest share so the mix adds to exactly 100% and chart it as a pie.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- ROUND vs Display Formatting: Sum of Rounded vs Rounded Sum Locked
- ROUNDUP, ROUNDDOWN, TRUNC & INT with Negative Numbers Locked
- MROUND, CEILING & FLOOR: Price Points, Case Sizes & 15-Minute Billing Locked
- Currency Rounding & VAT: Per Line vs Per Invoice Locked
- Rounding Differences & Penny Allocation (Largest Remainder) Locked
- Floating-Point Surprises: Hidden Decimals & Safe Comparisons Locked
- Percentages That Must Add to 100% Locked
- TEXT for Display vs Value & a Chart of Rounding Error Locked