Floating-Point Surprises: Hidden Decimals & Safe Comparisons
This lesson is part of the course
In this lesson
Juniper books euro invoices in dollars. The booked amounts carry hidden decimals, so a plain = comparison says most payments do not match. You compare at cent level, count the real matches and the cells with hidden decimals.
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