DMIN in WPS on Windows FAQ

Last updated:July 20, 2026

This FAQ covers 3 common questions and 3 glossary terms about formula entry, argument setup, and result checking for DMIN.

FAQ

What should I do if DMIN shows an error after I enter it?

  1. Check whether the formula starts with =.
  2. Confirm that the parentheses, separators, and argument order are complete.
  3. Review whether the database range, field, and criteria range are correct.
  4. If needed, re-enter DMIN( and complete the formula with the on-screen syntax guidance.

How can I check the argument description for DMIN?

  1. Select the target cell.
  2. Type =DMIN(.
  3. Review the syntax guidance shown in the editing area.
  4. Fill in the arguments as prompted and complete the formula.

Why is my DMIN result not correct?

  1. Check whether the field argument points to the column that should return the minimum value.
  2. Confirm that the criteria range headers match the database range headers.
  3. Check whether numeric cells are stored as text.
  4. After making changes, confirm whether the result updates.

Glossary

TermDefinition
DMINA database function that returns the minimum numeric value in a specified field for records that meet the criteria.
Database rangeThe cell range that contains headers and records used by DMIN for filtering and calculation.
Criteria rangeThe cell range used to define filter conditions, usually with headers that match the database range.