MINA in WPS on Windows: Introduction

MINA in WPS is a spreadsheet function for calculations and analysis in worksheet cells; 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

MINA is a built-in function in WPS Spreadsheets on Windows. It is used to return the smallest value from numbers, logical values, and text values that can be interpreted in a calculation range, helping with routine spreadsheet calculation and analysis.

Core capabilities include:

Enter the =MINA( function directly in a cell to calculate results.
Use syntax prompts while typing to reduce input mistakes.
Work with cross-sheet references and nested formulas for combined calculations.
Recalculate results automatically when referenced data changes.

Common use cases include score review, business records, and cross-sheet data analysis. It helps reduce manual calculation and improves formula entry efficiency in spreadsheet workflows.

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; internet access is needed for download, installation, and account-related services
Other	You need an editable spreadsheet file and permission to edit cells

Download & Installation

Before using MINA, install WPS Office on Windows and open WPS Spreadsheets.

Item	Details
Official download	WPS Office Free Download
Check after installation	Launch WPS Office, open a spreadsheet, select any cell, and type `=MINA(` to confirm that the function prompt appears

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	MINA can be entered directly in spreadsheet cells and supports syntax prompts, cross-sheet references, nested formulas, and automatic recalculation.	Microsoft Word supports formulas such as MIN and SUM inside document tables, but the workflow is centered on table fields in documents rather than full spreadsheet analysis.	The official Google Docs page highlights Gemini features for drafting, summarizing, and answering questions in documents, and does not describe a spreadsheet function workflow equivalent to MINA on that page.	Notion formulas support properties, operators, and many functions in databases, but calculations are applied through database properties instead of traditional worksheet cells.	Adobe Acrobat supports calculated PDF form fields such as product and sum, which fits form workflows rather than spreadsheet formula editing.
WPS Advantages	Advantage: direct cell-based formula entry in a spreadsheet grid; Distinct: better aligned with cross-sheet analysis and everyday worksheet calculations.	Compared with WPS: Word formulas are more suitable for basic calculations inside document tables, with a narrower formula-editing workflow for spreadsheet-style analysis.	Compared with WPS: this official page focuses on AI writing assistance in documents rather than worksheet function entry and recalculation.	Compared with WPS: Notion is more database-property oriented, while WPS fits traditional spreadsheet formula entry and cell-level analysis more directly.	Compared with WPS: Acrobat calculations are oriented to PDF form fields, while WPS is more suitable for routine data-table calculations.
Official Source	—	Use a formula in a Word table	Gemini in Google Docs	Formula syntax and functions	Configure form field calculations in Acrobat

Overall Conclusion: If your work centers on entering formulas in worksheet cells, using cross-sheet references, and recalculating results as data changes, WPS follows a more direct spreadsheet workflow. The other products also provide calculation-related features, but their official pages here focus more on document tables, database properties, or PDF form fields.

Use Cases

No.	Scenario	Suitable Users	Core Need	How MINA Helps
1	Lowest score review	Teachers and trainers	Find the smallest value in a score range quickly	Enter MINA in a result cell and reference the score range
2	Sales record analysis	Sales and operations staff	Identify the lowest value across multiple records	Use MINA to calculate the lower bound of sales or inventory values
3	Cross-sheet data review	Finance and analysts	Work with data stored across multiple worksheets	Use cross-sheet references inside MINA
4	Combined formula analysis	Advanced spreadsheet users	Build more complex calculations than a single function can provide	Nest MINA inside a larger formula
5	Ongoing data checks	Everyday office users	Recheck results after source data changes	Rely on automatic recalculation to keep results current

Membership & Benefits

Free vs WPS Premium

Capability	Free	WPS Premium
MINA function	✅ Available	✅ Available
Basic spreadsheet editing	✅ Available	✅ Available
Some advanced value-added features	Available within the scope shown on the pricing page	Includes more advanced features and extended benefits
Cloud storage	1 GB	20 GB

Source: WPS Office pricing page

Recommendations

Scenario	Recommended Plan	Why
Routine formula entry and basic statistics	Free	The MINA function itself is available without membership and fits regular spreadsheet work
More cloud storage or broader office features	WPS Premium	Suitable if you also need more extended features, templates, or value-added services

Membership page: Subscribe to WPS Premium