Ceiling And Floor Formula in MS Excel

Ceiling And Floor Formula in MS Excel

In Microsoft Excel, the CEILING and FLOOR functions are used to round numbers up or down to the nearest multiple of a specified value.

The syntax for the CEILING function is:

=CEILING(number, significance)

where:

number = the number you want to round 

significance = the multiple to which you want to round up

The syntax for the FLOOR function is:

=FLOOR(number, significance)

where:

number = the number you want to round 

significance = the multiple to which you want to round down

Here's an example of using the CEILING function:

=CEILING(3.14, 0.1)

This will return 3.2, which is the nearest multiple of 0.1 above 3.14.

Here's an example of using the FLOOR function:

=FLOOR(3.14, 0.1)

This will return 3.1, which is the nearest multiple of 0.1 below 3.14.