Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do you calculate the nth root of a number in Excel 2003?
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. |
#2
|
|||
|
|||
For eg: 4th root of 16 = 2 is entered as follows
=16^(1/4) "William" wrote in message ... 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. |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
how to increase maximum number of columns in excel 2003 | Excel Discussion (Misc queries) | |||
How does Excel 2003 calculate trendlines with respect to axes? | Charts and Charting in Excel | |||
Excel 2003 -- I need to know how to calculate a percentage of uni. | Excel Discussion (Misc queries) |