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