Excel Round Function: Syntax and Examples of Rounding Numbers

 NOTE: Download Now 70+ Basic and Advanced Excel Exercises

While using Excel for calculations and data processing, you might need to use functions to round decimal digits in tables. If you find it challenging, the information on Excel round function, syntax, and examples provided by Mytour will bring interesting Excel knowledge to you. We will guide you through each step on how to round numbers and how to combine the ROUND function with other related functions. Let's explore!

Understanding Excel's ROUND Function: Usage and Detailed Guide

1. What is the Round function?

Excel's Round function is a Math & Trig function designed specifically to round a decimal digit in an Excel spreadsheet. The formula of the Round function has two arguments, including the number itself and the number of decimal places we want the number to be rounded to.

In Excel, there are three functions for rounding numbers: ROUND, ROUNDUP, and ROUNDDOWN. Their distinction lies in how they round your numbers. Specifically:

- The ROUND function uses general mathematical rules for rounding. Digits less than 5 are rounded down, while digits 5 and above are rounded up.

- The ROUNDUP function rounds up all digits.

- The ROUNDDOWN function rounds down all digits.

2. Syntax of the ROUND function in EXCEL

In Excel, ROUND follows general mathematical rules for rounding numbers. In this ROUND function, the digit to the right of the rounding digit determines whether the number is rounded up or down.

Syntax: ROUND(number,n)

Where:
number: The number to be rounded.
n: Is the argument, n can be negative or positive.

Explanation of different cases for n:
- When n=0: We round to the nearest integer, for example: Round(11.424)=11
- When 0>n: We round to the specified decimal place.
- When n>0: We round to the left of the decimal point.

Usually, for the rounded part less than 5, we round down, and 5 or greater, we round up.
 

3. Examples of using the ROUND function in EXCEL

- For n=0, we round to the nearest integer.

- Result:

- For n>0, the number will be rounded to the specified decimal place. If n=1, round to 1 decimal place, n=2, round to 2 decimal places,…

- Result:

For 0 > n, the number will be rounded to the left of the decimal point. If n = -1, round to the tens place, n = -2, round to the hundreds place, and n = -3, round to the thousands place...

- Result:

4. Some Functions Related to the ROUND Function

* ROUNDUP Function: Rounding Up Function

The ROUNDUP function has the following structure: =ROUNDUP(Number, Num_digits)

In which:

+ Number: The number you want to round down.
+ Num_digits: The number of digits you want to round down to.

* ROUNDDOWN Function: Rounding Down Function

The ROUNDDOWN function has the following structure: =ROUNDDOWN(Number, Num_digits)

In which:

+ Number: The number you want to round down.
+ Num_digits: The number of digits you want to round down to.

* MROUND Function: Returns a number rounded to the desired multiple

The MROUND function has the following structure: =MROUND(Number, Multiple)

In which:

+ Number: The number you want to round.
+ Multiple: The number you want to round to its multiple.

5. Compilation of Errors in the ROUND Function in EXCEL

If the argument [n] provided for the ROUND function is a negative number, you will receive an error message on the screen:

5.1. Run-time error '5': Invalid procedure call or argument

If one or all arguments provided for the ROUND function are not interpreted as numerical values, the function will return an error:

5.2. Run-time error '13': Type mismatch

Through the specific examples mentioned above, you can gain a better understanding of the concept of the ROUND function, its syntax, and how to use the Round function in Excel. Step by step, it enhances your Excel knowledge. This rounding function is widely applicable in practice, making learning Excel worthwhile and helping you compute more efficiently.

Apart from the ROUND function for rounding numbers, Excel provides various other functions like ROUNDUP(), ROUNDDOWN(), MROUND(), CEILING(), FLOOR(), EVEN(), ODD(), INT(), and TRUNC(). Among them, the integer rounding function is quite useful - the integer rounding function in Excel may sound simple, but executing it is not easy at all when dealing with numerous specific rows with different functions to help you round integers. Therefore, you need to carefully study how to use the integer rounding function in Excel as well as their functions to apply them logically.

Compared to the Round function, the Index function helps you return the value of a cell between a row and a column in Excel. Using the Index function, you will get the most accurate value.

If you are looking to learn about the OFFSET function, the article on the OFFSET function will help you understand this function easily, from syntax to illustrative examples.