#### The ROUND Function

The ROUND function rounds a number to a specified number of digits. The syntax is:

=ROUND(number, num_digits)

**number**: The number you want to round.**num_digits**: The number of digits to which you want to round the number.

For example:

**=ROUND(A2, 1)**: Rounds the value in cell A2 to one decimal place.**=ROUND(A2, -1)**: Rounds the value in cell A2 to the nearest ten.

#### Rounding to the Nearest Integer

To round a number to the nearest integer, use the ROUND function with a **num_digits** argument of 0:

=ROUND(A2, 0)

#### Rounding to a Specified Number of Decimal Places

To round a number to a specified number of decimal places, use the ROUND function with a **num_digits** argument greater than 0:

=ROUND(A2, 2)

#### Rounding Up (ROUNDUP Function)

The ROUNDUP function rounds a number up, away from 0 (zero), to the nearest multiple of significance. The syntax is:

excelCopy code

=ROUNDUP(number, num_digits)

**number**: The number you want to round.**num_digits**: The number of digits to which you want to round the number.

For example:

**=ROUNDUP(A2, 1)**: Rounds the value in cell A2 up to one decimal place.**=ROUNDUP(A2, -1)**: Rounds the value in cell A2 up to the nearest ten.

#### Rounding Down (ROUNDDOWN Function)

The ROUNDDOWN function rounds a number down, toward 0 (zero), to the nearest multiple of significance. The syntax is:

excelCopy code

=ROUNDDOWN(number, num_digits)

**number**: The number you want to round.**num_digits**: The number of digits to which you want to round the number.

For example:

**=ROUNDDOWN(A2, 1)**: Rounds the value in cell A2 down to one decimal place.**=ROUNDDOWN(A2, -1)**: Rounds the value in cell A2 down to the nearest ten.

#### The MROUND Function

The MROUND function rounds a number to the nearest multiple. The syntax is:

excelCopy code

=MROUND(number, multiple)

**number**: The number you want to round.**multiple**: The multiple to which you want to round the number.

For example:

**=MROUND(A2, 10)**: Rounds the value in cell A2 to the nearest ten.

#### The FLOOR Function

The FLOOR function rounds a number down, toward 0 (zero), to the nearest multiple of significance. The syntax is:

excelCopy code

=FLOOR(number, significance)

**number**: The number you want to round.**significance**: The multiple to which you want to round the number. It can be positive, negative, or 0 (zero). If omitted, it is assumed to be 1.

For example:

**=FLOOR(A2, -1)**: Rounds the value in cell A2 down to the next lowest ten.

#### The CEILING Function

The CEILING function rounds a number up, away from 0 (zero), to the nearest multiple of significance. The syntax is:

excelCopy code

=CEILING(number, significance)

**number**: The number you want to round.**significance**: The multiple to which you want to round the number. It can be positive, negative, or 0 (zero). If omitted, it is assumed to be 1.

For example:

**=CEILING(A2, -1)**: Rounds the value in cell A2 up to the next highest ten.