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

Last updated:July 17, 2026

Use PERCENTILE.INC through 3 how-to topics, including entering the function, filling in arguments, and checking results; choose a topic from the index and follow the steps.

How-to Index

No.TopicMembership Requirement
11. Enter the PERCENTILE.INC functionFree
22. Fill in arguments and complete the calculationFree
33. Check the result and fix common errorsFree

How-to Guide

1. Enter the PERCENTILE.INC function

Entry point: Formulas tab → formula bar

  1. Open WPS Spreadsheet and go to the worksheet where you want to calculate a percentile.
  2. Select the cell where you want the result to appear.
  3. Type = to begin the formula.
  4. Continue with PERCENTILE.INC( and review the function prompt.

Success Criteria

  • Interface result: =PERCENTILE.INC( appears in the cell or formula bar.
  • Next action available: the argument prompt appears so you can continue entering the data range and percentile value.

Tips While Using

  • Common mistake: if you do not type = first, the entry may be treated as plain text.
  • Environment note: enter the formula in an editable worksheet cell.

2. Fill in arguments and complete the calculation

Entry point: current cell in formula editing mode

  1. Enter the data range in the first argument position, such as one column or a continuous group of cells.
  2. Type a comma to separate the arguments.
  3. Enter a percentile value between 0 and 1 in the second argument position.
  4. Check that the parentheses are complete, then press Enter.

Success Criteria

  • Interface result: a numeric result appears in the current cell.
  • Next action available: when you select the cell again, the full formula is visible in the formula bar.

Tips While Using

  • Common mistake: missing separators or unmatched parentheses can cause a formula error.
  • Environment note: the percentile argument should stay within the valid range required by the function.

3. Check the result and fix common errors

Entry point: result cell → formula bar / referenced cell range

  1. If the result looks incorrect, check whether the formula syntax is complete.
  2. Review whether the referenced range contains values that can be used in calculation.
  3. Confirm that there are no text-formatted numbers, broken references, or circular references.
  4. After data changes, review the referenced range again if you need to verify the updated result immediately.

Success Criteria

  • Interface result: the error indication disappears or the result returns to a normal numeric value.
  • Next action available: after source data changes, the result updates accordingly.

Tips While Using

  • Common mistake: treating text-formatted numbers as numeric values can affect the result.
  • Environment note: for cross-sheet references, make sure the referenced sheet and range are still valid.