Description
The ROUND function rounds a numeric value to a given number of decimal places or to a position.
Usage
ROUND(number, num_digits)
| Arguments | Required | Expected Type | Description |
|---|---|---|---|
| number | Yes | Number | The value to round |
| num_digits | Yes | Number | The number of digits to which number is rounded |
Result
Returns the value of number rounded to the specified number of digits:
- When num_digits is greater than 0, the result is rounded to that many decimal places.
- When num_digits is 0, the result is rounded to the nearest whole number.
- When num_digits is less than 0, the result is rounded to a position left of the decimal point.
Example
When collecting financial data and need to round values for reporting purposes:
- Revenue = 1,247,890.456
Formula:
ROUND(Revenue, 2)
Result:
1,247,890.46
- Expenses = 1,193,420.7
Formula:
ROUND(Expenses, 0)
Result:
1,193,421
- Total cost = 1,201,550
ROUND(TotalCost, -3)
Result:
1,212,000