The SIN Function in Excel

The SIN function can be used to calculate the sine of a certain angle.

· Syntax

=Sin(number)

The argument “number” is any numeric expression that expresses an angle in radians. (“PI” radian corresponds to 180 degrees.)

For example, we want to calculate the sine of an angle, which is 30 degrees. So we need to enter the corresponding radians: PI/6.

1. Click the Formulas tab > Insert Function. Enter “SIN” in the dialog and select it.

2. In the pop-up dialog, enter an angle in radians in the Number area, and click OK.

Here we enter “p data-imgw=720 data-imgh=480 data-src="https://res-academy.cache.wpscdn.com/images/36cd9ba1dcdab750d58f7d315b2ca3ba.gif" data-test="skks" style="max-width: 100%; width: 720px; max-height: 480px; height: calc(100vw *(480/720)); text-align:center;" >

In some cases, we only know the degree of an angle, such as 30 degrees, but do not know how to work out its redians.

To convert degrees to radians, we can multiply degrees by “PI()/180”.

In this example, we can enter “30*PI()/180” in the number area. Then we get the same result 0.5.

We can get the same results in these two ways. Give it a try!

For all, easy your work with WPS office suite. Free download WPS Office for PC, Mobile, Windows, Mac, Android, iOS online.