Dividing in excel easy questions

[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

 

[Guest]

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!

 

[Guest]

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

 

[Guest]

You are my favorite person in the world

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!