decimal powers of negative numbers

I will appreciate very much if somebody can help me with this problem:
How can I get the value for
-2^1.85 with excel.

Thanks in advance

S Martinez
Santiago
Chile

Hi,

Could you work out +2^1.85 and then convert to a minus value.

e.g


="-"&ABS(-2)^1.85

VBA Noob

Hi,

g = IMPOWER(COMPLEX(-2,0),1.85)

Will give the answer to this query, verified by the Microsoft Mathematics App.
ie. 3.21208016845614-1.63663659164475i

However if you try the reverse: g^(1/1.85), Excel gives the answer:
1.935465893867-0.503956122770248i again verified by Microsoft Mathematics App.
Using IMABS: IMABS(1.935465893867-0.503956122770248i) = 2

The statistical computing program "R" also gives this and also -2.00+0.0i.

Normek