ROUND
Rounds a number to a specified number of fractional digits, and rounds midpoint values to the nearest even number.
Usage
ROUND(number1, number2)
Parameters
number1 |
Number |
Number to be rounded. |
number2 |
Number |
Number of fractional digits in the return value. |
Returns
Number
Examples
ROUND(1.6278, 2) |
1.63 |
ROUND(1.6278, 0) |
2 |
Remarks
The value of the digits argument can range from 0 to 15. The function will fail if a number outside of that range is provided.