Excel has most of the math and trig functions built into it. If you need
to use the SIN, COS, TAN functions, they can be typed
into any cell. If
you wanted to find:
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).
910877 |