View Single Post
  #1   Report Post  
Posted to microsoft.public.fr.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
Dailoc Nguyen Dailoc Nguyen is offline
external usenet poster
 
Posts: 2
Default excel spreadsheet function

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.