CEILING Function

CEILING function is used to round the numbers to the nearest multiple of the any number mentioned in the condition.

Formula:


=CEILING(Number, Significance)
Whereas "Number" is the value which has to be rounded and "Significance" is the multiple to which the number has to be rounded.

Video Tutorial:


Let us round the given numbers to the specified multiples, using the CEILING function, with the help of the below video

Learn MS Excel


Ask Questions

Ask Question