ROUNDUP
The ROUNDUP function always rounds a number up, away from zero. Use ROUNDUP when you always need a higher estimate, such as in budgeting or safety margins.
Syntax
roundup(value, significance)Arguments
value - Required. The number to be rounded.
significance - Optional. The number of decimal places to round off.
Example
ROUNDUP(Actuals,2) //Rounds the Actuals to 2 decimal places
Last updated
Was this helpful?