How to Get Quotient in Excel by Formula.

QUOTIENT

What Does It Do ?

This function calculates the number of times a number can be divided by another number.

It ignores any remainder, only showing the whole number.

Syntax
=QUOTIENT(NumberToBeDivided,Divisor)

Formatting
No special formatting is needed.

Example
The following example was used by a drinks merchant to calculate the number of
crates which could be packed using bottles in stock.
The merchant can only sell full crates.

Table 1 calculates the crates by simple division. This however shows
decimal fractions which are not needed.

Table 2 uses the =QUOTIENT() function to remove the decimal fraction to
give the correct result.