How To Use ROUND function in Excel With Examples and Guides

The ROUND function in Excel is a mathematical function used to round a number to a specified number of digits. It rounds a number up or down to the nearest integer, or to the nearest multiple of a specified factor. 

The ROUND function in Excel is used to round a number to a specified number of digits. It takes two arguments: the number to round and the number of digits to round to. The function will return a number rounded to the nearest specified digit for you.

For example, if you have the number 3.14159 and want to round it to two decimal places, the ROUND formula would return 3.14. The function works on positive and negative numbers and you can use it to round fractions, integers, and decimals.

=ROUND(number, num_digits)

Where:

number: The number to be rounded.

num_digits: The number of digits to which you want to round the number.

Choose the cell you want to round and add the number of digits after the comma you want to see. In our example, we will round numbers to 1 digit.

1. Open your Excel worksheet and select the cell or range of cells that you want to round.
2. Enter the “=ROUND” function in the formula bar.
3. Select the cell or range of cells that contains the number you want to round.
4. Add a comma after the cell reference, and enter the number of decimal places you want to round to.
5. For example, to round to the nearest whole number, enter “0”. To round to two decimal places, enter “2”.
6. Press enter to calculate the result. The cell or range of cells should now be rounded to the specified number of decimal places.