From data to report in one minute or less. Ajelix BI is launched! 🚀 Get started for free.

How To Use ROUND function in Excel With Examples and Guides

What is ROUND function in Excel?

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)


number: The number to be rounded.

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

ROUND Function Example in Excel

ROUND Function MS Excel - Excel formulas and functions - ajelix

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.

ROUND Function Example Result in Excel

Round function MS Excel example - ajelix

The example above shows that the function rounded numbers to 1 digit after a comma.

How to use ROUND function in your workbook:

  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.

Frequently Asked Questions

Can the ROUND formula return an error? If so, what does it mean?

Yes, the ROUND formula can return an error if the argument supplied is not a valid number or if the value being rounded exceeds the maximum size allowed in Excel. This can result in the #VALUE! or #NUM! error values.

Can the ROUND formula be used with negative numbers?

You can use the ROUND formula with negative numbers. The function will round negative numbers just like it would round positive numbers. The sign of the number being rounded does not affect how the function works.

What is the largest number that the ROUND formula can handle?
The largest number that the ROUND function in Excel can handle depends on the version of Excel being used. In general, the maximum number that Excel can handle is approximately 1.79769313486231E+308. If a number being rounded is larger than this maximum, the function will return the #NUM! error value.

Struggling with your Excel formulas?

Try out for free AI Excel Assistant who can generate Excel and Google Sheets formulas from your text. Explain your formulas and give descriptions to the most complicated formulas. Translate your Excel files in 28 lanugages. Write and explain your VBA and Google Apps Scripts. Register for free!

Start Generating Formulas

Struggling with your Excel formulas?

Check out our blog for the latest tips and tricks to help you become an expert. We have the insider scoop on the best strategies and resources to help you stay ahead of the curve. Click here to read our blog and start your journey towards Excel and Google Sheets mastery today!

Explore our blog