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.