Inverse tangent in excel, please help!

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:
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))))
 
Here is a picture of the excel file...
 

Attachments

  • inverse-tangent-example.webp
    inverse-tangent-example.webp
    12.7 KB · Views: 1,100
Back
Top