#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default tanh

When i do;

=degrees((tanh(1))

i dont get 45 a i would expect.

any ideas?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,934
Default 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?


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default 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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 04:25 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"