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

Last updated:July 20, 2026

This how-to guide includes 4 operation topics, all available without membership; use the index below to jump to the task you need and follow the entry point and steps.

How-to Index

No.TopicMembership Requirement
11. Enter the PERCENTILE.EXC functionFree
22. Review syntax promptsFree
33. Fill in arguments and return a resultFree
44. Recalculate after data changesFree

How-to Guide

1. Enter the PERCENTILE.EXC function

Entry point: Formula bar or target cell

  1. Open WPS Spreadsheet and go to the worksheet where you want to calculate a percentile.
  2. Select the cell where the result should appear.
  3. Type = to begin a formula.
  4. Type PERCENTILE.EXC(.

Success Criteria

  • Interface result: The selected cell enters formula editing mode.
  • Next action available: You can continue entering arguments or review the function prompt.

Tips While Using

  • Common mistake: If you do not start with =, the content may be treated as plain text.
  • Environment note: The worksheet must be editable.

2. Review syntax prompts

Entry point: Formula editing state after typing the function name

  1. After entering PERCENTILE.EXC(, look for the prompt shown near the editing area.
  2. Review the argument order and expected format.
  3. Confirm the data range and percentile value you plan to enter.

Success Criteria

  • Interface result: A syntax prompt related to the function is visible.
  • Next action available: You can continue entering arguments based on the prompt.

Tips While Using

  • Common mistake: If the function name is incomplete or misspelled, the prompt may not match the function you want.

3. Fill in arguments and return a result

Entry point: Formula bar or target cell

  1. Enter the data range argument inside the parentheses.
  2. Add the separator and then enter the percentile argument.
  3. Check that the parentheses and argument format are complete.
  4. Press Enter to confirm the formula.

Success Criteria

  • Interface result: The cell shows a calculated result or a formula error message.
  • Next action available: You can copy the formula, edit the arguments, or continue analyzing the data.

Tips While Using

  • Common mistake: Unmatched parentheses, missing separators, or the wrong number of arguments can cause formula errors.
  • Environment note: The argument values must meet the function's calculation requirements.

4. Recalculate after data changes

Entry point: Result cell that already contains the formula

  1. Edit the original data in the referenced range.
  2. Check whether the result cell updates.
  3. If you want to refresh manually, press F9 to recalculate.

Success Criteria

  • Interface result: The result updates after the data changes or after recalculation.
  • Next action available: You can continue adjusting the data and compare different percentile outcomes.

Tips While Using

  • Common mistake: If the referenced range is incomplete, the result may not match your expectation.
  • Environment note: Manual recalculation depends on the workbook's current calculation state.