View original (French)

Excel Angle Calculation Formula

Solved
Alexair -  
 xdloooool -
Hello,

I would like to create an Excel form to calculate the angle adjacent to the hypotenuse of a right triangle. That is, the angle between the vertical and the hypotenuse.

For example:

A right triangle where:
- Side AB is horizontal.
- Side BC is vertical.
- The triangle is right-angled at B (thus the angle known is 90°).
- The hypotenuse is AC.
What is the angle at C?

So, I need an Excel form where we only have 2 data points to enter:

- AB
- BC

Thank you,

Alex

Configuration: Windows Vista / Internet Explorer 9.0

4 answers

Answer 1 / 4
ccm81 Posted messages 11033 Status Member 2 434
 
Hello

1. math side
Since ABC is right-angled at B, we have tan(C) = BA/BC
Thus C = arctan(BA/BC) (the angle whose tangent is ...)
2. Excel side
If BA is in B2 and BC in B3
- in radians C = ATAN(B2/B3)
- in degrees (decimal) C = 180*ATAN(B2/B3)/PI()

Have a great continuation
4
chossette9 Posted messages 6855 Registration date   Status Contributor Last intervention   1 313
 
Hello,

according to his example, with a right triangle at B, he is looking for the angle at C. So, he should use the ACOS() function instead of ATAN(), right?
0
ccm81 Posted messages 11033 Status Member 2 434
 
> chossette9
the triangle being right-angled at B and knowing BA and BC (initial request) it is indeed tan(C) = BA/BC that we know so .... right
you may have been confused by the end of the statement ...
- The hypotenuse being AC.
What is the angle at C?
it happens!

have a good end of the day
0
xdloooool
 
wshhhhhh how's it going guys
0