square root

[Guest]

hello all,

I need to apply square root in a formula than determines safety stock for
inventory replanishment, but i cannot find the function for it

 

[Guest]

=SQRT() or =A1^(1/2) etc.

Dave

 

[David Biddulph]

=SQRT(A1)
=A1^0.5
=A1^(1/2)
=POWER(A1,0.5)
=POWER(A1,1/2)
....

 

[Stephen Bye]

=SQRT(A1)
=A1^0.5
=A1^(1/2)
=POWER(A1,0.5)
=POWER(A1,1/2)

You missed out
=EXP(LN(A1)/2)

 

[David Biddulph]

You missed out
=EXP(LN(A1)/2)

In which case, also =10^(LOG10(A1)/2)
and I suppose we could add =GEOMEAN(1,A1)