PERCENTRANK.INC in WPS on Windows FAQ

Last updated:July 20, 2026

This FAQ covers common questions about formula entry, argument checks, and result changes, plus 3 glossary terms for quick reference.

FAQ

What should I do if PERCENTRANK.INC shows an error after I enter it?

  1. Check whether the formula starts with =.
  2. Check whether the parentheses, argument order, and separators are complete.
  3. Confirm that the referenced range contains numeric values, then press Enter again.

How can I view the argument prompt for PERCENTRANK.INC?

  1. Select an editable cell.
  2. Type =PERCENTRANK.INC(.
  3. Review the syntax prompt in the formula editing area and fill in the arguments accordingly.

Why does the result change after I modify the data?

  1. PERCENTRANK.INC recalculates the relative standing based on the current data range.
  2. When values in the referenced range change, the percentage-rank result changes as well.
  3. If the update is not what you expect, check the referenced range again.

Glossary

TermDefinition
PERCENTRANK.INCA statistical function that returns the percentage rank of a value in a data set, including the 0 and 1 endpoints.
Data rangeA group of cells used in the calculation, usually entered as the first argument of the function.
Automatic recalculationWhen referenced data changes, the spreadsheet recalculates the formula result without requiring manual re-entry.