Excel CEILING function

Function              CEILING

Description        Excel CEILING function returns a provided number rounded up to a specified multiple.

Syntax  CEILING(number, multiple)

number  The number to be rounded up.

multiple  The multiple to use when rounding up.

Example:

=CEILING(236,5) = 240

=CEILING(237,5) = 240

=CEILING(238,5) = 240

=CEILING(239,5) = 240

=CEILING(241,5) = 245