Calculating TAN^-1

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Thank you.
 
Jerry W. Lewis wrote...
ATAN
Click to expand...
...

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
 
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)
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I do the inverse of tan in Excel? 12
TAN INVERSE ? 3
Invarse Tan in Excel 0
how do i calculate inverse tan? 5
TAN different to a calculator? Please help would be appreciated lo 5
Calculator in C# 1
Excel question. 2
Tan and Gold have disapped from my color scheme 2

Back
Top