I've run into a problem I don't understand using power functions. I've only
done limited work with powers in Excel, but I've run into a problem with
this formula;
=(-0.01^ (2/3))
This returns #Num
I tried to reformat to
=POWER(-0.01, (2/3))
and still get the same #Num.
I split the exponent into
=((-0.01^ (2))^(1/3))
and this works.
Why don't the first two formats work?
Thanks,
Bernie
Bookmarks