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

  1.
    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
    1. 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
    2. 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
    3. xdloooool
       
      wshhhhhh how's it going guys
      0