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

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

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"marpad" wrote:

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

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

"marpad" wrote in message
...
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

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
=SQRT(A1)
=A1^0.5
=A1^(1/2)
=POWER(A1,0.5)
=POWER(A1,1/2)

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

"Stephen Bye" wrote in message
...
"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
=SQRT(A1)
=A1^0.5
=A1^(1/2)
=POWER(A1,0.5)
=POWER(A1,1/2)

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

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