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

[tkt_tang@hotmail.com]

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.

[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


"tkt_tang@hotmail.com" wrote:

> 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.
>
>

[tkt_tang@hotmail.com]

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.

[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

<tkt_tang@hotmail.com> wrote in message
news:1135745537.150470.162250@g49g2000cwa.googlegroups.com...
| 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.
|

[tkt_tang@hotmail.com]

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.

[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

<tkt_tang@hotmail.com> wrote in message
news:1135752976.273934.4020@f14g2000cwb.googlegroups.com...
> 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.
>

[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.

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

<tkt_tang@hotmail.com> wrote in message
news:1135743802.993172.18990@g43g2000cwa.googlegroups.com...
> 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.
>

[tkt_tang@hotmail.com]

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.

[Biff]

See this:

http://tinyurl.com/bzbm5

Biff

<tkt_tang@hotmail.com> wrote in message
news:1135756434.098681.203300@f14g2000cwb.googlegroups.com...
> 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.
>

[Harlan Grove]

tkt_tang@hotmail.com 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 ?

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.

[tkt_tang@hotmail.com]

Mr. Harlan Grove,

Thank you for your practical suggestion.

Regards.