Summary
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.
Syntax
=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.
Examples
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.