ROUND

Modified on Wed, 1 May at 11:36 AM

Introduction

Rounds to the specified number of digits.


FORMULAROUND()
EXAMPLE FORMULA

ROUND(numeric_col, [digit/decimal places])

EXAMPLE INPUTROUND(2.149, 1)
EXAMPLE OUTPUT2.1


Sample Usage


Valid ExamplesInvalid 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

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article