PERCENTRANK.INC in WPS on Windows: Introduction

PERCENTRANK.INC in WPS is a spreadsheet function for returning the percentage rank of a value within a dataset; 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 limits	None	Available across WPS Spreadsheet versions

About This Feature

Overview

PERCENTRANK.INC is a built-in statistical function in WPS Spreadsheet on Windows. It is used to calculate the percentage rank of a specified value within a dataset. You can enter the function directly in a cell, follow parameter prompts while editing the formula, use references across worksheets, and let the result update when source data changes.

Core capabilities include:

Use the PERCENTRANK.INC function directly for percentage-rank calculations.
Enter the data range, target value, and optional significance parameter with formula prompts.
Use cross-worksheet references and nested calculations for broader analysis.
Keep results updated automatically when source values change.

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
Other	You need an editable spreadsheet file and permission to edit cells

Download & Installation

Item	Details
Official download	WPS Office Free Download
Check after installation	Open WPS Spreadsheet, open any workbook, and type `=PERCENTRANK.INC(` in a cell to confirm that function prompts appear

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	WPS Spreadsheet provides the PERCENTRANK.INC function for direct formula entry, parameter prompts, cross-worksheet references, and recalculation after data changes.	Excel provides `PERCENTRANK.INC(array,x,[significance])` to return the rank of a value in a dataset as a percentage from 0 to 1, inclusive, and documents interpolation behavior.	Google Sheets provides `PERCENTRANK.INC(data, value, [significant_digits])` to return the percentage rank from 0 to 1, inclusive, for a value in a dataset.	Notion provides database formulas, property references, and many built-in functions, but its official formula reference does not present a ready-made spreadsheet-equivalent PERCENTRANK.INC function.	Acrobat supports calculated PDF form fields such as sum, product, average, minimum, and maximum, which fit form workflows rather than spreadsheet statistical functions.
WPS Advantages	Advantage: It fits cell-based spreadsheet work directly, including formula entry, parameter prompts, cross-sheet references, and automatic recalculation in one worksheet workflow.	Compared with WPS: Excel offers closely comparable function syntax and documented interpolation behavior for the same type of calculation.	Compared with WPS: Google Sheets also offers the same function name and similar syntax, with a stronger browser-based workflow.	Compared with WPS: Notion formulas are centered on database properties instead of spreadsheet cells, so this specific worksheet-style function workflow is not its main model.	Compared with WPS: Acrobat calculations are designed for PDF form fields, not for general spreadsheet analysis with worksheet formulas.
Official Source	—	PERCENTRANK.INC function	PERCENTRANK.INC	Formula syntax & functions	Configure form field calculations in Acrobat

Overall Conclusion

For percentage-rank calculations inside a spreadsheet, WPS, Microsoft Excel, and Google Sheets all provide closely related function support. If your work depends on cell formulas, cross-sheet references, and ongoing recalculation in a desktop spreadsheet workflow, WPS is a practical fit. Notion and Adobe official capabilities are aimed more at database formulas or PDF form calculations.

Use Cases

No.	Scenario	Suitable for	Main challenge	How it helps
1	Score ranking analysis	Teachers and trainers	You need to see where one score stands within a full set	Use PERCENTRANK.INC to calculate the percentage rank of a selected score
2	Sales comparison	Sales and operations teams	It is hard to judge the relative level of one sales result at a glance	Return a percentage rank to compare one record with the full dataset
3	Multi-sheet statistics	Finance and analysis users	Data is spread across worksheets and manual consolidation takes time	Use cross-worksheet references to complete one formula-based calculation
4	Dynamic report updates	Report maintainers	Results need to be recalculated after source data changes	Use automatic recalculation to keep results in sync

Membership & Benefits

These feature-related tasks include 4 items in total, with 4 available without membership and 0 membership-related items; subscription details help you review broader WPS service options.

Free vs WPS Premium

Capability	Free users	WPS Premium
PERCENTRANK.INC function	✅ Available	✅ Available
Basic spreadsheet editing	✅ Available	✅ Available
Advanced PDF tools	Some features are limited	Broader advanced capabilities are available
Cloud storage and template benefits	Basic quota and partial resources	More storage and broader resource access

Source: WPS Office pricing page

Recommendations

Usage scenario	Recommended plan	Why
Everyday spreadsheet formulas	Free	PERCENTRANK.INC itself has no membership restriction for regular statistical work
Broader PDF, template, or cloud needs	WPS Premium	Suitable for users who need expanded office capabilities on an ongoing basis

WPS membership center: Subscribe now