PERCENTILE.EXC in WPS on Windows: Introduction

PERCENTILE.EXC in WPS is a statistical spreadsheet function that returns a percentile value while excluding the 0 and 1 endpoints; this guide covers 4 core tasks, with 4 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	4	Matches the number of rows in the How-to Index
Available without membership	4	Matches the number of Free rows in the index
Membership-related items	0	Matches the number of membership-related rows in the index

About This Feature

Overview

PERCENTILE.EXC is a built-in statistical function in WPS Spreadsheet on Windows. It is used to return the requested percentile from a dataset while excluding the 0 and 1 endpoints.

Core tasks include:

Enter =PERCENTILE.EXC( directly in a worksheet cell.
Review syntax prompts while typing the function.
Fill in the required arguments and return a result in the target cell.
Recalculate the result after source data changes.

This function is useful for score analysis, sales segmentation, and distribution review. It helps reduce manual sorting and estimation when you need a percentile threshold inside a worksheet.

System Requirements

Item	Requirement
Operating system	A Windows device that can run WPS Office normally
App version	It is recommended to use the latest version of WPS Office
Network	No mandatory internet connection is required for local formula calculation; internet access is needed for download, sign-in, or sync
Other	You need access to WPS Spreadsheet files and permission to edit cells

Download & Installation

Item	Details
Official download	WPS Office Free Download
Installation method	Download the Windows installer and complete setup by following the on-screen prompts
Post-installation check	Open WPS Spreadsheet and enter `=PERCENTILE.EXC(` in a cell or in the formula bar

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Supports entering `=PERCENTILE.EXC(` in a spreadsheet cell and completing the formula with syntax prompts and arguments.	Excel provides `PERCENTILE.EXC(array,k)` and returns the k-th percentile of values in a range with 0 and 1 excluded.	Google Sheets provides `PERCENTILE.EXC(data, percentile)` and returns the percentile value with 0 and 1 excluded.	Notion formulas support many properties, operators, and functions, but the public help page does not document a native `PERCENTILE.EXC` spreadsheet-style function.	Adobe Acrobat Sign documentation focuses on document fields and text tags rather than spreadsheet percentile functions.
WPS Advantages	Advantage: You can enter the function directly in the WPS Spreadsheet formula workflow and review syntax prompts while editing. Advantage: It fits naturally into worksheet-based analysis with other spreadsheet formulas.	Compared with WPS: Excel offers a directly comparable function and documents the syntax and valid k range on its official support page.	Compared with WPS: Google Sheets offers a directly comparable function and documents syntax, notes, and examples on its official help page.	Compared with WPS: Notion is oriented toward database property formulas instead of cell-based spreadsheet functions.	Compared with WPS: Adobe is oriented toward document workflows and field authoring instead of spreadsheet statistics.
Official Source	—	PERCENTILE.EXC function in Excel	PERCENTILE.EXC function in Google Sheets	Notion formula syntax and functions	Text Tags in Adobe Acrobat Sign

Overall Conclusion: For percentile analysis in spreadsheets, WPS, Excel, and Google Sheets all provide a direct function path for this task. Notion and Adobe focus on database formulas or document workflows, so they are less aligned with cell-based percentile calculation scenarios.

Use Cases

No.	Scenario	Suitable For	Main Need	How PERCENTILE.EXC Helps
1	Score percentile analysis	Teachers and academic staff	Find the score value at a target percentile	Returns the requested percentile from a score range
2	Sales data segmentation	Sales analysts	Set percentile-based thresholds for grouping	Calculates a percentile cutoff from sales data
3	Sample distribution review	Research and data users	Reduce manual estimation during analysis	Returns a percentile result directly in the sheet
4	Dynamic report checking	Everyday office users	Recheck percentile results after data updates	Recalculates after referenced values change

Membership & Benefits

Free vs WPS Premium

Capability	Free Users	WPS Premium
Enter and calculate PERCENTILE.EXC	✅ Available	✅ Available
Basic spreadsheet editing	✅ Available	✅ Available
Additional advanced benefits and value-added tools	Available within the free offering shown on the product page	Includes more advanced features and benefits
Cloud storage and extended services	Available within the free plan scope	Usually includes broader extended benefits

Source: WPS Office pricing page

Recommendations

Scenario	Recommended Plan	Why
Everyday formula use and basic statistics	Free plan	PERCENTILE.EXC itself is available for regular worksheet calculation
Broader office needs with more advanced benefits	WPS Premium	Suitable if you also need more advanced features, cloud space, or added services

Visit the membership page to review current plans: Subscribe to WPS Premium