The ROUND function in Excel helps you round numbers within 2 seconds

When using Excel and having to work with numbers, it is extremely understandable that you will encounter decimals. But do you know how to round these decimals most accurately? Let’s discover now how to use ROUND function in Excel together GhienCongListen to do this work.

What is the ROUND function in Excel?

The ROUND function is a basic function in Excel. This function will be able to help you round to decimal places quickly and efficiently. When using the ROUND function in Excel, you can also combine it with other functions to get the desired number of decimal places.

Advertisement

Syntax of ROUND function in Excel

The syntax of the ROUND function in Excel includes 2 arguments:

=ROUND(number to round, N)

Advertisement

In there:

• If N = 0: round to the nearest integer.
• If N > 0: Rounds to the specified decimal place.
• If N < 0: round to the left of the decimal point.
• Rounded part (maximum number in rounding consideration) less than 5 then round down.
• Rounded part (maximum number in rounding consideration) greater than or equal to 5 then round go up.

How to use the ROUND function in Excel and examples

If you are still confused and can’t figure out how to use the ROUND function in Excel, you can immediately see the example with the corresponding formulas and results below to be able to understand the most clearly.

Advertisement

As the first argument in the function (number to be rounded), you can enter a number directly in brackets or refer to the address of a cell containing the value to be rounded. Depending on your rounding purpose and the value you want to enter to fill in the 2nd argument value in the function.

Functions related to ROUND

ROUNDDOWN and ROUNDUP . functions

In addition to the ROUND function in Excel, you can also refer to two other functions that also have the same rounding function, ROUNDUP and ROUNDDOWN.

ROUNDUP . function

ROUNDUP is a function that will round up to a larger value than the original value, and how much larger the value will depend on whether you enter arguments in the function.

• If WOMEN = 0: round to the nearest integer.
• If WOMEN > 0: Rounds to the specified decimal place.
• If WOMEN < 0: round to the left of the decimal point.

ROUNDDOWN . function

ROUNDDOWN is a function that will round up less than the original value, and how much less will depend on what arguments you enter in the function.

• If WOMEN = 0: round to the nearest integer.
• If WOMEN > 0: Rounds to the specified decimal place.
• If WOMEN < 0: round to the left of the decimal point.

MROUND . function

Unlike the ROUNDUP, ROUNDDOWN or ROUND functions in Excel, the MROUND function will round a number to the nearest multiple of a given other number.

The syntax of the MROUND function is:

=MROUND(number to round, N)

N is the number you want to round to its multiple, which can be a number or a reference to the cell address that contains this value.

Rounding rule of MROUND function:

• Round to the number closest to the number to be rounded but is a multiple of N.
• When two arguments have opposite signs, the result will be #NUM error.
• If one of the two arguments is 0 the return result will be 0.
• If the number N is a decimal, the direction of rounding will be undefined.
• When the number N is more than 2 times the number to round, the return result will be 0.

Notes on using the ROUND function in Excel

• The ROUND function in Excel will best support rounding when rounding from 1-4 digits down and 5-9 digits up.
• The ROUND function can also help you round either to the left or to the right of the decimal point depending on your preference.
• When using the ROUND function, attention should be paid to the 2nd argument (N number) to ensure the desired rounding result.

See more:

With the ROUND function in Excel, you will be able to easily round numbers more accurately and your work will also be much more time-saving. Don’t forget to visit GhienCongListen often.