Using the Round Function in Excel

The ROUND function in Excel is helpful when you want to round a number in your spreadsheet to a specified number of digits.

The ROUND function takes two arguments, number and num_digits. Let’s examine both of these arguments one at a time.

number: This is the number you are trying to round. You can specify a literal number or use a cell reference.

num_digits: This is the number of digits (or precision) you want to use to round the number. It can be zero (round to the nearest integer), a positive number (round to the right of the decimal point) or a negative number (round to the left of the decimal point). This number can also be specified as a cell reference.

Using the ROUND function in Excel with a literal number

Here are a few examples of using the ROUND function in Excel:

=ROUND(14.89,0) -> result is 15

=ROUND(14.89,1) -> result is 14.9

=ROUND(14.89,-1) -> result is 10

Check out our Excel Lesson Videos to learn how to use more common mathematical functions in Excel.

Using the ROUND function in Excel with a cell reference

You can also use a cell reference for the number argument. Here are a few examples:

ROUND function in Excel - num_digits = 0

=ROUND(A1,0) -> result is 258

ROUND function in Excel - num_digits = 1

=ROUND(A1,1) -> result is 257.8

ROUND function in Excel - num_digits = -1

=ROUND(A1,-1) -> result is 260

Other rounding functions

If you want to force Excel to always round a number up (away from zero), use the ROUNDUP function. Conversely, if you want to force Excel to always round a number down (toward zero), use the ROUNDDOWN function.

If you want to specify the multiple (example 0.5) that Excel uses to round, use the MROUND function.

Not limited to one digit

Remember, you are not limited to just 0, 1 and -1 for the num_digits argument. Here’s a few examples showing the ROUND function in Excel using different variations of the num_digits argument:

ROUND function in Excel variations

Now you know how to use the ROUND function in Excel to round numbers to the exact precision you want.

Comments are closed.


Magoosh blog comment policy: To create the best experience for our readers, we will only approve comments that are relevant to the article, general enough to be helpful to other students, concise, and well-written! 😄 Due to the high volume of comments across all of our blogs, we cannot promise that all comments will receive responses from our instructors.

We highly encourage students to help each other out and respond to other students' comments if you can!

If you are a Premium Magoosh student and would like more personalized service from our instructors, you can use the Help tab on the Magoosh dashboard. Thanks!