Excel ROUND function


The Excel ROUND function rounds a number to a specified number of digits. It’s commonly used in financial calculations to round currency values, or in any situation where precise rounding to a specific number of decimal places is required.
					=ROUND(number, num_digits)
  • number: The number you want to round.
  • num_digits: The number of digits to which you want to round the number.
Return value
The rounded number to the specified number of digits.

How to use

Use ROUND by entering the number to be rounded and specifying the number of digits for the rounding. If num_digits is greater than 0, the number is rounded to the specified number of decimal places. If num_digits is 0, the number is rounded to the nearest integer. If num_digits is less than 0, the number is rounded to the left of the decimal point.


Simple ROUND
Rounding to a Specific Decimal Place: To round a number to two decimal places:
					=ROUND(3.14159, 2)
This formula rounds 3.14159 to 3.14.
ROUND to Tens and Hundreds
Rounding with negative num_digits: Rounding a number to the nearest ten or hundred:
					=ROUND(157, -1)
Rounds 157 to 160 (nearest ten).
ROUND for Data Presentation
Rounding for Display Purposes: Rounding numbers for clearer data presentation:
					=ROUND(A2, 0)
If A2 contains 15.7, this formula rounds it to 16.

Additional Notes

  • ROUND is different from truncation, as it rounds a number up or down based on the rounding rules.
  • It’s useful for ensuring consistency and accuracy in calculations, especially in financial and scientific contexts.

Related Functions

Excel CEILING function

The Excel CEILING function rounds numbers up to the nearest multiple of significance, ideal for pricing and budgeting calculations.

Excel FLOOR function

The Excel FLOOR function rounds numbers down to the nearest multiple of significance, useful for inventory and budget control.

Excel ROUNDDOWN function

The Excel ROUNDDOWN function rounds a number down, away from zero, to a specified number of digits, useful for conservative estimations.

Excel ROUNDUP function

The Excel ROUNDUP function rounds a number up, away from zero, to a specified number of digits, ideal for precautionary measures in calculations.

Excel TRUNC function

The Excel TRUNC function truncates a number to an integer by removing the fractional part, useful for precise mathematical operations.

Content Navigation