Forum Discussion

Ayuba123's avatar
Ayuba123
Brass Contributor
Feb 01, 2022

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

  • 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

  • yubzy's avatar
    yubzy
    Copper Contributor
    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

Resources