Basic Help

    I'm not sure if this is the correct forum but I need some basic help on dividing in excel. In the top bar I press and type =QUOTIENT(5, 2) and it comes out to 2.00000 rather than 2.500000. What is wrong? Thus, the .5 is cutoff. To complete my task I need up to 6 or 7 accurrate decimal places. Thanks.
    Chris

    click on your cell and choose Format. See how many decimal places your number is formatted to.


    Format>Cell>Number and adjust the number of decimal places (default is 2)


    HTH


    Roy

    Thanks for the response Roy. Unfortunately, when I increase the decimal places it does not make it more precise. For instance I have it on two decimal places and I type in =QUOTIENT(5,2) and get 2.00. When I increase the decimal places I get 2.00000. I need it to be precise. For example if I were to type in =QUOTIENT(5,3) excel would give me 1.0000. I need this answer to read 1.6666667 rather than just 1. If someone could help that would be great I'm trying to complete grades for a class and there due tomorrow. Thanks.
    Chris

    Apologies if i'm missing something really obvious here.....


    but why not just


    =5/2 or
    =5/3


    then use roy's cell formatting to get the desired number of decimal places...


    hth :thumbup:

    "=QUOTIENT(5, 2) and it comes out to 2.00000 rather than 2.500000. "


    The function is performing as expected, given that quotient() is defined as:


    "Returns the integer portion of a division. Use this function when you want to discard the remainder of a division."


    Given that you do want the remainder, you are using the wrong function. A simple division would prbably suffice, as has been suggested.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login