Author: Oscar Cronquist Article last updated on May 28, 2021

How to use the ROUND function

The ROUND function calculates a rounded number based on the number of digits you specify.

Formula in cell D3:

=ROUND(B3, C3)

Excel Function Syntax

ROUND(number, num_digits)

Arguments

number Required. The value to round.
num_digits Required. A number representing the digit you want to round down to.

Comments

The ROUND function rounds

1. How to round a number to its nearest integer (whole number)?

ROUND function nearest integer

Formula in cell D3:

=ROUND(B3, C3)

Back to top

2. How to round a number to n decimals?

ROUND function round to n decimals

Formula in cell D3:

=ROUND(B3, C3)

Back to top

3. How to round a number to the nearest multiple of 10?

ROUND function round to nearest multiple of 10

Formula in cell D3:

=ROUND(B3, C3)

Back to top

4. How to round a number to the nearest multiple of 100?

ROUND function round to nearest multiple of 100

Formula in cell D3:

=ROUND(B3, C3)

Back to top

5. How to round a number to the nearest multiple of 1000?

ROUND function round to nearest multiple of 1000

Formula in cell D3:

=ROUND(B3, C3)

Back to top

6. How to round a number to a specific multiple?

This is something the ROUND function can't do, use the MROUND function.

Back to top