Excel has most of the math and trig functions built into it. If you need to
use the SIN,
angle |
sin |
cos |
tan |
REF |
=sin(REF) |
=cos(REF) |
=tan(REF) |
0 |
0.00 |
1.00 |
0.00 |
30 |
0.50 |
0.87 |
0.58 |
45 |
0.71 |
0.71 |
1.00 |
90 |
1.00 |
0.00 |
|
180 |
0.00 |
-1.00 |
0.00 |
format for degrees formula = sin (angle * pi()/180) the argument
angle is in degrees
format for radians formula = sin (angle) the argument angle is in
radians
To calculate trig functions in degrees you must convert them - otherwise excel will calculate them in radians.
You can type in either an actual number for the REF or you can also type in a reference from the excel spreadsheet (like A2).
467308