Excel: ROUND, ROUNDUP and ROUNDDOWN
Sign up free to unlock this topic
Kindergarten is free, and guests can try one sample topic in every other grade. A free parent or teacher account opens every topic from Kindergarten to Grade 12, college and university, and saves progress. No credit card.
Try the free sample: The ideal gas law · Have a class or homeroom code? Join here
Key idea: Excel: ROUND, ROUNDUP and ROUNDDOWN
ROUND(number, digits) rounds normally, ROUNDUP always goes up and ROUNDDOWN always goes down. 0 digits means a whole number.
Key words
- ROUNDUP
- Boxes, buses, anything you can't have part of.
- ROUNDDOWN
- Only complete groups count.
🔎 What to look for: Formatting only changes how a number looks; ROUND changes the value.
