ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   tanh (https://www.excelbanter.com/excel-discussion-misc-queries/203637-tanh.html)

dglenton

tanh
 
When i do;

=degrees((tanh(1))

i dont get 45 a i would expect.

any ideas?

Rick Rothstein

tanh
 
Tanh is the hyperbolic tangent... I think you wanted the arctangent. This
works as you were expecting...

=DEGREES(ATAN(1))

--
Rick (MVP - Excel)


"dglenton" wrote in message
...
When i do;

=degrees((tanh(1))

i dont get 45 a i would expect.

any ideas?



David Biddulph[_2_]

tanh
 
Why would you expect 45?
Have you reminded yourself (with Excel help, if necessary) of what TANH is?
TANH(1) would be =(EXP(1)-EXP(-1))/(EXP(1)+EXP(-1)), which is not equal to
PI()/4, so DEGREES(TANH(1)) will not be 45.

Are you sure that you didn't mean =DEGREES(ATAN(1)) ?
--
David Biddulph

"dglenton" wrote in message
...
When i do;

=degrees((tanh(1))

i dont get 45 a i would expect.

any ideas?





All times are GMT +1. The time now is 06:18 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com