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