How to Use the DMIN Function in WPS on Windows

This section includes 4 how-to topics, all available without membership; use the How-to Index to jump to the task you need and follow the entry path and steps.

How-to Index

How-to Guide

1. Enter the DMIN function

Entry path: Formula tab → formula bar

1. Open Spreadsheet and select the cell where you want the result to appear.
2. Type = in the formula bar or directly in the cell.
3. Continue by typing DMIN(.
4. Check the function prompt and get ready to enter the arguments.

Success Criteria

• Interface result: the cell enters formula editing mode and shows DMIN(.
• Next action available: you can continue entering the database, field, and criteria arguments.

Tips While Using

• Common mistake: if you do not start with =, the content may be treated as plain text.

2. Review syntax guidance and fill in arguments

Entry path: function prompt in the formula bar

1. After typing DMIN(, review the syntax guidance that appears.
2. Enter the database range in the prompted order.
3. Enter the field that should return the minimum value.
4. Specify the criteria range, close the parenthesis, and press Enter.

Success Criteria

• Interface result: the cell returns a calculated result instead of showing the formula as plain text.
• Next action available: you can select the cell again to review or edit the formula.

Tips While Using

• Common mistake: an incorrect argument order or an unclosed parenthesis can cause a formula error.

3. Use cross-sheet references

Entry path: formula bar → worksheet tabs

1. Keep the DMIN formula in editing mode while entering arguments.
2. Click the worksheet tab that contains the source data.
3. Select the target database range or criteria range.
4. Return to the result cell and confirm that the reference address has been inserted into the formula.

Success Criteria

• Interface result: the formula shows a reference that includes the worksheet name.
• Next action available: you can continue filling in the remaining arguments and complete the calculation.

Tips While Using

• Common mistake: selecting the wrong range after switching worksheets can make the reference inaccurate.

4. Refresh the calculation result

Entry path: edit the source data and return to the result cell

1. Change the original data in the database range or update the criteria range.
2. Press Enter or finish editing.
3. Check whether the result in the DMIN cell changes.
4. If needed, review the referenced ranges again.

Success Criteria

• Interface result: the result updates after the data changes.
• Next action available: you can copy the formula or adjust the criteria range further.

Tips While Using

• Common mistake: if numbers are stored as text, the result may not match your expectation.