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

Last updated:July 16, 2026

This how-to guide includes 3 operation topics, all available without membership, so you can choose a method from the index and complete formula entry or help lookup in WPS Spreadsheet.

How-to Index

No.TopicMembership Requirement
11. Enter the function from the Insert Function dialogFree
22. Type the formula directly in a cellFree
33. Review syntax and argument detailsFree

How-to Guide

1. Enter the function from the Insert Function dialog

Entry point: Formula tab → Insert Function

  1. Select the cell where you want to enter the formula.
  2. Click the fx button in the formula bar, or click Insert Function on the Formula tab.
  3. Search for COVARIANCE.S in the dialog box.
  4. Select the function and click OK.
  5. Enter the required arguments in the Function Arguments dialog.
  6. Click OK to finish inserting the function.

Success Criteria

  • Interface result: The target cell contains the COVARIANCE.S function.
  • Next action available: You can continue adjusting argument ranges or press Enter to calculate.

Tips While Using

  • Common mistake: A misspelled function name can make the function harder to find in the search box.
  • Environment note: Open a WPS Spreadsheet workbook before starting.

2. Type the formula directly in a cell

Entry point: Cell → Formula bar

  1. Select the cell where you want to enter the formula.
  2. Type =COVARIANCE.S(...) directly in the cell or formula bar.
  3. Press Enter to confirm the formula.
  4. If you want to review argument guidance, type =COVARIANCE.S( and then press F1 to check syntax prompts.

Success Criteria

  • Interface result: The cell shows the calculation result, and the formula bar keeps the full formula.
  • Next action available: You can copy the formula to other cells for reuse.

Tips While Using

  • Common mistake: Incorrect separators or range references can cause unexpected results.
  • Environment note: Make sure the referenced ranges contain numeric data.

3. Review syntax and argument details

Entry point: Formula tab → Insert Function

  1. Click Insert Function on the Formula tab.
  2. Enter COVARIANCE.S in the search box.
  3. Select the function to review its syntax and argument details.
  4. Click the help link for the function if you want more detailed guidance.

Success Criteria

  • Interface result: You can see the function name, argument structure, or help entry.
  • Next action available: You can return to the worksheet and continue entering or editing the formula.

Tips While Using

  • Common mistake: If the wrong function is selected, the displayed description will not match COVARIANCE.S.
  • Environment note: The exact help display may vary with the current interface state.