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.

Zero2Hero — Zéro2Héros