# Round Function in Excel

In this tutorial, we are going to discuss three functions to round numbers in Excel. ROUND, ROUNDUP, and ROUNDDOWN with examples.

## ROUND Function

The ROUND function in Excel returns a number rounded to a specified number of digits. with this ROUND function, we can do rounds up or down.

## Syntax

=ROUND(number, num_digits)

=ROUNDUP(number, num_digits)

=ROUNDDOWN(number, num_digits)

Arguments Explained:

• number -The number that you want to round (Required).
• num_digits - The number of digits to which you want to round the number argument(Required).

### Round Function Examples

1. Round a number to one decimal.

In the below example, the amount 12323.51768 is showing as 12323.5 after applying Round formula on cell B2.

2. Round a number to two decimal.

In the below example, the amount 12323.51768 is showing as 12323.52 after applying Round formula on cell B2.

Similarly, you can also Round a number to three decimal places.

If you want to

• Round to the nearest 10 use -1
• Round to nearest 100 use -2
• Round to nearest 1000 use -3, etc.

Result is

## ROUNDUP Function in Excel

The Excel ROUNDUP function always rounds a number up. ROUNDUP behaves like ROUND, except that it always rounds a number up.

ROUNDUP Function Example:

## ROUNDDOWN Function in Excel

The Excel ROUNDDOWN function always rounds a number down. it always rounds a number down towards zero.

ROUNDDOWN Function Example:

More..

More..

More..