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

Last updated:July 20, 2026

This section covers 3 how-to topics: entering the function, completing a percentage-rank calculation with arguments, and using cross-sheet references with recalculation; choose a topic from the index and follow the steps.

How-to Index

No.TopicMembership
11. Enter the PERCENTRANK.INC functionFree
22. Complete a percentage-rank calculation with argumentsFree
33. Use the function with cross-sheet references and recalculationFree

How-to Guide

1. Enter the PERCENTRANK.INC function

Entry point: 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 formula bar.
  3. Continue with PERCENTRANK.INC(.
  4. Check the syntax prompt and confirm the function name and argument structure.

Success Criteria

  • Interface result: The cell enters formula editing mode and shows the function name.
  • Next action available: You can continue entering arguments and complete the formula.

Tips While Using

  • Common mistake: The function name must start after an equals sign.
  • Environment note: If the current cell is read-only, switch to an editable area first.

2. Complete a percentage-rank calculation with arguments

Entry point: Select the result cell and type the formula directly

  1. Type =PERCENTRANK.INC( in the target cell.
  2. Select or enter the data range as the first argument.
  3. Enter the target value whose rank you want to evaluate as the second argument.
  4. Add the optional significance argument if needed, then close the parenthesis.
  5. Press Enter to confirm and view the result.

Success Criteria

  • Interface result: The result cell shows a percentage-rank value.
  • Next action available: You can copy the formula to other cells or adjust the arguments further.

Tips While Using

  • Common mistake: Missing parentheses, incorrect separators, or an invalid range can affect the result.
  • Environment note: The referenced range should contain numeric values for calculation.

3. Use the function with cross-sheet references and recalculation

Entry point: Edit the formula in a target cell and reference data from another worksheet

  1. Type =PERCENTRANK.INC( in the result cell.
  2. Switch to another worksheet and select the data range you want to reference.
  3. Return to the current worksheet and continue entering the target value or another nested function.
  4. Press Enter to complete the formula.
  5. Change the source data and check whether the result updates automatically.

Success Criteria

  • Interface result: The formula includes a cross-sheet reference.
  • Next action available: When the source data changes, the result updates accordingly.

Tips While Using

  • Common mistake: Selecting the wrong range during cross-sheet referencing changes the result.
  • Environment note: If workbook calculation behavior changes, check whether the sheet has refreshed.