How to calculate `inverse tangent` from a given numeric value

G

Guest

I wish to know how to calculate the size of an angle, in degrees, by using
the inverse tangent of a given numeric value.
This is to be done using `formulas` in Excel in XP.
This is easy to calculate using the scientific calculator on the PC but
would appear to be an unavailable function in `formulas`, unless of course it
involves conversion to radians.
Any ideas will be most welcome.
 
J

Jerry W. Lewis

=DEGREES(ATAN(tangentValue))

Excel does trig in radians instead of degrees, but there are RADIANS()
and DEGREES() functions for conversions.

Jerry
 

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 calculate inverse tan? 5
Changing Radians to Degrees 5
Finding NEXT to last, non zero numeric value in a row 3
how to get the median of cells that meet a given criteria in excel 1
Distinguishing between Cells with Formula vs Cells with Text/Value 3
Inverse Tan function 2
How to calculate the present value of a security, $5000 @ 7%, 20y. 1
HOW TO WRITE INWORD FORMAT OF A NUMERIC VALUE 5

Top