division problems in exel 2007

S

sid

whenever i divide two numbers using =quotient e.g-8.42 divided by 2 it
gives me the answer
4.00 instead of 4.21
why is that??
how do i change this?
 
T

T. Valko

From Excel help QUOTIENT:

Try it like this: =8.42/2

Or, using cells to hold the values:

A1 = 8.42
B1 = 2

=A1/B1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

plz help 1
bugs in microsoft exel 2007 6
Rounding Issues 2
Dividing in excel easy questions 3
Help Please 2
Divide by zero error 3
Excel is rounding up my formula result 4
Time Division Question 4

Top