ROUND function
Summary
Rounds a number to a specified number of digits
Syntax
ROUND(number, num_digits)
The ROUND function syntax has the following arguments:
• number Required. The number that you want to round.
• num_digits Required. The number of digits to which you want to round the number argument.
• number Required. The number that you want to round.
• num_digits Required. The number of digits to which you want to round the number argument.
Example
=ROUND(2.15, 1)
=ROUND(2.149, 1)
=ROUND(-1.475, 2)
=ROUND(21.5, -1)
=ROUND(626.3,-3)
=ROUND(1.98,-1)
=ROUND(-50.55,-2)
=ROUND(2.149, 1)
=ROUND(-1.475, 2)
=ROUND(21.5, -1)
=ROUND(626.3,-3)
=ROUND(1.98,-1)
=ROUND(-50.55,-2)