What is the square root formula for excel

J

Jim

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?
 
J

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
 
A

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.
 
Top