PERCENTRANK.EXC is a built-in statistical function in WPS Spreadsheet that returns the percentage rank of a value in a dataset on an exclusive 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 |
About This Feature
Overview
PERCENTRANK.EXC is a built-in function in WPS Spreadsheet for Windows. It calculates the relative percentage rank of a specified value within a dataset by using an exclusive range that does not include the 0 and 1 endpoints.
Core tasks include:
- Insert PERCENTRANK.EXC from the Insert Function dialog box.
- Type
=PERCENTRANK.EXC(...)directly in a cell or in the formula bar. - Review the function syntax, parameter details, and help entry before or during editing.
This function is useful for score analysis, sales ranking, and sample distribution comparison when you need to identify the relative position of a value in a numeric range.
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 required internet connection for local formula entry and calculation; internet access is needed for online help |
| Other | WPS Spreadsheet and a worksheet with numeric data |
Download & Installation
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Check after installation | Open WPS Spreadsheet, then confirm that the Formula tab and Insert Function entry are available |
Source: WPS Download Center
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | Provides the PERCENTRANK.EXC function in WPS Spreadsheet, with access through the Insert Function dialog box or direct formula entry, plus syntax and parameter guidance. | Excel provides PERCENTRANK.EXC(array,x,[significance]) and returns 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]) and returns the percentage rank of a value in a dataset from 0 to 1, exclusive. | Notion provides database formulas, operators, and functions for calculations in properties, but it does not present a spreadsheet-style PERCENTRANK.EXC function entry. | Adobe Acrobat focuses on PDF editing, conversion, signing, and AI-assisted document workflows rather than spreadsheet statistical functions such as PERCENTRANK.EXC. |
| WPS Advantages | Advantage: You can enter the function directly in worksheet cells or insert it from the function dialog box. Distinct: Syntax and parameter guidance are available in the same workflow for faster setup and checking. | Compared with WPS: Excel offers the same named function and detailed syntax guidance, so the function scope is similar. | Compared with WPS: Google Sheets also offers the same named function, but it is mainly used in a browser-based spreadsheet environment. | Compared with WPS: Notion formulas are centered on database properties rather than traditional worksheet cell formulas. | Compared with WPS: Acrobat is designed for PDF workflows, not spreadsheet-based statistical formula entry. |
| Official Source | — | PERCENTRANK.EXC function | PERCENTRANK.EXC | Formula syntax and functions | Adobe Acrobat |
Overall Conclusion
For percentage-rank calculations in spreadsheets, WPS, Microsoft Excel, and Google Sheets all provide a direct function path for this task. Notion is more suitable for database-property formulas, while Adobe Acrobat is centered on PDF work, so WPS remains a practical choice when you want a familiar spreadsheet workflow on Windows.
Use Cases
| No. | Scenario | Suitable for | Main challenge | How it helps |
|---|---|---|---|---|
| 1 | Score distribution analysis | Teachers and trainers | Need to identify where one score falls within a class dataset | Use PERCENTRANK.EXC to calculate the relative rank |
| 2 | Sales performance comparison | Sales and operations staff | Need to compare one sales value against a sample set | Enter PERCENTRANK.EXC in the data column |
| 3 | Sample statistics review | New data users | Need a quick way to find the relative percentile position of a value | Insert the function from the dialog box |
| 4 | Formula learning and troubleshooting | General office users | Need help understanding syntax and parameters | Review syntax and parameter details before editing |
| 5 | Repeated worksheet calculations | Finance and administrative staff | Need to reuse the same statistical formula across cells | Enter the formula once and fill it down |
Membership & Benefits
Free vs WPS Premium
| Capability | Free users | WPS Premium |
|---|---|---|
| Basic spreadsheet functions | ✅ | ✅ |
| Basic PDF features | ✅ | ✅ |
| Cloud storage | 1 GB | 20 GB and more plan-based benefits |
| Template downloads | Limited | More template benefits |
| Advanced PDF and some advanced tools | Limited or unavailable | Broader access |
Source: WPS Office pricing page
Recommendations
| Scenario | Recommended plan | Why |
|---|---|---|
| Everyday spreadsheet work and formula learning | Free | PERCENTRANK.EXC itself does not require membership |
| More cloud storage, templates, or broader document tools | WPS Premium | Better suited for users who also need expanded office features |
How to Subscribe
- WPS membership center: Subscribe now
Source: WPS Office pricing page