Inverse tangent in excel, please help!

JurgSpam

JurgSpam

Joined
Mar 28, 2011
Messages
2
Reaction score
0
Hello everyone! :bow:

I would like to calculate this formula in MS Excel.

formule1.gif


Can someone please help me finding the right formula for MS Excel (2007)? I hope someone can help!

Thanks in advance!
- JurgSpam
 
Last edited:
T

trio

Joined
Dec 20, 2011
Messages
3
Reaction score
0
cell a1 labeled as "Input A", cell a2 labeled as "Input B", cell a3 labeled as "Degrees", cell a4 labeled as "Answer".

Cell b1 = 150, cell b2 = 50, cell b3 = 48
then...
Cell b4 = (DEGREES(ATAN((B1*SIN(RADIANS(B3)))/((B1*COS(RADIANS(B3)))-B2))))
 
T

trio

Joined
Dec 20, 2011
Messages
3
Reaction score
0
Here is a picture of the excel file...
 

Attachments

  • inverse-tangent-example.JPG
    inverse-tangent-example.JPG
    19.2 KB · Views: 1,095

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

Inverse Tangent in excel formulae 1
TAN INVERSE ? 3
Inverse sin 3
Count range of cells if not next to each other 0
How to calculate `inverse tangent` from a given numeric value 1
how do I use the inverse sine (sin -1) function in Excel 2007? 1
Advanvnce formula and function 1
Excel Average dates help 0

Top