Round to function

ROUNDTO, which is more flexible than the ROUND function, allows you to use a specific method and multiplier to get the desired number of decimal places. Enter a separator (shown as a comma below) after the value and method. This function rounds the value being calculated at takeoff.

Syntax

ROUNDTO (value, method, multiplier) Where the method is:

-1 round down
0 round to closest
1 round up

Examples

ROUNDTO (538.351,-1,.1) = 538.3000
ROUNDTO (538.351,1,.01) = 538.3600
ROUNDTO (538.351,0,1) = 538.0000
ROUNDTO (538.351,0,10) = 540.0000