How to Use the RSQ Function in WPS on Windows

Last updated:July 20, 2026

Use WPS RSQ through 4 practical topics, all available in WPS Spreadsheet; choose a task from the How-to Index and follow the steps to enter, review, and recalculate the formula.

How-to Index

No.TopicMembership Requirement
11. Enter the RSQ function for a basic calculationFree
22. Review syntax guidance and confirm parameter orderFree
33. Use cross-worksheet references in RSQFree
44. Check automatic recalculation after data changesFree

How-to Guide

1. Enter the RSQ function for a basic calculation

Entry point: Formulas tab → formula bar

  1. Open WPS Spreadsheet and select the cell where you want the result to appear.
  2. Type = to begin the formula.
  3. Type RSQ(.
  4. Select or enter the first data range as known_y's.
  5. Type a comma, then select or enter the second data range as known_x's.
  6. Type ) and press Enter.

Success Criteria

  • On-screen result: The target cell shows a calculated result.
  • Next action available: You can copy the formula, edit the parameters, or save the worksheet.

Tips While Using

  • Common mistake: If the two data ranges do not contain the same number of points, the formula may return an error.
  • Environment note: It is better to use numeric ranges and avoid invalid references.

2. Review syntax guidance and confirm parameter order

Entry point: formula bar

  1. Select the target cell and type =RSQ(.
  2. Watch the syntax guidance shown in the editing area.
  3. Enter the dependent data range first, then the independent data range.
  4. Check that the parentheses, separator, and references are complete.
  5. Press Enter to finish the formula.

Success Criteria

  • On-screen result: Function guidance appears while the formula is being entered.
  • Next action available: You can continue filling in the parameters and complete the calculation.

Tips While Using

  • Common mistake: Missing parentheses or separators can prevent the formula from calculating correctly.

3. Use cross-worksheet references in RSQ

Entry point: formula bar + worksheet tabs

  1. In the result cell, type =RSQ(.
  2. Switch to the worksheet that contains the first data range and select the range.
  3. Enter the separator, then switch to another worksheet and select the second data range.
  4. Return to the result worksheet and confirm the references in the formula.
  5. Press Enter to generate the result.

Success Criteria

  • On-screen result: The formula contains references from more than one worksheet.
  • Next action available: If source data changes in either worksheet, the result can update accordingly.

Tips While Using

  • Common mistake: Choosing the wrong worksheet or range affects result accuracy.
  • Environment note: The referenced worksheets need to be in the current workbook and accessible.

4. Check automatic recalculation after data changes

Entry point: a cell that already contains RSQ

  1. Open the worksheet where the RSQ result has already been calculated.
  2. Edit one or both source data ranges.
  3. Check whether the result cell updates automatically.
  4. If needed, review the referenced ranges and the source values again.

Success Criteria

  • On-screen result: The result cell shows a new calculated value after the source data changes.
  • Next action available: You can continue adjusting data and comparing results.

Tips While Using

  • Common mistake: Entering numbers as text can affect how the result is interpreted.