If using this formula =SIN(x/y) then we need not need to convert the value to radians. The RADIANS function takes value of angle in degrees and returns the angle in radians. For example, the Excel expression used to convert 270° to radians would be RADIANS(270) which equals 4.712389 radians Excel has a built-in function known as RADIANS(angle) where angle is the angle in degrees you wish to convert to radians. For example, to convert 45° to radians, the Excel expression would be 45*PI( )/180 which equals 0.7854 radians. With Excel, this conversion can be written PI( )/180.

Therefore, if the angle is in degrees, multiply it by p/180° to convert it to radians. When solving trigonometric expressions like sine, cosine and tangent, it is very important to realize that Excel uses radians, not degrees to perform these calculations! If the angle is in degrees you must first convert it to radians. Excel also offers functions to convert angle from radians to degrees and vice versa. However, you can calculate these functions using the core functions (sine and cosine). Excel does not provide functions for secant (sec), cosecant (cosec), cotangent (cot) and for their hyperbolic counterparts. Don’t worry, we are going to look at how to use trigonometric functions in Excel in minutes.Įxcel provides functions for sine (sin), cosine (cos), tangent (tan), hyperbolic sine (sinh), hyperbolic cosine (cosh) and hyperbolic tangent (tanh). If you want to find the sine of 90 degrees, then you should first convert degrees into radians and then use the SIN formula available in Excel. 893997 and not 1 because Excel considers 90 as 90 radians and not 90 degrees. So, if you enter the formula SIN (90) in Excel, the result will be. The main thing you need to consider while solving trigonometric expressions is that Excel performs the calculations considering angle value in radians and not in degrees. You can use these trig functions to solve complex trigonometric expressions. Excel offers a number of built-in functions that deal with trigonometry. Some of them are cot x = 1/tanx, six x/cos x = tan x, sin(900-x) - cos x and so on. You might now be remembering many trigonometric formulas and equations you learned during your school or college days. Trigonometry is a branch of mathematics that studies the relations between the elements (sides and angles) of a triangle. In this article, we will learn How to use trigonometric functions in Excel.

How to angle text in excel graph