Calculate SIN, COS, and TAN in Degrees in WPS Office Spreadsheets
Question details
The user needs to calculate SIN, COS, and TAN for angles entered in degrees in a spreadsheet without changing the default behavior of trigonometric functions.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- The user has angle values in degrees in a worksheet and wants to use trigonometric functions to get correct results.
- Observed behavior
- SIN, COS, and TAN interpret angles as radians by default, so degree values produce unexpected results unless converted.
Make sure the degree values are numeric and stored in cells or entered directly in formulas. Use the RADIANS function inside SIN, COS, or TAN rather than trying to change the default angle unit.
Use the RADIANS function inside SIN, COS, or TAN
Use this method when your angle is in degrees and you need an accurate trigonometric result without changing workbook settings.
WPS Spreadsheets trigonometric functions follow Excel behavior and expect radians by default. Wrapping the degree cell with RADIANS converts the angle only within that formula.
Click the cell where you want the SIN, COS, or TAN result to appear.
Type =SIN(RADIANS(A1)), =COS(RADIANS(A1)), or =TAN(RADIANS(A1)), replacing A1 with the cell that contains the degree value.
Press Enter to calculate the result, then use the fill handle to copy the formula to other angle cells if needed.
Convert radians to degrees with the DEGREES function
Use DEGREES when you have an angle in radians and need the equivalent degree value, such as after using inverse trigonometric functions.
Calculate SIN, COS, and TAN in Degrees in WPS Spreadsheets
Open your workbook in WPS Office and use the RADIANS function inside SIN, COS, or TAN to get degree-based results. WPS Spreadsheets supports the same Excel formula syntax, so you can apply this conversion directly in your existing files.
- 1. Download and install WPS Office: Download WPS Office from the official website, install it, and open WPS Spreadsheets.
- 2. Open your workbook: Open the .xlsx or .xls file that contains the degree values you want to use.
- 3. Enter the trigonometric formula: In the result cell, type =SIN(RADIANS(A1)), =COS(RADIANS(A1)), or =TAN(RADIANS(A1)), changing A1 to your actual angle cell.
- 4. Press Enter and save: Press Enter to calculate the result, then save the workbook in its original Microsoft Excel format or WPS format.
Frequently Asked Questions
Why does SIN(30) not return 0.5 in WPS Spreadsheets?
Because SIN, COS, and TAN expect radians by default. To use degrees, enter =SIN(RADIANS(30)), which will return 0.5.
Can I change WPS Spreadsheets to use degrees by default for SIN, COS, and TAN?
No, there is no global setting that changes these functions to use degrees automatically. Convert each angle inside the formula with the RADIANS function.
How do I convert a radian value back to degrees?
Use the DEGREES function. For example, if cell A1 contains a radian value, enter =DEGREES(A1) in another cell.
Can I use PI()/180 instead of RADIANS?
Yes. For an angle in degrees, you can use =SIN(A1*PI()/180), =COS(A1*PI()/180), or =TAN(A1*PI()/180).
Does this formula work in Microsoft Excel too?
Yes, the same approach works in Microsoft Excel. Use =SIN(RADIANS(A1)), =COS(RADIANS(A1)), or =TAN(RADIANS(A1)).
