Round, RoundUp and RoundDown in Excel

 May 08, 2015

This article explains the three functions to round numbers in Excel – the ROUND, ROUNDUP and ROUNDDOWN function.

Note: Before your start, if you round a number, you lose precision. If you don't want this, show fewer decimal places without changing the number itself. Also,  mathematically, the numbers 1, 2, 3, and 4 get rounded down while 5, 6, 7, 8, and 9 get rounded up.

ROUND
  • Round a number to two decimal places: =ROUND(A1,2)
  • Round a number to one decimal place: =ROUND(A1,1)
  • Round a number to the nearest integer (or whole number): =ROUND(A1,0)
  • Round a number to the nearest 10: =ROUND(A1,-1)
  • Round a number to the nearest 100: =ROUND(A1,-2)
ROUNDUP

The ROUNDUP function always rounds a number up (away from zero).

  • Round a number up to one decimal place: =ROUNDUP(A1,1)
  • Round a number up to the nearest integer (or whole number): =ROUNDUP(A1,0)
ROUNDDOWN

The ROUNDDOWN function always rounds a number down (toward zero).

  • Round a number down to one decimal place: =ROUNDDPWN(A1,1)
  • Round a number down to the nearest integer (or whole number): =ROUNDDOWN(A1,0)

How do your Excel skills stack up?   

Test Now  

Tags

Excel 2013 Microsoft Excel 2010 Excel microsoft excel round roundup rounddown

How do
your Excel skills
stack up?

Grade your skills now

About the Author:

Alice Antonsen  

Alice is one of New Horizons’ most experienced Desktop Applications trainers. She is qualified with a Diploma of Business (Computing) and a Diploma of Information Technology. Since joining New Horizons in 2006, Alice has achieved the prestigious status of a certified Microsoft Office Master and for the past 4 years, has been placed in the Top 25 Desktop Applications trainers for New Horizons Worldwide. Throughout her career, she has gained a wealth of knowledge and experience in providing training to individuals and groups of varying skill levels. Alice delivers each training session with great care and consideration ensuring each one is tailored to the learning needs of her students.

Read full bio

Next up:

Previously

top