ROUNDUP

Rounds a number up (away from zero) to the nearest integer or to a specified number of decimal places. Use ROUNDUP when you need to ensure values never fall below a threshold, such as billing calculations or inventory requirements.

Syntax

ROUNDUP(number, [decimals])

• number (Number): The value to round up.

• decimals (Number, optional): The number of decimal places to keep (default = 0).

Returns: Number – The rounded-up result with the specified precision.

Simple Examples

ROUNDUP(3.14159, 2)  // 3.15
ROUNDUP(4.1)         // 5
ROUNDUP(7.01)        // 8
ROUNDUP(-2.6)        // -3

Business Examples

Calculate minimum billable hours

ROUNDUP(ACTUAL_HOURS, 0)

Ensures partial hours are billed as full hours (e.g., 2.1 hours → 3 hours).

Determine packaging requirements

ROUNDUP(TOTAL_ITEMS / BOX_CAPACITY, 0)

Calculates the number of boxes needed when partial boxes still require a full container.

Set safety stock levels

ROUNDUP(AVERAGE_DAILY_USAGE * LEAD_TIME, 0)

Ensures inventory never falls below minimum requirements.

Common Mistakes & Tips

• Negative decimal values round to tens, hundreds, etc. (ROUNDUP(1234, -2) → 1300).

• For negative numbers, ROUNDUP moves away from zero (more negative).

• Use CEIL for always rounding toward positive infinity instead.

• Combine with conditional logic to apply different rounding rules based on context.

Tests

ROUNDUP(3.14159, 2) == 3.15   // true
ROUNDUP(4.1) == 5             // true
ROUNDUP(7.01) == 8            // true
ROUNDUP(-2.6) == -3           // true
ROUNDUP(1234, -2) == 1300     // true

See also

ROUND · ROUNDDOWN · FLOOR · CEIL