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?
|