Use the Quotient function in Excel?

%3CLINGO-SUB%20id%3D%22lingo-sub-3097039%22%20slang%3D%22en-US%22%3EUse%20the%20Quotient%20function%20in%20Excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3097039%22%20slang%3D%22en-US%22%3E%3CP%3EPlease%20how%20do%20I%20use%20the%20Quotient%20function%20in%20Microsoft%20Excel%3F%20It%20is%20a%20Math%20and%20Trigonometry%20function%20used%20to%20return%20the%20integer%20portion%20of%20a%20division.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3097039%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3097078%22%20slang%3D%22en-US%22%3ERe%3A%20Use%20the%20Quotient%20function%20in%20Excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3097078%22%20slang%3D%22en-US%22%3ETo%20use%20the%20Quotient%20function%20in%20Excel%2C%3CBR%20%2F%3E%3CBR%20%2F%3E1.%20Launch%20Microsoft%20Excel%3CBR%20%2F%3E2.%20Create%20a%20table%20or%20use%20an%20existing%20table%20from%20your%20files%3CBR%20%2F%3Eyou%20can%20learn%20that%20here%3A(%20%3CA%20href%3D%22https%3A%2F%2Fwww.thewindowsclub.com%2Fhow-to-use-the-quotient-function-in-excel%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.thewindowsclub.com%2Fhow-to-use-the-quotient-function-in-excel%3C%2FA%3E%20)%3CBR%20%2F%3E3.%20Place%20the%20formula%20into%20the%20cell%20you%20want%20to%20see%20the%20result%3CBR%20%2F%3E4.%20Press%20the%20enter%20Key%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3097796%22%20slang%3D%22en-US%22%3ERe%3A%20Use%20the%20Quotient%20function%20in%20Excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3097796%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1265426%22%20target%3D%22_blank%22%3E%40Ayuba123%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ELet's%20say%20you%20enter%20the%20number%2017%20in%20cell%20A1%20and%20the%20number%205%20in%20cell%20B1.%3C%2FP%3E%0A%3CP%3EIn%20cell%20C1%2C%20enter%20the%20formula%20%3DQUOTIENT(A1%2CB1)%3C%2FP%3E%0A%3CP%3EIf%20you%20use%20comma%20as%20decimal%20separator%2C%20enter%20%3DQUOTIENT(A1%3BB1)%20instead.%3C%2FP%3E%0A%3CP%3EThe%20formula%20will%20return%203%2C%20because%205%20goes%203%20times%20into%2017%2C%20with%20a%20remainder%20of%202%3A%2017%20%3D%203*5%2B2%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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
To 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

@Ayuba123 

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