square root

marpad · Mar 23, 2007

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

Dave F · Mar 23, 2007

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

Dave

David Biddulph · Mar 23, 2007

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

Stephen Bye · Mar 23, 2007

David Biddulph said:
=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 · Mar 23, 2007

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

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