The SIN Function in Excel
A free Office suite fully compatible with Microsoft Office
A free Office suite fully compatible with Microsoft Office
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 “PI()/6”. Then we will get a result lies in the range -1 to 1, and in this example, we get 0.5.
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.
Was this helpful?
Yes
No
Trending Tutorials
- 1. How to get month name from a date in Excel (3 easy ways)
- 2. Check if value is in list in Excel (3 easy methods)
- 3. How to Copy File Names in Excel from a Folder?
- 4. How to color cell based on value in Excel?
- 5. How to add text to beginning or end of all cells in Excel
- 6. How to compare two excel sheets and highlight differences