Round function
This function rounds the value being calculated at takeoff to a specified number of digits (from -3 to 3). Enter a separator (shown as a comma below) after the value.
- If digit is positive, the value at that position is rounded to the nearest number.
- If digit is negative, rounding occurs to the left of the decimal point.
Syntax
ROUND (value, digit)
Examples
ROUND (1538.3518, 3) = 1538.3520
ROUND (1538.3518, 2) = 1538.3500
ROUND (1538.3518, 1) = 1538.4000
ROUND (1538.3518, 0) = 1538.0000
ROUND (1538.3518, -1) = 1540.0000
ROUND (1538.3518, -2) = 1500.0000
ROUND (1538.3518, -3) = 2000.0000
Tip: Unlike rounding the order quantity of items on reports (Round field in the Edit Items window), a formula with a ROUND function affects the actual number calculated during takeoff.