top of page
Writer's pictureRajesh Singh

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:




20 views0 comments

Recent Posts

See All

留言


bottom of page