To round a number to the nearest whole number in Excel, you use the ROUND function with the number of decimal places set to zero.
How to Use the ROUND Function for Nearest Whole Number
Syntax:
excel
=ROUND(number, 0)
number: The value or cell reference you want to round.0: Specifies rounding to zero decimal places, i.e., the nearest whole number.
Example: If cell A2 contains 5.47, the formula:
excel
=ROUND(A2, 0)
will return 5 , rounding 5.47 to the nearest whole number
Other Related Rounding Functions
-
ROUNDUP : Always rounds a number up to the nearest whole number.
excel =ROUNDUP(number, 0)
For example, 6.23 becomes 7
-
ROUNDDOWN : Always rounds a number down to the nearest whole number.
excel =ROUNDDOWN(number, 0)
For example, 8.99 becomes 8
Display Rounding Without Changing the Actual Value
You can also format a cell to display numbers rounded to the nearest whole number without changing the actual value by setting the number format to zero decimal places. This changes only the display, not the underlying value
. In summary, to round to the nearest whole number in Excel, use:
excel
=ROUND(A2, 0)
This rounds the number in cell A2 to the nearest integer accurately.
