spot_img

Calculating sine and cosine of an angle

In this Excel tutorial you will teach yourself how to calculate sine and cosine of an angle in a clever way. First you must realize yourself that Excel prefers radians to degrees. This is really annoying. Here you will see how to calculate sine and cosine when you have radians or degrees.To calculate sine of an angle you can just use SIN function. Formula is =SIN(radians)sine radians

But what to do when you know only degrees? Excel has also RADIANS function built-in =RADIANS(degrees) which convert degrees to radians. Just use it. Formula for sine with degrees is =SIN(RADIANS(degrees))

sin degrees

The same for cose. Formula for cose with radians is =COS(radians)

cose radians

When you know only degrees just use this formula =COS(RADIANS(degrees))

cose degrees

That’s the clever Excel trick how to convert degrees to radians and calculate sine and cosine for an angle. Trig functions are much easier thanks to Excel.

Template

You can download the Template here – Download
Further reading: 
Basic concepts 
Getting started with Excel
Cell References
spot_img
Previous articleAvoid Errors Using IFERROR-Everyone Should Know
Next articleLinking Text Box To A Specific Cell

RELATED ARTICLESMORE FROM AUTHOR