CEILING

Definition: CEILING is a function that rounds a number up to the nearest multiple of a specified value.

Syntax: =CEILING(number, [significance])

Situation: This formula is suitable when you need to round up a number to the nearest specified multiple, such as rounding up a price to the nearest dollar.

Example: If you have a number 23.45 and want to round it up to the nearest 5, you can use the formula =CEILING(23.45, 5), which returns 25.