Thread: square root
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default 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