| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dividing in excel easy questions
OK I am working with excel 2007 I have 2 Problems.
1.) When I am dividing I am using =QUOTIENT(B3,B4). The result I am getting is rounding down Example: 8/5 it is giving me a result of 1 I want the true answer of 1.6 2.) When I am dividing I am using =QUOTIENT(B3,B4). It will not give me the result with higher denomnators. Example: 8/25 excel is giving me the result 0 I want the answer 0.32 2 problems 1 headache |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dividing in excel easy questions
The quotient function returns only the interger portion of the result.
Trying entering the formula as: =B3/B4 / is the symbol used for division. This should fix both of your problems. Good luck! "HELP PLEASE HELP" wrote: OK I am working with excel 2007 I have 2 Problems. 1.) When I am dividing I am using =QUOTIENT(B3,B4). The result I am getting is rounding down Example: 8/5 it is giving me a result of 1 I want the true answer of 1.6 2.) When I am dividing I am using =QUOTIENT(B3,B4). It will not give me the result with higher denomnators. Example: 8/25 excel is giving me the result 0 I want the answer 0.32 2 problems 1 headache |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dividing in excel easy questions
sounds like a format problem, make sure that you have it set to accept
decimals and not to round off -- If this reply was helpful, please indicate that your question has been answered to help others find anwsers to similar questions. www.silverbirddesigns.com Fighting Texas Aggie Class of 2009 "HELP PLEASE HELP" wrote: OK I am working with excel 2007 I have 2 Problems. 1.) When I am dividing I am using =QUOTIENT(B3,B4). The result I am getting is rounding down Example: 8/5 it is giving me a result of 1 I want the true answer of 1.6 2.) When I am dividing I am using =QUOTIENT(B3,B4). It will not give me the result with higher denomnators. Example: 8/25 excel is giving me the result 0 I want the answer 0.32 2 problems 1 headache |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dividing in excel easy questions
You are my favorite person in the world
"BoniM" wrote: The quotient function returns only the interger portion of the result. Trying entering the formula as: =B3/B4 / is the symbol used for division. This should fix both of your problems. Good luck! "HELP PLEASE HELP" wrote: OK I am working with excel 2007 I have 2 Problems. 1.) When I am dividing I am using =QUOTIENT(B3,B4). The result I am getting is rounding down Example: 8/5 it is giving me a result of 1 I want the true answer of 1.6 2.) When I am dividing I am using =QUOTIENT(B3,B4). It will not give me the result with higher denomnators. Example: 8/25 excel is giving me the result 0 I want the answer 0.32 2 problems 1 headache |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel is dividing my entries...why?? | Excel Discussion (Misc queries) | |||
| My excel spread sheets are dividing all numbers input by 100. | Excel Worksheet Functions | |||
| Easy (?) questions for setting up a database | Excel Discussion (Misc queries) | |||
| Couple of hopefully easy questions | Excel Worksheet Functions | |||
| What is the formula for dividing a number by 4 in excel | Excel Worksheet Functions | |||
Linear Mode
