ROUND
Description
Rounds the number up or down to the accuracy that you specify, based on the sign and
the value of the num_digits argument.
Syntax
ROUND(
number
,
num_digits
)
- number: The number to round.
- num_digits: The number of decimal places to rount to and the direction to round. Specify 0 to round to the closest integer. A positive num_digits specifies the number of digits to the right of the decimal point. A negative num_digits specifies the number of digits to the left of the decimal point.
Example
Formula | Result |
|---|---|
=ROUND(12.34,0) | 12 |
=ROUND(-12.34,0) | -12 |
=ROUND(12.34,-1) | 10 |
=ROUND(-12.34,-1) | -10 |