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
Basic Help


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/3then use roy's cell formatting to get the desired number of decimal places...
hth

"=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!