What is CEILING in Excel?

       The CEILING function rounds numbers up, away from zero, to the nearest multiple of significance. The syntax for the CEILING function is as follows:

CEILING(number, significance)

number: This is the value you want to round.

significance: This is the multiple to which you want to round the number.

Here's an example:

=CEILING(12.3, 5)

This formula will round 12.3 up to the nearest multiple of 5, which is 15.