Saturday, December 14, 2019

Quotient (Returns the integer portion of a division)













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.

No comments:

Post a Comment