LARGE in WPS on Windows: Introduction

LARGE in WPS on Windows helps you return the nth largest value from a target data range in a formula field; 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

The LARGE function in WPS is used in multi-dimensional table formula fields to return the nth largest value from a selected data range. It is suitable for ranking analysis, score review, sales comparisons, and other scenarios where you need to pull a value by position rather than sort the entire dataset manually.

Core capabilities include:

Use the LARGE function in a formula field to return the nth largest value.
Fill in the target data range and rank parameter with the expected syntax.
Combine LARGE with other functions for more flexible calculations.

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	A network connection is not required for local formula editing and calculation, but it is needed for downloads and online help pages
Other	You need an editable multi-dimensional table and permission to add formula fields

Download & Installation

Item	Details
Official download	WPS Office Free Download
Post-install check	Open WPS Office, enter a multi-dimensional table, and confirm that you can add a Formula field and open the formula editor

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Supports the LARGE function in multi-dimensional table formula fields to return the nth largest value from a specified range and use it together with other formulas.	Excel provides `LARGE(array, k)` to return the k-th largest value in a dataset.	Google Sheets provides `LARGE(data, n)` to return the nth largest element in a dataset.	Notion formulas support database properties, math operations, and many functions, but its public help pages do not present a spreadsheet-style `LARGE` function for nth-largest ranking.	Acrobat supports calculated PDF form fields such as sums, products, averages, minimums, and maximums, but not a spreadsheet-style LARGE function.
WPS Advantages	Advantage: WPS lets you use LARGE directly in a multi-dimensional table formula field, which is convenient when the result needs to stay connected to table records.	Compared with WPS: Excel offers a directly comparable LARGE function, mainly in worksheet-based spreadsheet workflows.	Compared with WPS: Google Sheets also offers a directly comparable LARGE function for browser-based spreadsheet work.	Compared with WPS: Notion is more focused on database property formulas, so nth-largest ranking is less direct than a spreadsheet function workflow.	Compared with WPS: Adobe focuses on PDF form calculations rather than spreadsheet ranking analysis.
Official Source	—	Excel LARGE function	Google Sheets LARGE	Notion formula syntax	Acrobat form field calculations

Overall Conclusion
For nth-largest value analysis in table data, WPS, Excel, and Google Sheets all provide a direct LARGE function workflow. Notion and Adobe are better aligned with database-property logic or PDF form calculations, so WPS is the more straightforward fit when your work centers on spreadsheet-style ranking results.

Use Cases

No.	Scenario	Suitable For	Core Need	How LARGE Helps
1	Score ranking review	Teachers and trainers	Need to identify the 2nd, 3rd, or nth score quickly	Use LARGE in a formula field to return a score by rank
2	Sales data analysis	Sales and operations teams	Need to pull top values from a sales range	Use LARGE to return ranked values from the target range
3	Ongoing metric tracking	Data coordinators	Need to monitor higher-position values in changing data	Combine LARGE with other formulas so results update with the data

Membership & Benefits

Free vs WPS Premium

Capability	Free Users	WPS Premium
Core Writer, Spreadsheet, and Presentation apps	✅ Available	✅ Available
Basic use of formula features where LARGE is used	✅ Available	✅ Available
Some advanced PDF and extended tools	Limited by feature	More advanced tools available
Cloud storage	1 GB	20 GB shown on the pricing page

Source: WPS Office pricing page

Recommendations

Scenario	Recommended Plan	Why
Everyday calculations, learning, and basic ranking analysis	Free	Basic LARGE usage is available without membership and fits routine data work
Need more advanced tools, more cloud storage, or broader productivity features	WPS Premium	Better suited for users who need expanded tools and higher storage capacity

WPS membership page: Subscribe now