 # 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

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