ROUND(number, num_of_digits)
- Where 'number' is the number to round and
- 'num_of_digits' is the number of digits before or after decimal point.
ROUND() rounds the number to specified number of digits.
Description
ROUND(number, num_of_digits)
For Example,
ROUND(3.6712,2) returns 3.67
- When Nd is greater than zero,the number is rounded to the specified number of decimal places.
- When Nd is 0, the number is rounded to the nearest integer.
- When Nd is less than 0, the number is rounded to the left of the decimal point.
Examples
| Function | Output | |
| 3.6712 | 2 | |
| 3.67 | ||