How do I find arctanh() in exel

[Neville]

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)/(1−e)] = (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 "¹â„³"

 

[Rick Rothstein]

There are worksheet functions available for those...

ln => LN(number)
arctanh => ATANH(number)

 

[Neville]

There are worksheet functions available for those...

ln => LN(number)
arctanh => ATANH(number)

--
Rick (MVP - Excel)

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)/(1−e)] = (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

 

[Rick Rothstein]

I just noticed you had a couple of other questions which I did not
address...

The "√" symbol stands for the Square Root and Excel has a function for that
as well... it is SQRT(number)

You will have to handle the "¹â„³" symbol as a fractional power. The "^"
symbol is used to raise a number to a power and parentheses are used to
group numbers together. So, if you wanted the find the square root of the
sum of two squared numbers, you would do something like this...

=SQRT(A^2+B^2)

but if you wanted the cube root (what raising a number to this symbol "¹â„³"
means) instead of the square root, you would do this...

=(A^2+B^2)^(1/3)

--
Rick (MVP - Excel)

There are worksheet functions available for those...

ln => LN(number)
arctanh => ATANH(number)

--
Rick (MVP - Excel)

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)/(1−e)] = (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

 

[Dana DeLouis]

a = 6,378,137.0 (Semi-major axis...)

Hi. Just note that your units are not consistent.

a 6378.137
b 6356.75231424518
e 0.0818191908426215

=2*PI()*(POWER(a,2)+(POWER(b,2)*ATANH(e))/e)

510,065,621.724088

= = =
HTH
Dana DeLouis

 

[Neville]

a = 6,378,137.0 (Semi-major axis...)

Hi. Just note that your units are not consistent.

a 6378.137
b 6356.75231424518
e 0.0818191908426215

=2*PI()*(POWER(a,2)+(POWER(b,2)*ATANH(e))/e)

510,065,621.724088

= = =
HTH
Dana DeLouis

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)/(1−e)] = (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 and Dana,

All my calculations in the spreadheet are now completed and a 100% correct,
both of you have helped me from pulling my hair out, thanks again.

Nev.