ROUND Function Formula

ROUNDROUNDDOWN, and ROUNDUP functions are now available as a formula for Calculated and Text fields.
 
ROUND Function
The ROUND function allows you to round a value to a specified number of digits. Remember that 1, 2, 3, 4 shall be rounded down whereas 5, 6, 7, 8, 9 shall be rounded up.
Formula: ROUND(number, [digits])
  • number (required) : Number to be rounded.
  • digits (optional) : Number of decimal places to which to round.
 
ROUNDDOWN Function
The ROUNDDOWN function always returns a value rounded down to a specified number of digits.
Formula: ROUNDDOWN(number, [digits])
  • number (required) : Number to be rounded.
  • digits (optional) : Number of decimal places to which to round.
     
ROUNDUP Function
The ROUNDUP function always rounds up to a specified digit.
Formula: ROUNDUP(number, [digits])
  • number (required) : Number to be rounded.
  • digits (optional) : Number of decimal places to which to round.

Example of Rounding a discount value to integer
Formula: ROUND(subtotal*discountpercentage/100)
round.png
Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.