ROUNDUP

The ROUNDUP function rounds a number up, away from zero, to a specified number of decimal places. It always increases the value regardless of the following digits and is useful in scenarios where higher estimates, pricing adjustments, or safety margins are required.

Syntax

ROUNDUP(value, significance)

Arguments

• value: The number to round.

• significance (Optional): The number of decimal places to round to.

Return value

Returns the number rounded up, away from zero, to the specified number of decimal places.

Example

ROUNDUP(Actuals, 2)

In this example, the Rounded Sales measure is created using the ROUNDUP function, which rounds the values in Total Sales up, away from zero, to two decimal places.

Excel equivalent

ROUNDUP