ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Help Please (https://www.excelbanter.com/excel-discussion-misc-queries/165449-help-please.html)

HELP PLEASE HELP

Help Please
 
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

pinmaster

Help Please
 
Hi,

if your simply dividing then why not just:

=B3/B4

Regards!
Jean-Guy

"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


JMB

Help Please
 
just use:
=B3/B4


"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



All times are GMT +1. The time now is 10:49 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com