View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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?