PERCENTRANK.EXC in WPS on Windows FAQ

Last updated:July 17, 2026

This FAQ covers 3 common question types about formula errors, syntax prompts, and result checking, plus a short glossary for key terms.

FAQ

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

  1. Check whether the formula starts with =.
  2. Make sure the parentheses are paired correctly and the separators are in the right places.
  3. Confirm that the argument types and argument count match the function requirements.
  4. Review the syntax prompt and correct the formula item by item.

How can I view the instructions for the PERCENTRANK.EXC function?

  1. Select the target cell and type =PERCENTRANK.EXC(.
  2. Look at the syntax prompt shown in the formula input area.
  3. Use the prompt to confirm the argument order, input method, and example structure.
  4. If needed, test the function with a simple sample dataset first.

Why does the PERCENTRANK.EXC result look incorrect?

  1. Check whether the referenced cells contain numbers stored as text.
  2. Confirm that you selected the correct data range and worksheet.
  3. Review whether nested formulas or circular references are affecting the result.
  4. After correcting the data or references, confirm the formula again.

Glossary

TermDefinition
PERCENTRANK.EXCA statistical function that returns the percentage rank of a value in a dataset on an exclusive scale.
ArgumentThe input used in a function, such as a data range, a target value, or an optional setting.
Cross-sheet referenceA reference to a cell or range located on another worksheet.
Nested formulaA formula structure that includes another function or expression inside the current formula.