How do I find arctanh() in exel
"Rick Rothstein" wrote:
There are worksheet functions available for those...
ln = LN(number)
arctanh = ATANH(number)
--
Rick (MVP - Excel)
"Neville" wrote in message
...
Please help me with a formular I need to enter into an exel spreedsheet
cell;
Surface area of the Earth =
A = 2πaSQRT+π(bSQRT/e)ln[(1+e)/(1e)] = (answer 510065621.724)
or (= 2π[aSQRT+(bSQRT/e)arctanh(e)])= (answer 510065621.724)
where
a = 6,378,137.0 (Semi-major axis = equatorial radius = a)
b = 6,356,752.314245180 (Semi-minor axis = polar radius = b)
e = 0.08181919084262150(first eccentricity)
I get stuck with the symbols "ln" and "arctanh"
Radius of sphere of equal surface area = ½(A/π) = (answer 6371007.1809)
I get stuck with the symbol ""
Radius of sphere of equal volume = (¾V/π)¹³ = (a2b)¹³ = (answer
6,371,000.790)
where "V" volume = 1,083,207,319,801.0
I get stuck with the symbol "¹³"
Thanks Rick
|