How to Use the COVARIANCE.S Function in WPS on Windows

Follow 4 how-to topics to use COVARIANCE.S in WPS Spreadsheet on Windows; all 4 topics are available without membership and 0 are membership-related.

How-to Index

How-to Guide

1. Enter the COVARIANCE.S function

Entry point: Formula tab → formula bar

1. Open WPS Spreadsheet and select the cell where you want the result to appear.
2. Type = to begin a formula.
3. Continue with COVARIANCE.S(.
4. Get ready to enter the required arguments.

Success Check

• What you should see: The selected cell enters formula editing mode.
• What you can do next: Continue entering arguments and complete the formula.

Notes

• Common mistake: If you do not start with =, the entry may be treated as plain text.
• Limitation: You need to work in an editable spreadsheet cell.

2. Fill in the function arguments

Entry point: Formula bar or the active cell

1. After COVARIANCE.S(, enter the first array or cell range.
2. Add the separator and then enter the second array or cell range.
3. Check that the parentheses are complete.
4. Press Enter to confirm the calculation.

Success Check

• What you should see: The cell shows a calculated result or a completed editable formula.
• What you can do next: Select the cell again to review the full formula.

Notes

• Common mistake: An incorrect number of arguments or a wrong range selection can cause an error.
• Limitation: Referenced ranges should contain data that can be used in the calculation.

3. Use cross-sheet references or nested formulas

Entry point: Formula bar

1. While editing the formula, switch to another worksheet and select the data range you want to reference.
2. Return to the current cell and confirm that the reference address is correct.
3. Add other functions if needed to build a nested formula.
4. Press Enter to finish the entry.

Success Check

• What you should see: The formula contains a cross-sheet reference or a nested structure.
• What you can do next: Change referenced data and observe how the result responds.

Notes

• Common mistake: If a sheet name or referenced range changes, review the formula again.
• Limitation: Nested formulas should keep a complete argument and parenthesis structure.

4. Check automatic result updates

Entry point: The result cell that already contains the formula

1. Locate the source data range used by the COVARIANCE.S formula.
2. Change one or more values in that range.
3. Return to the result cell and observe the updated value.
4. If needed, select the result cell again to review the formula.

Success Check

• What you should see: The result cell updates when the referenced data changes.
• What you can do next: Keep adjusting data and compare different outcomes.

Notes

• Common mistake: Numbers stored as text can affect the calculation result.
• Limitation: If workbook calculation settings have been changed, confirm that recalculation is working normally.