ROUND, ROUNDUP and ROUNDDOWN
Round the stored value, not just the display, so totals match what people see, and round up, down or to the nearest hundred or thousand.
In this lesson
- A number format only changes how a number looks.
ROUNDUPalways goes up (cases, boxes, people needed).- Round where a number becomes a price or quantity someone sees, then calculate from the rounded value.
Try a free lesson first
Why your formula broke when you copied it
Lock a cell with $ so a formula keeps working when you copy it down.
Beginner · 7 min · Free, with no sign-up
Do the free lesson on your computer.
Send yourself the link and open it on a laptop or desktop.
On your computer, go tolearnford.com/go/39MP
This lesson is in the full Google Sheets course
US$149 once
Tax included. New lessons are added as they're written.
Get the full course, US$14930-day money-back guarantee if you've opened fewer than 10 paid lessons.
- All 215 Google Sheets lessons open today, and every new one as it's written.
- The Roadmap, Skills and all seven paths.
- A cheat sheet for every lesson you finish.
- Skill
- Math and statistics
- Stage
- Beginner
- Path
- Reports that don't break
Where it sits in Math and statistics
- SUM, AVERAGE, MIN and MAX8 min
- COUNT, COUNTA and COUNTBLANK7 min
- ROUND, ROUNDUP and ROUNDDOWNThis lesson10 min
- SUMIF and COUNTIF12 min
- SUMIFS and COUNTIFS with several conditions11 min
- AVERAGEIF and AVERAGEIFS11 min
The steps
10 steps: 4 explanations, 4 Do this, 2 questions, then Your turn.
Try a free lesson first
Why your formula broke when you copied it
Lock a cell with $ so a formula keeps working when you copy it down.
Beginner · 7 min · Free, with no sign-up
Do the free lesson on your computer.
Send yourself the link and open it on a laptop or desktop.
On your computer, go tolearnford.com/go/39MP