# How to Use Excel ROUND Function?

Excel ROUND Function: Sometimes, we want to round the numbers when they have huge digits in them. Doing this manually will take time to finish the work. For that, we suggest you use the ROUND function in the worksheet. This function returns a number rounded to a given number of digits.

In this article, we will see how to use the Excel ROUND Function with its syntax, explanation, and examples. Get an official version of MS Excel from the following link:

https://www.microsoft.com/en-in/microsoft-365/excel

## Explanation of ROUND Function

• It is one of the built-in functions in Microsoft Excel.
• This function rounds a number to the specified number of digits.
• For example, ROUND(3.18302, 2) returns the output value of 3.18

## Syntax

• Here, you will see the syntax of the ROUND function.
• To apply this function on your spreadsheet, you have to select a cell and enter the formula in the following format.
• Once you enter the formula, just click on the button to get the result.

=ROUND(number, num_digits)

Argument Explanation:

• Number – The input number that needs to be rounded.
• Num_digits – The number of digits by which you want to round the given number.

Note:
1) If num_digits is greater than 0, It will round the number to the specified number of decimal places.
2) It will round the number to the nearest integer if num_digits is 0.
3) If num_digits is less than 0 and then it will round the number to the left of the decimal point.
4) If any argument is a non-numeric value such as letters, special characters and then it will return #VALUE! Error.
5) If the floating-point value is greater than or equal to 5 and then this ROUND function will add number 1 to the decimal value and print the rounded output. For example, ROUND(14567.89, -3) will return the value of 15000.

## Examples

Let’s see some examples to understand this function easily.

• Here, you can see the input numbers in Column A, and their specified digits in Column B.
• Apply the above-mentioned formula. The rounded output values are listed in Column C.
• Finally, we need to click on the button to get the result. Drag-down the first cell to fill the remaining cells.
• If any argument is a non-numeric value such as letters, or special characters and then it will return #VALUE! Error.

## Closure

In the above article, you can clearly understand the usage of the Excel ROUND Function with its syntax, explanation, and examples. Drop your queries/suggestions in the below comment section. To learn more about Excel functions, then visit our webpage Aawexcel.com.

## Video Tutorial

The following video will show you how to use the Excel ROUND function in the spreadsheet.