How to Use the DEGREES Function in WPS on Windows

Last updated:July 20, 2026

This section includes 4 how-to topics, all available without membership; choose a topic from the index and follow the entry path and steps.

How-to Index

No.TopicMembership Requirement
11. Enter the DEGREES functionFree
22. View the function syntax promptFree
33. Use the function with cell referencesFree
44. Refresh and check calculation resultsFree

How-to Guide

1. Enter the DEGREES function

Entry path: Formula tab → Formula bar

  1. Open WPS Spreadsheet and select the cell where you want the result to appear.
  2. Type = in the formula bar or directly in the cell.
  3. Type DEGREES( to begin the formula.
  4. Enter the radian argument and close the parenthesis.
  5. Press Enter to display the result in the current cell.

Success Criteria

  • Interface result: the selected cell shows a degree value.
  • Next action available: you can copy the formula, edit the argument, or fill it down to other cells.

Tips While Using

  • Common mistake: if you skip =, the content is treated as plain text.
  • Environment note: the target cell must be editable.

2. View the function syntax prompt

Entry path: Formula tab → Formula bar

  1. Select the target cell.
  2. Type =DEGREES(.
  3. Check the syntax prompt shown in the editing area.
  4. Review the parameter format shown in the prompt.
  5. Continue entering the formula after confirming the syntax.

Success Criteria

  • Interface result: a syntax or parameter prompt for DEGREES appears while editing.
  • Next action available: you can continue entering the argument and complete the calculation.

Tips While Using

  • Common mistake: a misspelled function name can prevent the prompt from appearing.
  • Environment note: the prompt appears while the formula is being edited.

3. Use the function with cell references

Entry path: Formula tab → Formula bar

  1. Prepare a worksheet cell that contains a radian value.
  2. Select the result cell and type =DEGREES(.
  3. Click the source cell or type its cell reference.
  4. Type the closing parenthesis to complete the formula.
  5. Press Enter to view the converted result.
  6. Copy the formula to other cells if you need batch conversion.

Success Criteria

  • Interface result: the result cell shows the degree value calculated from the referenced cell.
  • Next action available: the result updates when the source value changes.

Tips While Using

  • Common mistake: referencing non-numeric content can produce an unexpected result.
  • Environment note: confirm the reference address when you work across worksheets.

4. Refresh and check calculation results

Entry path: Result cell / keyboard shortcut

  1. Change the formula argument or the referenced source cell.
  2. Check whether the result cell updates automatically.
  3. If needed, press F9 to recalculate manually.
  4. Compare the result with the expected degree value.
  5. If the result looks wrong, review the argument and parentheses in the formula bar.

Success Criteria

  • Interface result: the result refreshes after data changes or after manual recalculation.
  • Next action available: you can continue editing formulas, save the file, or review other cells.

Tips While Using

  • Common mistake: incomplete parentheses or incorrect argument formatting can cause an incorrect result.
  • Environment note: manual recalculation depends on the worksheet being in a normal editable state.