Author: Oscar Cronquist Article last updated on January 20, 2023

How to use the ROUND function

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

1. ROUND Function Syntax

ROUND(number, num_digits)

2. ROUND Function Arguments

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

3. ROUND function example

How to use the ROUND function

Formula in cell D3:

=ROUND(B3, C3)

4. 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

5. How to round a number to n decimals?

ROUND function round to n decimals

Formula in cell D3:

=ROUND(B3, C3)

Back to top

6. 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

7. 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

8. 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

9. 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