Home Computer How to Get Quotient in Excel by Formula.

How to Get Quotient in Excel by Formula.

1 min read
0
0
76
2

QUOTIENT

Learn Quotient Excel Formula

 

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.

Quotient Excel formula Example -1
Table 2 uses the =QUOTIENT() function to remove the decimal fraction to
give the correct result.
Quotient Excel formula example -2
Load More Related Articles
Load More By amitgupta
Load More In Computer

Leave a Reply

Check Also

What is Account Master & How to Create Modify and Delete

What is Account Master & How to Create Modify and Delete Administration > Masters &…