How to Use the PERCENTRANK.EXC Function in WPS on Windows

This section includes 3 how-to topics for PERCENTRANK.EXC, covering insertion from the function dialog box, direct formula entry, and syntax review; choose a topic from the index and follow the 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 PERCENTRANK.EXC in the Insert Function dialog box.
4. Select the function and click OK.
5. Enter each required parameter in the Function Arguments dialog box.
6. Click OK to finish inserting the function.

Success Criteria

• The selected cell now contains the PERCENTRANK.EXC function.
• A calculation result appears after the parameters are entered.
• The formula can be edited, copied, or filled down.

Tips While Using

• Search with the English function name PERCENTRANK.EXC.
• Use numeric data in the selected range to avoid incorrect results.

2. Type the formula directly in a cell

Entry path: Cell → Formula bar

1. Select the target cell.
2. Type =PERCENTRANK.EXC(...) directly in the cell or in the formula bar.
3. Press Enter to confirm.
4. If you want to reuse the formula, drag the fill handle to copy it to other cells.

Success Criteria

• The cell shows a calculated result instead of plain text.
• The full PERCENTRANK.EXC formula is visible in the formula bar.
• Copied cells continue to calculate as expected.

Tips While Using

• Use commas as parameter separators.
• If the referenced range or target value is incorrect, the result may not match your expectation.

3. Review the function syntax and parameter details

Entry path: Formula tab → Insert Function

1. Click Insert Function on the Formula tab.
2. Enter PERCENTRANK.EXC in the search box.
3. Select the function to review its syntax and parameter details.
4. Click the help link for more detailed guidance.

Success Criteria

• You can see the function name, parameter structure, and related descriptions.
• You can confirm the parameter order and purpose before editing.
• You can return to the worksheet and continue entering or revising the formula.

Tips While Using

• An internet connection is needed for online help.
• Reviewing the syntax first can help reduce input mistakes.