Ceiling Function in Excel

The ceiling function is that function which is rounded up to a specified number that provide nearest multiple of given number.

सीलिंग फ़ंक्शन वह फ़ंक्शन है जिसे एक निर्दिष्ट संख्या तक पूर्णांकित किया जाता है जो दी गई संख्या का निकटतम गुणज प्रदान करता है

Example:

=ceiling(34,5) =35

=ceiling(34,2)=34

=ceiling(34,6)=36

=ceiling(34,7)=35

=ceiling(34,8)=40

=ceiling(34,9)=36

=ceiling(34,10)=40

=ceiling(34,3)=36

=ceiling(34,4)=36

We can take another number

=ceiling(33,2)=34

=ceiling(33,3)=33

=ceiling(33,4)=36

and same process.

Ceiling Function in Excel by Video: