QUOTIENT
What Does It Do ?
It ignores any remainder, only showing the whole number.
Syntax
=QUOTIENT(NumberToBeDivided,Divisor)
=QUOTIENT(NumberToBeDivided,Divisor)
Formatting
No special formatting is needed.
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.
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.
decimal fractions which are not needed.
Table 2 uses the =QUOTIENT() function to remove the decimal fraction to
give the correct result.
give the correct result.