How to get Nth root in Excel?

[Enigman O'Maly]

I'm doodling around with formulas to calculate annualized return on investments,
and one of them calls for using the root power equal to the number of years
being considered (i.e., if span is 5 years, use fifth root). I know there is a
SQRT function, but cube roots & higher? Couldn't find anything in the help
(Excel 2000).

 

[Michael R Middleton]

Enigman O'Maly -

I'm doodling around with formulas to calculate annualized return on

investments, and one of them calls for using the root power equal to the
number of years being considered (i.e., if span is 5 years, use fifth root).
I know there is a SQRT function, but cube roots & higher? Couldn't find
anything in the help (Excel 2000). <

Square Root of X = X^(1/2)

Nth Root of X = X^(1/N)

- Mike Middleton, www.usfca.edu/~middleton