How to get Nth root in Excel?

  • Thread starter Thread starter Enigman O'Maly
  • Start date Start date
E

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).
 
Enigman O'Maly -
I'm doodling around with formulas to calculate annualized return on
Click to expand...
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
 
Back
Top