Excel QUOTIENT ; That's the matter with the formula ......

T

tkt_tang

1. Enter the following formula into a worksheet cell :-

2. = QUOTIENT (36,16) + RQP

3. Where RQP (=26) is a Named Formula (well defined).

4. The given formula appears to calculate well until the partial
evaluation in the Formula Bar gives #NAME? (that's apparently an error
condition).

5. That means that when the function QUOTIENT is applied in a larger
formula, it would stall thereof.

6. There are inevitably dithering moments at the expense of
troublshooting.

7. Please share your experience. Regards.
 
R

Ron Coderre

What's the definition of RQP?

When I put 26 in a cell and name that cell RQP...
=QUOTIENT(36,16)+RQP returns 28.

***********
Regards,
Ron

XL2002, WinXP-Pro
 
T

tkt_tang

1. Precisely, RQP = 26 (well defined).

2. The given formula appears to calculate well until the partial
evaluation in the Formula Bar gives #NAME? (that's apparently an error
condition).

3. Thank you.
 
S

ScottO

The Quotient function requires that the Analysis ToolPak add-in is
installed.
Go to Tools/Add-ins and click on Analysis ToolPak, then hit OK.
Your formula should now evaluate properly.
Rgds,
ScottO

| 1. Precisely, RQP = 26 (well defined).
|
| 2. The given formula appears to calculate well until the partial
| evaluation in the Formula Bar gives #NAME? (that's apparently an
error
| condition).
|
| 3. Thank you.
|
 
B

Biff

Try this:

Requires that the analysis ToolPak add-in be installed.

A1 = 1/1/2005
A2 = 1/10/2005

Formula:

=NETWORKDAYS(A1,A2)+NETWORKDAYS(A1,A2)

Now, highlight the entire formula in the formula bar then press F9.

Now, highlight the individual functions one at a time and press F9.

If you use Excel XP (2002) or later, select the formula cell and goto
Tools>Formula Auditing>Evaluate Formula. Click the Evaluate button.
6. There are inevitably dithering moments at the expense of
troublshooting.
Click to expand...

In the above sceniaro, that's what you might run into. This "feature" was
discussed a while back and the most reasonable conclusion was that a formula
that contains more than 1 function call to the ATP will behave like that.
The formula will work and return a result (not withstanding the typical
errors) but if you ever have to troubleshoot it, it can be a real challenge
depending on the complexity!

In the next version of Excel the ATP functions will be incorporated into the
Excel program itself thus eliminating the add-in.

Biff
 
T

tkt_tang

1. I've dunnit : Go to Tools/Add-ins and click on Analysis ToolPak,
then hit OK.

2. The given formula appears to calculate well ; however, the partial
evaluation in the Formula Bar gives #NAME? (that's apparently an error
condition).

3. Thank you.
 
B

Biff

See my other reply.

It appears that the use of the defined name, RQP, also causes what I've
described in my other post.

Biff
 
T

tkt_tang

Mr. Biff,

1. Thank you for your clarification.

2. A longer formula incorporating Quotient(A,B) stalls (until it's
replaced by INT(A/B)).

3. So kind of you if you could point with a link to : 'This "feature"
was discussed a while back and the most reasonable conclusion was that
a formula that contains more than 1 function call to the ATP will
behave like that.'

4. What's the interim workaround while the world awaits Excel 12 ?

5. Regards.
 
H

Harlan Grove

[email protected] wrote...
....
2. A longer formula incorporating Quotient(A,B) stalls (until it's
replaced by INT(A/B)). ....
4. What's the interim workaround while the world awaits Excel 12 ?
Click to expand...

Don't screw around using a pointless function like QUOTIENT(x,y). Use
TRUNC(x/y) rather than INT(x/y) if you want the same results as
QUOTIENT when x and y have different signs.
 
Top