View Single Post
  #3   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
try
=A1^(1/n)

"William" wrote:

Does anyone know how you calculate the nth root of a number in Excel 2003? I
want to calculate the annalized percentage rate of return from a table to
absolute percentage returns for a series of years, so I nee to be able to
calculate the nth root of the total return + 1, where n is the number of
years.