![]() A number is required to calculate the SIN of it. SIN function has only one argument, which is a number. Hence in order to solve for the height of the tree h, we find h= x SIN θ. We know that if we stand 76 m from the top of the tree (x = 76 m), the line of sight to the top of the tree is 32° with respect to the horizon (θ = 32°). Say, for example, we want to know the height of the tree in the figure shown above. To convert it into a degree, we can use the radian function and get a SIN of 45 degrees, as shown in the last row. SIN 45 = 0.85 is the SIN of 45 radians which means by default, excel takes all the angles in radians and not degree. Both examples imply a SIN of 30 degrees which gives a value of 0.5. Radians and Pi/180 have equal value in mathematics, and hence SIN function gives the same value. This basically means the SIN of Pi radians is 0. Now, let’s look at another example showing the results of the SIN function for various values.Įxplanation of the results shown in the above table:ģ.14 is the value of Pi, and we can use both methods to get a value of 0. Hence we will multiply 60 by PI()/180.Īs we can see, this is the same as the above examples. But this wouldn’t give us the corresponding value of 60 degrees in radians. Next, we will directly pass 60° as the argument to the SIN function. We begin by writing the SIN function in the same way as above. For example, to convert 60° to radians, the Excel expression would be 60*PI( )/180, which equals 1.0472 radians. In Excel, this conversion can be written PI( )/180. So, if the angle is in degrees, multiply it by π/180° to convert it to radians. We remember from our time in school that π = 180°. There is yet another way to convert a degree value to radians for our use in the SIN function. Example #3Ĭalculating Sine Value using SIN and PI Function in Excel So, we see that the result is the same as the first example. So, we shall pass 60 as the value to RADIANS(). Next, we will pass RADIANS(60) as an argument to the SIN function, where 60 is the value in degrees.Īs we can see from the example above, RADIANS() accepts a value in degrees. So, we start off with the earlier version of the SIN( ): We will use the RADIANS() to find out the radian value, which we will pass as an argument to the SIN function. Now let us see how we can use SIN in a more productive way in the case when we don’t know the exact radian value for a degree. Once we do this, we will get the SIN value of 60 degrees.Ĭalculating Sine Value using SIN and RADIAN Function in Excel So, in this case, we will write “=SIN(1.0472)”, where 1.0472 is the radians equivalent of 60 degrees. This number usually represents a value in radians. Let’s understand how to use the SIN Function in Excel by using some examples and real-life illustrations of SIN Function in Excel.Īs you can see from the above screenshot, the SIN function in Excel expects a number as an input. ![]() As an example, DEGREES(PI( )/2 ) evaluates 90. This function can be used to do the exact opposite of the RADIANS function by converting radians to degrees. Take the instance where the expression that is utilized to transform 210° into radians is “RADIANS(210)”, and it evaluates to 66519 radians.Ĭonversely, the DEGREES utility is equally important. It accepts an angle as an argument, in which the angle refers to the degrees that have to be transformed into radians.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |