top of page

Floor Formula in MS EXCEL

FLOOR function is built in function in MS Excel. It is a predefined formula that rounds a specific number down to the nearest specified multiple.



FLOOR फ़ंक्शन MS Excel में अंतर्निहित फ़ंक्शन है। यह एक पूर्वनिर्धारित सूत्र है जो एक विशिष्ट संख्या को निकटतम निर्दिष्ट गुणज तक पूर्णांकित करता है।

Examples:

=floor(34,5) =30

=floor(34,2)=34

=floor(34,6)=30

=floor(34,7)=28

=floor(34,8)=32

=floor(34,9)=27

=floor(34,10)=30

=floor(34,3)=33

=floor(34,4)=32

We can take another number

=floor(33,2)=32

=floor(33,3)=33

=floor(33,4)=32

and same process.


Floor Formula Video By Rajesh Sir:




11 views0 comments

Recent Posts

See All
bottom of page