PERCENTRANK.EXC in WPS on Windows: Introduction

PERCENTRANK.EXC in WPS is a spreadsheet function for returning the percentage rank of a value in a dataset with 0 and 1 excluded; 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

PERCENTRANK.EXC is a built-in spreadsheet function in WPS Office for Windows. It is used to return the relative standing of a value in a dataset as a percentage rank with the endpoints excluded.

Core capabilities include:

Displaying syntax guidance when you type PERCENTRANK.EXC(.
Letting you enter parameters directly in a worksheet cell and return a result.
Supporting cross-sheet references and nested formulas for combined calculations.
Recalculating results automatically when referenced data changes.

It is useful for score ranking, sales comparison, and sample distribution analysis. It helps you identify where a value stands in a dataset and reduces manual ranking work in spreadsheet analysis.

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, installation, and account-related actions
Other	You need to open WPS Spreadsheet and edit worksheet cells

Download & Installation

Before using PERCENTRANK.EXC, install the WPS Office desktop app for Windows and open WPS Spreadsheet.

Item	Details
Official download	WPS Office Free Download
Check after installation	Open WPS Office → open WPS Spreadsheet → select a cell and type `=PERCENTRANK.EXC(` to confirm that function guidance appears

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Provides the `PERCENTRANK.EXC` function in WPS Spreadsheet, with formula-bar entry, syntax guidance, cross-sheet references, nested calculation support, and automatic recalculation.	Excel provides `PERCENTRANK.EXC(array,x,[significance])` to return the rank of a value in a dataset as a percentage from 0 to 1 exclusive.	Google Sheets provides `PERCENTRANK.EXC(data, value, [significant_digits])` to return the percentage rank of a value in a dataset from 0 to 1 exclusive.	Notion provides database formulas based on properties, built-ins, and functions, but its official help content does not describe a spreadsheet-style `PERCENTRANK.EXC` function.	Adobe Acrobat supports calculated form fields that update values based on entered data, but this is a PDF form workflow rather than a spreadsheet function environment.
WPS Advantages	Advantage: You can calculate percentage rank directly in worksheet cells. Distinct: Syntax guidance and automatic recalculation fit everyday spreadsheet analysis workflows on Windows.	Compared with WPS: Excel also offers the same function name and similar syntax, making it suitable for users working in the Microsoft ecosystem.	Compared with WPS: Google Sheets also offers the same function and is well suited to browser-based collaboration, while WPS is closer to a desktop spreadsheet workflow.	Compared with WPS: Notion formulas focus on database properties rather than direct cell-based spreadsheet function entry.	Compared with WPS: Adobe calculation features are designed for PDF form fields, not standard spreadsheet statistical formulas.
Official Source	—	PERCENTRANK.EXC function	PERCENTRANK.EXC	Intro to formulas	Configure form field calculations in Acrobat

Overall Conclusion: If your main task is percentage-rank calculation in spreadsheets, WPS, Microsoft Excel, and Google Sheets all provide directly related function support. Notion and Adobe also support calculations, but their official workflows focus more on database properties and PDF forms than on spreadsheet function entry.

Use Cases

No.	Scenario	Suitable for	Main pain point	How it helps
1	Score ranking analysis	Teachers and trainers	You need to quickly identify where a score stands in a group	Use `PERCENTRANK.EXC` to calculate the percentage rank of a score in a sample set
2	Sales performance comparison	Sales and operations teams	It is hard to judge the relative level of one performance value	Return the relative standing of a sales value in a dataset
3	Sample distribution review	Data analysts	You need to compare one sample against the full distribution	Use the data range and target value to calculate rank
4	Combined formula analysis	Advanced spreadsheet users	A single function is not enough for the full analysis	Nest `PERCENTRANK.EXC` with other functions

Membership & Benefits

Free vs WPS Premium

Capability	Free users	WPS Premium
Basic spreadsheet function entry and calculation	✅	✅
Basic spreadsheet editing	✅	✅
Advanced PDF and some extended tools	Availability may be limited based on the product page	More advanced capabilities are listed on the product page
Cloud storage	1 GB	20 GB

Source: WPS Office pricing page

Recommendations

Scenario	Recommended plan	Why
Learning formulas and handling basic data analysis	Free	Basic use of PERCENTRANK.EXC does not require membership
Needing more extended tools and larger cloud storage	WPS Premium	Suitable for users who need more advanced tools, more storage, and broader office features over time

WPS membership page: Subscribe now