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.
HansVogelaar
Feb 01, 2022MVP
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