All functions / Math

CEILING

Rounds a number up to the nearest multiple (away from zero when both are negative).

Syntax

=CEILING(number, [significance])

Arguments

• number: The number to use.
• significance (optional): The multiple to round to (default 1).

Example

=CEILING(23, 5) → 25

Practise it

• Rounding values (not just how they look)