Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
square root
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
square root
=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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
square root
=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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
square root
"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) |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
square root
"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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cubed square root | Excel Worksheet Functions | |||
Square Root Symbol in VBA | Excel Discussion (Misc queries) | |||
How do I get a (non-square) root of a given number | Excel Discussion (Misc queries) | |||
Square root with a remainder | Excel Worksheet Functions | |||
How do I calculate the Root Mean Square (RMS) | Excel Discussion (Misc queries) |