PERCENTOF in WPS on Windows: Introduction

PERCENTOF in WPS AirSheet is a formula for percentage-related calculations and analysis; 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 in AirSheet across supported versions

About This Feature

Overview

PERCENTOF is a formula function in WPS AirSheet for percentage-related calculations and analysis. When you enter the formula, WPS can display syntax guidance to help you complete parameters and return results more efficiently.

Core capabilities include:

Displaying syntax guidance when you type =PERCENTOF( so you can review parameter requirements and examples.
Supporting flexible parameters for different percentage calculation scenarios.
Supporting cross-worksheet references and nested formulas for more complex calculations.
Recalculating results automatically when referenced data changes.

This function is useful for data analysis, report preparation, ratio calculations, and cross-sheet statistics.

System Requirements

Item	Requirement
OS	A Windows device that can run WPS Office
App version	The latest version of WPS Office is recommended; AirSheet supports this function across supported versions
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 be able to open AirSheet and edit formulas in cells

Download & Installation

Before using PERCENTOF, install WPS Office and open AirSheet.

Item	Notes
Official Download	WPS Office Free Download
Post-install Check	Launch WPS Office, open AirSheet, and type `=PERCENTOF(` in a cell to check whether syntax guidance appears

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	In AirSheet, entering `=PERCENTOF(` supports percentage-related calculations with syntax guidance, cross-worksheet references, nested formulas, and automatic recalculation.	Microsoft Word supports formulas in table cells through the Formula command and can update results automatically when the document opens or when updated manually, but this workflow is designed for document tables rather than spreadsheet-style function entry.	Google Sheets lets you enter formulas and functions in cells, shows a function help box during editing, and supports nested functions and range selection.	Notion supports formula properties in databases, using properties, built-ins, and functions to calculate values across a property column.	Adobe Acrobat supports calculated form fields that update values dynamically based on other fields, mainly for PDF form workflows.
WPS Advantages	Advantage: Built for spreadsheet cell formulas in AirSheet, with syntax guidance, cross-sheet references, and automatic recalculation for everyday analysis tasks.	Compared with WPS: focuses on formulas inside Word tables rather than a spreadsheet formula workflow.	Compared with WPS: supports spreadsheet formulas and help prompts, but the official page describes general formula features rather than the specific PERCENTOF function.	Compared with WPS: better suited to database property formulas instead of traditional cell-based formula entry.	Compared with WPS: mainly targets PDF form calculations instead of spreadsheet function workflows.
Official Source	—	Use a formula in a Word table	Add formulas & functions	Formula syntax & functions	Configure form field calculations in Acrobat

Overall Conclusion
PERCENTOF is well suited to percentage-related calculations directly in WPS AirSheet, especially when you need syntax guidance, cross-sheet references, and nested formulas in one spreadsheet workflow. The other products also provide calculation features, but they are centered on document tables, database properties, or PDF forms rather than this spreadsheet-specific use case.

Use Cases

#	Scenario	Target Users	Core Pain Point	Solution
1	Sales ratio analysis	Sales teams, operations teams	Need to quickly calculate how one value compares with a total	Enter the PERCENTOF formula in a cell to complete the percentage calculation
2	Report verification	Finance teams, administrative staff	Manual ratio conversion is easy to get wrong	Use formula parameters and automatic recalculation to reduce repeated manual work
3	Cross-sheet statistics	Data analysts	Referencing data across worksheets can be cumbersome	Use cross-worksheet references inside the PERCENTOF formula
4	Complex formula combinations	Advanced spreadsheet users	A single formula may not cover the full logic	Nest PERCENTOF with other functions
5	Daily learning and practice	Students, trainers	Function syntax is not always familiar	Use syntax guidance to review parameter requirements and examples

Membership & Benefits

Free vs WPS Premium

Feature	Free User	WPS Premium
PERCENTOF function	Available	Available
Basic AirSheet formula editing	Available	Available
Advanced PDF tools	Basic features available	More advanced features available
Cloud storage	1 GB	20 GB
Template downloads	Limited	More template benefits

Source: WPS Office pricing page

Recommendations

Use Case	Recommended Plan	Reason
Everyday spreadsheet calculations and learning formulas	Free	PERCENTOF itself has no membership restriction and can be used directly
Need more cloud storage or broader advanced office features	WPS Premium	Suitable when you also need expanded benefits beyond basic spreadsheet work

WPS membership center: Subscribe now