How to Use

This how-to guide includes 3 topics for using COVARIANCE.P, covering insertion from the Insert Function dialog box, direct formula entry, and syntax review. Choose a topic from the index and follow the entry path and steps.

How-to Index

How-to Guide

1. Insert the function from the Insert Function dialog box

Entry path: 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.P in the Insert Function dialog box.
4. Select the function and click OK.
5. Enter each argument in the Function Arguments dialog box.
6. Click OK to finish inserting the function.

Success Criteria

• The COVARIANCE.P function appears in the selected cell.
• You can continue filling in arguments and get a calculation result.

Tips While Using

• Search with the English function name COVARIANCE.P.
• Use numeric ranges in the arguments and avoid mixing in text values.

2. Type the formula directly in a cell

Entry path: Cell → Formula bar

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

Success Criteria

• The formula is entered in the target cell.
• After you press Enter, the sheet returns a result or lets you continue completing the arguments.

Tips While Using

• Use English commas to separate arguments.
• Press Enter after typing the formula.

3. Review function syntax and parameter details

Entry path: Formula tab → Insert Function

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

Success Criteria

• The function name and syntax structure are visible.
• You can continue reviewing argument details or return to the sheet to enter the formula.

Tips While Using

• Keep an internet connection available if you want to open the help link.
• After reviewing the details, check the argument order and referenced ranges again.