QUOTIENT Function (Functions in Excel)

Number	Divisor	Result
12	5	2	=QUOTIENT(C4,D4)
20	3	6	=QUOTIENT(C5,D5)
46	15	3	=QUOTIENT(C6,D6)

               

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 1
Item	Bottles To Pack	Bottles Per Crate	Crates Needed
Wine	126	12	10.5	=D28/E28
Champagne	200	8	25
Rum	15	4	3.75
Beer	250	20	12.5

Table 2 uses the =QUOTIENT() function to remove the decimal fraction to

give the correct result.

Table 2
Item	Bottles To Pack	Bottles Per Crate	Crates Needed
Wine	126	12	10	=QUOTIENT(D39,E39)
Champagne	200	8	25
Rum	15	6	2
Beer	250	20	12

Related Posts by Categories