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 |
|
Examples |
ROUNDTO (538.351,-1,.1) = 538.3000 |