Problem
You need to become familiar with Excel's support for trigonometric functions .
Solution
Explore the trigonometric functions summarized in Table 75.
Function 
Syntax 
Description 

SIN 
=SIN(angle) 
Returns the sine of the given angle, where angle is in radians. 
COS 
=COS(angle) 
Returns the cosine of the given angle, where angle is in radians. 
TAN 
=TAN(angle) 
Returns the tangent of the given angle, where angle is in radians. 
ASIN 
=ASIN(n) 
Returns the inverse sine of the given number, n, where n must be within the range 1 to 1. The returned angle is in radians and within the range p/2 to p/2. 
ACOS 
=ACOS(n) 
Returns the inverse cosine of the given number, n, where n must be within the range 1 to 1. The returned angle is in radians and within the range 0 to p. 
ATAN 
=ATAN(n) 
Returns the inverse tangent of the given number, n. The returned angle is in radians and within the range p/2 to p/2. 

Discussion
The trigonometric functions take or return angles in radians. However, often degrees are more convenient to work with. Excel provides two functions making conversions between radians and degrees easy: RADIANS and DEGREES. Use RADIANS(angle) to convert an angle from degrees to radians. Use DEGREES(angle) to convert an angle from radians to degrees. For example, =COS(RADIANS(45)) returns the cosine of the angle 45 degrees.
Using Excel
Getting Acquainted with Visual Basic for Applications
Collecting and Cleaning Up Data
Charting
Statistical Analysis
Time Series Analysis
Mathematical Functions
Curve Fitting and Regression
Solving Equations
Numerical Integration and Differentiation
Solving Ordinary Differential Equations
Solving Partial Differential Equations
Performing Optimization Analyses in Excel
Introduction to Financial Calculations
Index