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

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

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

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