PERCENTILE.INC in WPS on Windows FAQ

Last updated:July 20, 2026

This FAQ covers 4 common question types about PERCENTILE.INC, including syntax entry, percentile arguments, unexpected results, and faster percentile calculation steps in WPS.

FAQ

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

  1. Check whether the formula starts with =.
  2. Check whether the function name, parentheses, and separators are complete.
  3. Confirm that the referenced range contains numeric values for calculation.
  4. Press Enter again after correcting the formula.

How should I enter the percentile argument?

  1. Enter a value between 0 and 1 in the second argument position.
  2. Use values such as 0.25, 0.5, or 0.9 based on your target percentile.
  3. Make sure the data range and percentile argument are not reversed.
  4. Review the returned value after the formula is submitted.

Why does the result look incorrect?

  1. Check whether the referenced range is incomplete or incorrect.
  2. Confirm that the numbers in the range are not stored as text.
  3. Review whether outlier values are affecting the percentile result.
  4. Update the source data and compare the recalculated result.

How can I complete percentile calculation faster in WPS?

  1. Select the result cell first and enter =PERCENTILE.INC(.
  2. Drag to select the data range instead of typing the full reference manually.
  3. Use the formula bar to review argument order and parentheses.
  4. Copy the formula to other cells when you need repeated analysis.

Glossary

TermDefinition
PERCENTILE.INCA statistical function that returns the value at a specified percentile in a dataset using inclusive endpoints.
Data rangeA group of cells used in the formula, such as A2:A10.
Percentile argumentThe second argument in the function, usually entered as a decimal between 0 and 1.
Cross-sheet referenceA formula reference that points to cells or ranges in another worksheet.