WPS Features
Resources
Free AI Tools
Docs Center

How to Use the PERCENTRANK Function in WPS on Windows

Last updated:July 14, 2026

This section includes 3 how-to topics for using PERCENTRANK, including inserting the function, typing the formula directly, and reviewing syntax details; 3 are free and 0 are membership-related.

How-to Index

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

How-to Guide

1. Insert PERCENTRANK from the Insert Function dialog

Entry point: Formula tab → Insert Function, or the fx button in the formula bar

  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 in the Insert Function dialog.
  4. Select the function and click OK.
  5. Enter each required parameter in the Function Arguments dialog.
  6. Click OK to finish inserting the function.

Success Criteria

  • Interface result: The target cell now contains a PERCENTRANK formula.
  • What you can do next: You can continue editing parameters, press Enter to confirm, or copy the formula to other cells.

Tips While Using

  • Search with the English function name PERCENTRANK.
  • Before confirming the formula, check that the data range and target value reference are correct.

2. Type the formula directly in a cell

Entry point: A worksheet cell or the formula bar

  1. Select the cell where you want to enter the formula.
  2. Type =PERCENTRANK(...) directly in the cell or formula bar.
  3. Press Enter to confirm.
  4. If needed, review the current prompt after typing =PERCENTRANK(.

Success Criteria

  • Interface result: The cell shows a calculated result, and the formula bar keeps the full formula.
  • What you can do next: You can fill down, copy the formula, or adjust references further.

Tips While Using

  • Use English commas as parameter separators.
  • If the result looks incorrect, check whether the referenced range contains valid numeric values.

3. Review function syntax and parameter details

Entry point: Formula tab → Insert Function

  1. Click Insert Function on the Formula tab.
  2. Enter PERCENTRANK in the search box.
  3. Select the function to review its syntax and parameter details.
  4. Open the related help entry if you want more detailed guidance.

Success Criteria

  • Interface result: You can see the PERCENTRANK function name, syntax structure, and parameter area.
  • What you can do next: You can return to the worksheet and continue entering or editing the formula.

Tips While Using

  • Pay attention to how the data range, target value, and optional parameter are entered.
  • If this is your first time using the function, test it with sample data first.