View Single Post
  #4   Report Post  
Posted to microsoft.public.fr.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default excel spreadsheet function

Hi
and just for the fun of it the result for your original formula would
be
-0.240375 - 0.416342i

--
Regards
Frank Kabel
Frankfurt, Germany

"Dailoc Nguyen" schrieb im Newsbeitrag
m...
Hi all,
I have run across one of my project and could not figure this out.
This is mathematically correct, totally, but excel could not give me
the desired answer:
(-3)^(-2/3) returns #NUM!, but
((-3)^(-2))^(1/3) is ok.
This leads to other problems also if you have time to change the base
for the power function (negative and possitive)

I am using Microsoft XP Professional.
Thanks,
Lmn.