Introduction
Rounds to the specified number of digits.
| FORMULA | ROUND() |
| EXAMPLE FORMULA | ROUND(numeric_col, [digit/decimal places]) |
| EXAMPLE INPUT | ROUND(2.149, 1) |
| EXAMPLE OUTPUT | 2.1 |
Sample Usage
| Valid Examples | Invalid Examples |
| ROUND(Number Column, 2) | ROUND(Text Column, 2) |
| ROUND((Text Column, "2") |
Notes
- ROUND can only be used with a number data type column and then a numerical value to the decimal places. For example, 1 decimal places will be 2.1
See Also
Still having issues? Contact us at support@gigasheet.com
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article