WPS Features
Resources
Free AI Tools
Docs Center

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

Last updated:July 13, 2026

This how-to guide includes 3 operation topics for using PERCENTILE.INC in WPS on Windows, with 3 available without membership and 0 membership-related items.

How-to Index

No.TopicMembership Requirement
11. Insert it from the Insert Function dialog boxFree
22. Type the formula directly in a cellFree
33. Check syntax and parameter detailsFree

How-to Guide

1. Insert it from the Insert Function dialog box

Entry path: Formulas tab → Insert Function

  1. Select the cell where you want to show the result.
  2. Click the fx button in the formula bar, or click Insert Function on the Formulas tab.
  3. Search for PERCENTILE.INC in the dialog box.
  4. Select the function and click OK.
  5. Enter the data range and percentile argument in the Function Arguments dialog box.
  6. Click OK to finish.

Success Criteria

  • Interface result: The target cell contains a PERCENTILE.INC formula.
  • What you can do next: You can continue editing arguments, copy the formula, or confirm the result.

Tips While Using

  • Common mistake: A misspelled function name can make the function harder to find.
  • Environment note: If the worksheet is protected, you may not be able to edit the target cell directly.

2. Type the formula directly in a cell

Entry path: Cell or Formula Bar

  1. Select the cell where you want to enter the formula.
  2. Type =PERCENTILE.INC(...) directly in the cell or in the formula bar.
  3. Press Enter to confirm.
  4. If needed, continue filling in the arguments after the opening parenthesis by following the on-screen hints.

Success Criteria

  • Interface result: The cell shows the calculated result, and the formula bar keeps the full formula.
  • What you can do next: You can drag the fill handle to copy the formula to other cells.

Tips While Using

  • Common mistake: Incorrect separators or parentheses can prevent the formula from calculating.
  • Environment note: If the referenced range contains unsuitable data, the result may return an error or differ from what you expect.

3. Check syntax and parameter details

Entry path: Formulas tab → Insert Function

  1. Click Insert Function on the Formulas tab.
  2. Enter PERCENTILE.INC in the search box.
  3. Select the function and review the syntax and parameter description area.
  4. If you need more details, open the related help entry and continue reviewing the instructions.

Success Criteria

  • Interface result: You can see the function name, syntax structure, and parameter descriptions.
  • What you can do next: You can return to the worksheet and continue entering or editing the formula.

Tips While Using

  • Common mistake: Checking only the function name without confirming the parameter order can lead to incorrect results.
  • Environment note: Opening online help requires an internet connection.