What is the square root formula for excel

[Guest]

I am working on a standard deviation question in excel and I do not know the
formula to square root a number. Can anyone tell me what it is?

 

[JohnI in Brisbane]

Jim,

Any of the following will work for the square root of 2 (as an example):

=SQRT(2)

=2^0.5

= 2^(1/2)

regards,

JohnI

 

[Arsenio Oloroso]

Follow-up question: Is there an Excel function to calculate the n-th
root of a number? I've been constructing the formulas by raising to the
1/n power. But it'd be handier if there was a standard function in
Excel. I use this to figure compounded annual growth rate.

 

[Norman Jones]

Hi Arsenio,

The nth root of X = X^(1/n)

 

[Bernard Liengme]

Alternative: =POWER(A1, 1/3) for cube root.

 

[Arsenio Oloroso]

Ahh! I'll try it. I presume this works for ^1/n. Yes?