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
 
Top