Hi Harlan,

Thanks for catching that bug! It's the first one reported.

I've fixed the bug, and I'll get the fixed version up on the website ASAP,
after I've done more testing.


"Harlan Grove" wrote in message
ups.com...
I downloaded and installed the free version. A few quirks (read: NASTY
bugs). The formula

=xlpROOT(2,1/3)

hangs Excel, requiring Task Manager to kill the Excel process.
Exception handling doesn't appear to be a strength of this product.

It was an infinite loop.


Note that in real math, ROOT(x,y) = POWER(x,1/y), but that doesn't seem
to be how xlpROOT works.

As I'm sure you know, Excel turns this:

=xlpROOT(2, 1/3)

into this, before sending it to xlPrecision:

=xlpROOT(2, 0.333333333333333)

So the xlpPOWER equivalent would look like this:

=xlpPOWER(2, 1/0.333333333333333)

However, Excel rounds 1/0.333333333333333 to 8 before sending anything to
xlPrecision. So, it isn't equivalent after all. An exact or nearly exact
xlpPOWER equivalent would require 1/0.333333333333333 taken to infinite
precision.

You could get close to the equivalent with this:

=xlpPOWER(2,xlpDIVIDE(1,0.333333333333333))

Except that this is affected by the same underlying bug (and fixed by the
same bugfix).


I'd offer you a free copy of a paid version of xlPrecision for finding this
bug, except that I know from previous posts of yours that you'd have no use
for it, and might even prefer a root canal. Still, it's yours for the asking
if you're interested.


Thanks again,

Greg Lovern
http://PrecisionCalc.com
Get Your Numbers Right