DMIN in WPS Spreadsheet is a built-in database function that returns the minimum value in a field that matches criteria; 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 DMIN function in WPS Spreadsheet returns the minimum value from a specified field in records that meet given criteria. It is useful when you work with a worksheet that includes field headers, a data range, and a criteria range.
Core tasks include:
- Insert DMIN from the Insert Function dialog.
- Type the
=DMIN(...)formula directly in a cell or in the formula bar. - Review syntax, parameters, and help details before confirming the formula.
Common use cases include sales records, inventory analysis, and conditional minimum-value checks. It helps reduce repeated manual filtering and makes it easier to confirm the correct parameter structure during spreadsheet work.
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 required internet connection for local formula entry and calculation; internet access is needed for online help or downloading WPS Office |
| Other | You need access to WPS Spreadsheet and a worksheet that includes field headers, a data range, and a criteria range |
Download & Installation
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Check after installation | Open WPS Office, launch Spreadsheet, and confirm that formula-related commands are available on the ribbon |
Source: WPS Download Center
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | WPS Spreadsheet provides the DMIN database function and supports both dialog-based insertion and direct formula entry in cells. | Microsoft Word supports formulas in table cells through the Formula command, including functions such as MIN, but the workflow is designed for document tables rather than spreadsheet cells. | Google Sheets supports formulas and functions in spreadsheet cells and shows a help box with function definitions and syntax while editing. | Notion formulas can calculate values by using database properties, built-ins, and functions inside database workflows. | Adobe Acrobat can configure calculated PDF form fields with predefined calculations such as sum, product, average, minimum, and maximum. |
| WPS Advantages | Advantage: WPS keeps the DMIN workflow inside a spreadsheet-style cell editing environment, with direct formula entry and an Insert Function path in the desktop app. | Compared with WPS: formula support is centered on Word table calculations, not a full spreadsheet function workflow. | Compared with WPS: it also supports spreadsheet formulas and syntax help; WPS fits a desktop Office-style spreadsheet workflow for users working in a local Windows client. | Compared with WPS: formulas are tied to database properties instead of cell-based spreadsheet formulas. | Compared with WPS: calculations are focused on PDF form fields rather than worksheet-based data analysis. |
| Official Source | — | Use a formula in a Word table | Add formulas & functions | Intro to formulas | Configure form field calculations in Acrobat |
Overall Conclusion
For conditional minimum-value analysis in a spreadsheet, DMIN in WPS matches a familiar worksheet formula workflow on Windows. Other products also provide calculation features, but they are aimed more at document tables, database properties, or PDF forms.
Use Cases
| No. | Scenario | Suitable for | Main challenge | How DMIN helps |
|---|---|---|---|---|
| 1 | Sales record minimum lookup | Sales teams, operations staff | Need the minimum sales value under a specific region or product condition | Use DMIN with a criteria range to return the minimum value from the target field |
| 2 | Inventory threshold review | Warehouse and purchasing teams | Need to find the lowest stock value that matches a condition | Build a criteria range and calculate the result with DMIN |
| 3 | Financial data checks | Finance and audit teams | Need to verify the minimum amount after filtering by category | Insert DMIN from the dialog or type the formula directly |
| 4 | Training and practice | Students and trainers | Need help understanding database function parameters | Use the function parameter dialog to review and fill in each argument |
| 5 | Reusable worksheet templates | Office users | Need to reuse the same conditional calculation in repeated templates | Copy the DMIN formula and adjust the references as needed |
Membership & Benefits
Free vs WPS Premium
| Capability | Free users | WPS Premium |
|---|---|---|
| DMIN formula entry and basic calculation | ✅ | ✅ |
| Basic PDF features | ✅ | ✅ |
| Cloud storage | 1 GB | 20 GB |
| Template downloads | Limited | More advanced templates and added benefits |
| Advanced PDF and some extended tools | Limited or subject to page details | More complete access |
Source: WPS Office pricing page
Recommendations
| Scenario | Recommended plan | Why |
|---|---|---|
| Learning spreadsheet functions and handling routine calculations | Free plan | DMIN formula entry and standard spreadsheet work are enough for many everyday tasks |
| Needing more cloud storage, templates, and broader office features | WPS Premium | Suitable for users who also need more document, PDF, template, and cross-scenario office capabilities |
How to Subscribe
- WPS membership center: Subscribe to WPS Premium
Source: WPS Office pricing page