nth root

[phil]

I'm trying to set up a formula to calculate growth rates using roots.

I need to use a root calculation where the root changes for each calculation

For example: to calculate the square root of a value in a cell you would
use the SQRT function.

But if I want to calculate the cube root, how would I do that?

Thanks!

 

[A.W.J. Ales]

Phil,

SQRT(A1) = A1^(1/2)
In the same way : A1^(1/3) ; A1^(1/4) etc


--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

 

[Chip Pearson]

Phil,

The Nth root of any number is that number raised to the 1/N
power. Therefore, you can use a formula like

=A1^(1/N)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Bernard V Liengme]

Hi Phil,
The formula = A1^1/n is fine but if you like functions try =POWER(A1, 1/n)
Bernard