Round

Syntax

Function:
  • ROUND(value, x)
Parameters:
  • value =  a numeric value
Outputs:
  • an integer or decimal number
Description:
  • The Round() function will round a ‘value’ down or up to ‘x’ number of decimal places.
Used:
in a Formula BuilderFormula Builder

 

Example
Result
Note
ROUND( 24.6744 , 2) 24.67
ROUND( {{UnitPrice}} , 3) 986.365   {{UnitPrice}} = 986.36587
ROUND( {{UnitPrice}} / 3 , 4) 328.7886
tanh(). Functions Table. Repeats. cosh(). userfirstname(). useremail(). logarithm(). acos(). userlastname(). string(). cos(). param1(). globalval(). tan(). Text based Functions. Choices Functions. Excel Financial Functions. Functions. degrees(). today().