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

convert degrees to radians, use the RADIANS function. To convert radians to degrees,

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