WPS Features
Resources
Free AI Tools
Docs Center

How to Use

Last updated:July 8, 2026

This how-to guide includes 3 operation topics for COVAR in WPS on Windows; 3 are available without membership and 0 are membership-related.

How-to Index

No.TopicMembership Requirement
11. Insert COVAR from the Insert Function dialogFree
22. Type the formula directly in a cellFree
33. Review syntax and parameter guidanceFree

How-to Guide

1. Insert COVAR from the Insert Function dialog

Entry: 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 COVAR in the dialog box.
  4. Select the function and click OK.
  5. Enter the required parameters in the Function Arguments dialog box.
  6. Click OK to finish entering the formula.

Success Criteria

  • The selected cell now contains the COVAR function.
  • The formula returns a result after the parameters are entered.
  • You can continue editing or copy the formula to other cells.

Tips While Using

  • Searching with the uppercase function name can make the result easier to spot.
  • Keep the paired ranges aligned so the data points correspond correctly.
  • If the result looks wrong, reopen the parameter dialog and review each input.

2. Type the formula directly in a cell

Entry: Worksheet cell → Formula bar

  1. Select the target cell.
  2. Type =COVAR(...) in the cell or in the formula bar.
  3. Press Enter to confirm.
  4. If you want syntax guidance, type =COVAR( and press F1 to open help information.

Success Criteria

  • The formula is entered and the result appears in the cell.
  • The full formula is visible in the formula bar.
  • WPS recognizes the formula after you press Enter.

Tips While Using

  • Separate parameters with English commas.
  • Make sure the referenced ranges contain valid numeric values.
  • If you copy the formula, check whether relative or absolute references are more appropriate.

3. Review syntax and parameter guidance

Entry: Formula tab → Insert Function

  1. Click Insert Function on the Formula tab.
  2. Enter COVAR in the search box.
  3. Select the function and review the syntax shown as COVAR(...).
  4. Click the help link for the function to open more details.

Success Criteria

  • You can see the function name and syntax format for COVAR.
  • You can review parameter guidance before entering the formula.
  • You can return to the worksheet and continue editing.

Tips While Using

  • Online help links usually require an internet connection.
  • After reviewing help, confirm the ranges against your current worksheet data.
  • If the help link is not shown, you can still confirm the syntax in the Insert Function window.