# 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(A1,0) -> result is 258

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

=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:

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