View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Texas Aggie Texas Aggie is offline
external usenet poster
 
Posts: 74
Default 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