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

Last updated:July 17, 2026

This how-to guide includes 3 topics, all available without membership; use the index below to jump to the task you need and follow the entry path and steps.

How-to Index

No.TopicMembership Requirement
11. Enter the PERCENTRANK.EXC functionFree
22. Fill in the function argumentsFree
33. Check the result and recalculateFree

How-to Guide

1. Enter the PERCENTRANK.EXC function

Entry path: Formulas tab → formula bar

  1. Open WPS Spreadsheet and select the cell where you want the result to appear.
  2. Type = in the cell or in the formula bar.
  3. Continue by typing PERCENTRANK.EXC(.
  4. Check the syntax prompt and confirm that the function name is recognized.

Success Criteria

  • Interface result: the cell enters formula input mode and the function name appears.
  • What you can do next: you can continue entering arguments and complete the calculation.

Tips While Using

  • Common mistake: if you do not start with =, the content may be treated as plain text.
  • Environment note: complete this task in the WPS Spreadsheet editing interface.

2. Fill in the function arguments

Entry path: formula editing state after typing PERCENTRANK.EXC(

  1. Enter the required arguments based on the syntax prompt.
  2. If you need a data range, drag to select the range in the worksheet or type the reference manually.
  3. If you need a cross-sheet reference, switch to the target sheet and select the needed cell or range.
  4. Check the parentheses, separators, and argument order before confirming.

Success Criteria

  • Interface result: the full argument set appears in the formula.
  • What you can do next: press Enter to return a calculated result.

Tips While Using

  • Common mistake: mismatched parentheses, missing separators, or incorrect argument counts can cause an error.
  • Environment note: numbers stored as text may affect the calculation result.

3. Check the result and recalculate

Entry path: the result cell after the formula has been entered

  1. Press Enter to confirm the formula.
  2. Check whether the result appears in the target cell.
  3. If the referenced data changes, see whether the result updates automatically.
  4. If you need to review the result manually, check the referenced range and arguments again, then confirm the formula.

Success Criteria

  • Interface result: the target cell shows the calculated result.
  • What you can do next: you can copy the formula, adjust arguments, or continue analyzing other data.

Tips While Using

  • Common mistake: unexpected values or incorrect formats in the referenced range can affect the result.
  • Environment note: for nested formulas, review the formula structure step by step.