Calculating TAN^-1

[Jeff]

In excel, how would one calculate the inverse of TAN (ie. TAN^-1)?

Thank you.

 

[Jerry W. Lewis]

ATAN

Jerry

 

[hgrove]

Jerry W. Lewis wrote...

ATAN

...

ATAN2 is more flexible. For finite tangents,

=ATAN2(TanVal,1)

For infinite tangents (from angles of odd integer multiples of PI/2),

=ATAN2(0,1) or =ATAN2(0,-1

 

[Jerry W. Lewis]

I never noticed that it existed; thanks.

Jerry

Jerry W. Lewis wrote...

..

ATAN2 is more flexible. For finite tangents,

=ATAN2(TanVal,1)

For infinite tangents (from angles of odd integer multiples of PI/2),

=ATAN2(0,1) or =ATAN2(0,-1)