Microsoft Office Tutorials and References
In Depth Information
=SQRT((hypotenuse^2) - (height^2))
The formula to calculate a right triangle's hypotenuse (given the length of the base and height) is as follows:
=SQRT((height^2)+(base^2))
Other useful trigonometric identities are
SIN(A) = Height/Hypotenuse
SIN(B) = Base/Hypotenuse
COS(A) = Base/Hypotenuse
COS(B) = Height/Hypotenuse
TAN(A) = Height/Base
SIN(A) = Base/Height
Excel's trigonometric functions all assume that the angle arguments are in radians. To
use the DEGREES function.
If you know the height and base, you can use the following formula to calculate the angle formed by the hypo-
tenuse and base (angle A):
=ATAN(height/base)
The preceding formula returns radians. To convert to degrees, use this formula:
=DEGREES(ATAN(height/base))
If you know the height and base, you can use the following formula to calculate the angle formed by the hypo-
tenuse and height (angle B):
=PI()/2-ATAN(height/base)
The preceding formula returns radians. To convert to degrees, use this formula:
=90-DEGREES(ATAN(height/base))
This book's website contains a workbook — solve right triangle.xlsm — with formulas
that calculate various parts of a right triangle, given two known parts. These formulas
Search JabSto ::

Custom Search