PERCENTILE.EXC in WPS on Windows: Introduction

PERCENTILE.EXC in WPS is a spreadsheet function for calculating percentile values with 0 and 1 excluded from the percentile range; 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
Version scope	No version restriction stated	Available across Smart Spreadsheet versions

About This Feature

Overview

PERCENTILE.EXC is a built-in statistical function in WPS Spreadsheet for Windows. It is useful for percentile-based analysis in score distribution, business threshold setting, and general data analysis.

Core capabilities include:

Start the function quickly by typing =PERCENTILE.EXC(.
Follow syntax prompts to enter arguments more accurately.
Use cross-sheet references and nested formulas in broader calculations.
Get updated results automatically when referenced data changes.

System Requirements

Item	Requirement
Operating system	A Windows device that can run WPS Office normally
App version	Using the latest WPS Office version is recommended
Network	No mandatory network connection for local formula calculation; download, installation, and account services may require internet access
Other	You need access to WPS Spreadsheet and permission to edit formulas in cells

Download & Installation

Item	Details
Official download	WPS Office Free Download
Installation	Download and install WPS Office, then open WPS Spreadsheet to use formula features
Verification	Open WPS Spreadsheet and type `=PERCENTILE.EXC(` in a cell to confirm that the function prompt appears

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Provides the `PERCENTILE.EXC` function with syntax prompts, cross-sheet references, nested calculation support, and automatic recalculation when data changes.	Excel provides `PERCENTILE.EXC(array,k)` to return the k-th percentile of values in a range with 0 and 1 excluded.	Google Sheets provides `PERCENTILE.EXC(data, percentile)` for percentile calculation with 0 and 1 excluded.	Notion formulas support many properties, operators, and functions for calculations, but its official function reference does not describe a direct `PERCENTILE.EXC` spreadsheet function.	Adobe Acrobat focuses on PDF editing, conversion, and signing, and its official product page does not describe a spreadsheet percentile function.
WPS Advantages	Advantage: WPS supports direct spreadsheet-style function entry together with cross-sheet references and nested formulas for statistical analysis in one worksheet workflow.	Compared with WPS: Microsoft also provides a direct matching `PERCENTILE.EXC` function with similar syntax.	Compared with WPS: Google also provides a direct matching function and is suited to browser-based spreadsheet work.	Compared with WPS: Notion is centered more on database property formulas and page data handling than spreadsheet statistical functions.	Compared with WPS: Adobe is centered on PDF workflows rather than spreadsheet percentile calculation.
Official Source	—	PERCENTILE.EXC function	PERCENTILE.EXC function	Formula syntax & functions	Adobe Acrobat

Overall Conclusion: WPS PERCENTILE.EXC is a practical fit for users already working in WPS Spreadsheet on Windows. For direct percentile calculation, WPS, Excel, and Google Sheets all provide corresponding functions, while Notion and Adobe are oriented toward different product scenarios.

Use Cases

No.	Scenario	Suitable for	Main issue	How it helps
1	Score distribution analysis	Teachers and trainers	Need to identify the value at a target percentile quickly	Use PERCENTILE.EXC in a cell to calculate the target percentile value
2	Sales threshold setting	Operations and sales analysts	Need thresholds based on data distribution	Apply the function to a sales data range
3	Experimental data review	Researchers and analysts	Need to compare distribution positions across samples	Use cross-sheet references for multiple sample ranges
4	Combined formula modeling	Finance and business analysts	One function alone is not enough	Nest PERCENTILE.EXC inside broader formulas

Membership & Benefits

Free vs WPS Premium

Capability	Free	WPS Premium
PERCENTILE.EXC input and calculation	✅	✅
Basic spreadsheet editing	✅	✅
Cloud storage	1 GB	20 GB
Template downloads	Limited	More advanced templates and added benefits
PDF and advanced tools	Basic access	More advanced tools

Source: WPS Office pricing page

Recommendations

Scenario	Recommended plan	Why
Everyday formula work and basic spreadsheet analysis	Free	This function has no membership restriction in the feature information
More cloud storage, templates, or advanced tools	WPS Premium	Suitable when you also need broader document and productivity benefits

WPS membership page: Subscribe to WPS Premium