Floating-Point Surprises: Hidden Decimals & Safe Comparisons
This lesson is part of the subscription
The first lesson of every course is free. A subscription unlocks all lessons, labs, exams and certificates.
Or start the free course: Excel for Finance
Lessons in this course
- 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