ROUNDUP, ROUNDDOWN, TRUNC & INT with Negative Numbers
This lesson is part of the course
In this lesson
Juniper's stock moves include returns (negative units). You count the boxes to move with ROUNDUP, the full boxes with TRUNC (not INT!), the loose units, and name the function that behaves differently on negatives.
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