Dividing in excel easy questions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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!
 
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
 
You are my favorite person in the world

BoniM said:
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!
Click to expand...
 
Back
Top