division problems in exel 2007
 

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?

division problems in exel 2007
 

From Excel help QUOTIENT:

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

Try it like this: =8.42/2

Or, using cells to hold the values:

A1 = 8.42
B1 = 2

=A1/B1

--
Biff
Microsoft Excel MVP


"sid" wrote in message
...
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?