PERCENTILE.INC in WPS on Windows: Introduction

PERCENTILE.INC in WPS on Windows is a spreadsheet function for returning the value at a specified percentile with inclusive 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.INC is a built-in statistical function in WPS Spreadsheet on Windows. It helps you return the value at a specified percentile for a dataset and is useful for score analysis, threshold setting, layered reporting, and percentile calculation in spreadsheets.

Core capabilities include:

Enter =PERCENTILE.INC( directly and view syntax prompts while editing.
Fill in the data range and percentile argument to return a result.
Use the function with cross-sheet references and nested formulas.
Recalculate results after source data changes in the worksheet.

Common use cases include exam score analysis, sales segmentation, sample distribution review, and business threshold setting.

System Requirements

Item	Requirement
Operating system	A Windows device that can run WPS Office
App version	The latest version of WPS Office is recommended for stable formula input and calculation
Network	No mandatory internet connection is required for local formula calculation; internet access is needed for download, installation, and account-related services
Other	An editable spreadsheet file and valid numeric input ranges are recommended

Source: System Requirements for WPS Office

Download & Installation

Item	Details
Official download	WPS Office Free Download
Installation	Download the Windows installer and complete setup with the installation wizard
Check after installation	Open WPS Spreadsheet, select a cell, and enter `=PERCENTILE.INC(` to confirm that the function prompt appears

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	WPS Spreadsheet lets you enter PERCENTILE.INC directly in a cell or formula bar and continue with calculation, cross-sheet references, and result updates in the same worksheet flow.	Excel officially supports `PERCENTILE.INC(array,k)` to return the k-th percentile of values in a range, with k from 0 to 1 inclusive.	Google Sheets officially supports `PERCENTILE.INC(data, percentile)` as a statistical function in spreadsheets.	Notion provides database formula syntax and functions, but its formula system is designed for database properties rather than a cell-based spreadsheet function named PERCENTILE.INC.	Adobe official content explains spreadsheet file types and PDF conversion workflows, but it does not provide a native spreadsheet formula environment for PERCENTILE.INC-style calculations.
WPS Advantages	Advantage: WPS keeps percentile work inside a desktop spreadsheet workflow on Windows, so you can enter the function, review references, and continue nested calculations in one place. Distinct: It fits users who want spreadsheet-style formula entry without switching to a database or PDF tool.	Compared with WPS: Excel offers a closely matched spreadsheet function workflow with similar syntax and statistical purpose.	Compared with WPS: Google Sheets also offers the same function name, but it is centered on a web-based spreadsheet environment.	Compared with WPS: Notion is better aligned with database property formulas than direct cell-based spreadsheet function entry.	Compared with WPS: Adobe focuses on document and PDF workflows rather than native spreadsheet formula calculation.
Official Source	—	Excel PERCENTILE.INC function	Google Sheets PERCENTILE.INC	Notion formula syntax	Adobe spreadsheet file formats

Overall Conclusion

For direct percentile calculation in a desktop spreadsheet, WPS, Excel, and Google Sheets are the closest comparisons. Notion is more suitable for database property formulas, while Adobe is more focused on file and PDF workflows. For users who want to enter and review spreadsheet formulas on Windows, WPS provides a straightforward path.

Use Cases

No.	Scenario	Suitable for	Main need	How PERCENTILE.INC helps
1	Score percentile analysis	Teachers and academic staff	Find the value at a target percentile quickly	Use PERCENTILE.INC to return the required percentile value
2	Sales segmentation	Sales analysts	Set thresholds based on performance distribution	Calculate 25th, 50th, or 90th percentile values
3	Sample data review	Researchers and data users	Avoid manual sorting and estimation	Reference a numeric range directly for calculation
4	Report-linked formulas	Finance and operations users	Keep results updated when source data changes	Add PERCENTILE.INC into existing worksheet formulas
5	Cross-sheet analysis	Advanced spreadsheet users	Reduce errors across multiple sheets	Use cross-sheet references in the percentile formula

Membership & Benefits

Free vs WPS Premium

Feature area	Free users	WPS Premium
Writer, Spreadsheet, and Presentation core apps	✅ Available	✅ Available
Basic spreadsheet functions such as PERCENTILE.INC	✅ Available	✅ Available
Some advanced PDF and extended services	May be limited by feature	✅ Broader access
Cloud storage and some value-added services	Basic allocation	Higher allocation and more added services

Source: WPS Office pricing page

Recommendations

Scenario	Recommended plan	Why
Everyday spreadsheet work and formula learning	Free	PERCENTILE.INC is a basic spreadsheet function scenario and is generally available without membership
Users who also need more PDF tools, cloud space, or added services	WPS Premium	Better suited for broader office needs beyond basic spreadsheet formulas

WPS membership page: Subscribe to WPS Premium