Forum Discussion
Ayuba123
Feb 01, 2022Brass Contributor
Use the Quotient function in Excel?
Please how do I use the Quotient function in Microsoft Excel? It is a Math and Trigonometry function used to return the integer portion of a division.
2 Replies
Sort By
Let's say you enter the number 17 in cell A1 and the number 5 in cell B1.
In cell C1, enter the formula =QUOTIENT(A1,B1)
If you use comma as decimal separator, enter =QUOTIENT(A1;B1) instead.
The formula will return 3, because 5 goes 3 times into 17, with a remainder of 2: 17 = 3*5+2
- yubzyCopper ContributorTo use the Quotient function in Excel,
1. Launch Microsoft Excel
2. Create a table or use an existing table from your files
you can learn that here:( https://www.thewindowsclub.com/how-to-use-the-quotient-function-in-excel )
3. Place the formula into the cell you want to see the result
4. Press the enter Key