Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MS Exel 2007 | Excel Discussion (Misc queries) | |||
Exel 2007 penny off | Excel Discussion (Misc queries) | |||
exel 2007 process | Excel Worksheet Functions | |||
Exel 2002/2007-Always get 31 Oct 06 | Excel Discussion (Misc queries) | |||
Exel Problems! | Excel Discussion (Misc queries) |