PERCENTRANK.INC in WPS on Windows: Introduction

PERCENTRANK.INC in WPS is a spreadsheet function for returning the relative standing of a value within a data set on an inclusive 0-to-1 scale; this guide covers 3 core tasks, with 3 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	3	Matches the number of rows in the How-to Index
Available without membership	3	Matches the number of Free rows in the index
Membership-related items	0	Matches the number of membership-related rows in the index
Recommended version	Latest WPS Office for Windows	Helps provide stable formula editing and function prompts

About This Feature

Overview

PERCENTRANK.INC is a built-in statistical function in WPS Spreadsheet on Windows. It is used to return the percentage rank of a value within a numeric data set, including the 0 and 1 endpoints.

Core capabilities include:

Enter the function name and start a calculation quickly.
Fill in the required range, target value, and optional significance argument.
Use cross-sheet references, nested formulas, and automatic recalculation after data changes.

Common use cases include score analysis, sales distribution review, and relative position checks in sample data.

System Requirements

Item	Requirement
Operating system	A Windows device that can run WPS Office normally
App version	The latest version of WPS Office is recommended
Network	No mandatory internet connection is required for local formula calculation; internet access is needed for download, installation, and account-related services
Other	You need permission to open and edit spreadsheet files and enter formulas in cells

Download & Installation

Item	Details
Official download	WPS Office Free Download
Installation notes	Download and install WPS Office for Windows, then open WPS Spreadsheet to use formula features
Check after installation	Launch WPS Spreadsheet, select a cell, and type `=PERCENTRANK.INC(` to confirm that the formula editor and argument prompt are available

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	In WPS Spreadsheet, you can enter PERCENTRANK.INC to calculate percentage rank with function prompts, cross-sheet references, nested formulas, and automatic recalculation.	Excel provides the PERCENTRANK.INC function and documents the syntax as `PERCENTRANK.INC(array,x,[significance])` for returning the rank of a value in a data set as a percentage.	Google Sheets supports formulas and functions in cells, with a function help box that shows a definition, syntax, and examples during editing.	Notion formulas support operators, conditions, and functions for database properties, but they are not designed as traditional spreadsheet cell functions.	Acrobat supports calculated PDF form fields with predefined calculations, simplified field notation, and custom JavaScript for form logic.
WPS Advantages	Advantage: Built for spreadsheet cell calculations directly; Distinct: function prompts, cross-sheet references, and automatic recalculation fit statistical worksheet analysis well.	Compared with WPS: Excel also offers a directly corresponding function and standard spreadsheet syntax for the same type of analysis.	Compared with WPS: Google emphasizes general formula entry and in-editor help guidance; the cited page explains formula workflows rather than a dedicated PERCENTRANK.INC article.	Compared with WPS: Notion formulas are centered on database property logic instead of worksheet cell-based statistical functions.	Compared with WPS: Adobe calculation features are focused on PDF form fields rather than spreadsheet-based statistical analysis.
Official Source	—	PERCENTRANK.INC function	Add formulas and functions	Formula syntax and functions	PDF form fields and calculated values

Overall Conclusion

For spreadsheet-based statistical calculations, WPS and Microsoft both provide a direct function workflow. Google Sheets is strong for general online formula editing, while Notion and Adobe focus more on database logic or PDF form calculations, so their usage model differs from WPS for cell-based analysis.

Use Cases

No.	Scenario	Suitable for	Main challenge	How it helps
1	Score ranking analysis	Teachers and trainers	You need to judge where one score falls within a larger sample	Use PERCENTRANK.INC to calculate the percentage rank of a score in a score range
2	Sales distribution review	Sales analysts	You need to compare one sales value with the full data set quickly	Enter the function in a data sheet and reference the target value
3	Sample position evaluation	Research and operations teams	You need to compare one sample against the overall group	Combine cross-sheet references and nested formulas for analysis
4	Auto-updating reports	Finance and administrative staff	Manual recalculation is inefficient after source data changes	Use automatic recalculation to keep results updated
5	Multi-sheet summaries	Advanced spreadsheet users	Referencing data across sheets can be error-prone	Use cross-sheet references to calculate percentage rank consistently

Membership & Benefits

Membership information for this feature focuses on whether PERCENTRANK.INC itself requires payment and what broader WPS benefits may differ between free and paid plans.

Free vs WPS Premium

Feature	Free	WPS Premium
PERCENTRANK.INC entry and basic calculation	✅	✅
Core office features	✅	✅
Advanced PDF tools, more templates, and extended benefits	Limited in some areas	More benefits available depending on plan
Cloud storage	1 GB	20 GB or more depending on the plan page

Source: WPS Office pricing page

Recommendations

Scenario	Recommended plan	Why
Everyday spreadsheet work and learning functions	Free	It already supports entering, editing, and calculating with PERCENTRANK.INC
More cloud storage or broader office benefits	WPS Premium	Useful if you also need expanded tools, templates, or cross-scenario office features

Membership page: Subscribe to WPS Premium