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
now(). Text based Functions. sinh(). globalval(). imgurl(). number(). logarithm(). Process Steps. asin(). Repeats. int(). Excel Financial Functions. cosh(). today(). Choices Functions. format-num(). counter(). utctoday(). string(). pi().