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:
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).
| 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 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).