An Overview of ROUND Function | Microsoft Excel
The ROUND function is one of the math and trigonometry functions in Microsoft Excel. It can be used as a standalone function as well as in collaboration with the other functions. This article will give you an overview of the ROUND function in Excel.
Objectives
The ROUND function is used to round off the numerical values. It can round off numbers to specific values. It can also round off the decimal fraction numbers to a specific number of places after the decimal point.
Syntax
=ROUND(number, num_digits)
Arguments
- number: It refers to the number to round off.
- num_digits: The total number of digits that you want after the decimal point.
The behavior of “num_digits”
Output
A rounded-off version of the input number.
An Example of ROUND Function
Suppose, you have the number 27.98763 in cell A2. You can round off the number to two decimal places using the ROUND function. For that, use the formula:
=ROUND(A2,2)
The output will be 27.99.
Usage Guide of ROUND Function
Step_1: Start with inserting an equal sign (=) in a blank cell.
Step_2: Then type ROUND.
Step_3: Type open parenthesis “(“.
As you type the open parenthesis, Excel shows the syntax of the ROUND function.
Step_4: Insert a number to round off.
You can directly insert a number or a cell address that contains a number.
Step_5: Then insert a comma (,).
After inserting the comma, Excel will ask you for the second argument which is the number of digits.
Step_6: Now specify the number of digits that you want after the decimal point.
Final Result
The ROUND function converts 27.98763 into 27.99. Because here, num_digits is 2 which allows only 2 decimal places after the decimal point.
Availability
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Remarks
- The ROUND function shows #VALUE! error in the case of non-numeric values.
- When a number is already rounded up, the ROUND function doesn’t work.
Related Rounding Functions
- MROUND Function ⋙ rounds to the nearest specified multiple.
- ROUNDUP Function ⋙ rounds up a numerical value to a specific decimal place.
- ROUNDDOWN Function ⋙ rounds down a numerical value to a specific decimal place.
- CEILING Function ⋙ rounds up a numerical value to the nearest integer or the nearest multiple of significance.
- FLOOR Function ⋙ rounds down a numerical value to the nearest multiple of significance.
- INT Function ⋙ rounds down a numerical value to the nearest integer number.
- TRUNC Function ⋙ removes specific digits from the fraction part of a number.
Conclusion
The ROUND function is one of the math and trigonometry functions in Excel. If you have any questions regarding the ROUND function, please comment below. Thanks!
