Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I find arctanh() in exel
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 "¹³" |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I find arctanh() in exel
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 "¹³" |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I find arctanh() in exel
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) "Neville" wrote in message ... "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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I find arctanh() in exel
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 wrote: 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 "¹³" |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I find arctanh() in exel
"Dana DeLouis" wrote: 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 wrote: 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 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I find duplicates in one column of an exel spreadsheet? | Excel Worksheet Functions | |||
where can i find a download for Exel Spreadsheets file XLS | Excel Discussion (Misc queries) | |||
how do I turn office assistant on in exel cannot find balloon or ? | Excel Discussion (Misc queries) | |||
CAN'T FIND EXEL!!!!! | Excel Discussion (Misc queries) |