How to Use the MIN Function in WPS on Windows

Last updated:July 17, 2026

Use the MIN function through 4 how-to topics, all available without membership; choose a topic from the How-to Index and follow the entry path and steps to complete it.

How-to Index

No.TopicMembership Requirement
11. Enter the MIN functionFree
22. Fill in arguments with syntax promptsFree
33. Reference data across worksheetsFree
44. Use MIN in a nested formulaFree

How-to Guide

1. Enter the MIN function

Entry path: Formulas tab → Formula bar

  1. Open WPS Spreadsheet and select the cell where you want to show the result.
  2. Type = in the formula bar or directly in the cell.
  3. Type MIN(.
  4. Review the syntax prompt that appears and prepare to enter arguments.

Success Criteria

  • Interface result: The current cell enters formula editing mode and shows =MIN(.
  • What you can do next: You can continue entering numbers, cells, or ranges as arguments.

Tips While Using

  • Common mistake: If you do not start with =, the content may be treated as plain text.
  • Environment note: You need to work in an editable spreadsheet cell.

2. Fill in arguments with syntax prompts

Entry path: Formula bar

  1. After MIN(, enter the arguments that should be included in the calculation.
  2. Separate arguments with commas.
  3. Check that the parentheses are complete.
  4. Press Enter to confirm the formula.

Success Criteria

  • Interface result: The cell displays the calculated result.
  • What you can do next: When you select the cell again, you can review the full formula in the formula bar.

Tips While Using

  • Common mistake: Unmatched parentheses or incorrect separators can cause a formula error.
  • Environment note: Some versions may also support semicolons, but it is recommended to follow the current on-screen syntax prompt.

3. Reference data across worksheets

Entry path: Formula bar + worksheet tabs

  1. In the target cell, type =MIN(.
  2. Switch to another worksheet that contains the data you want to reference.
  3. Select the target cell or range to insert the reference.
  4. Complete the closing parenthesis and press Enter.

Success Criteria

  • Interface result: The formula includes a cross-worksheet reference.
  • What you can do next: After the referenced worksheet data changes, the result updates automatically.

Tips While Using

  • Common mistake: If the range is not selected correctly after switching worksheets, the reference may be incomplete.
  • Environment note: The referenced worksheet needs to be in the current file and accessible.

4. Use MIN in a nested formula

Entry path: Formula bar

  1. Decide the calculation goal of the outer formula first.
  2. Insert MIN(...) where the minimum-value calculation is needed.
  3. Enter the MIN arguments based on the syntax prompt.
  4. Check the full formula structure and press Enter.

Success Criteria

  • Interface result: The cell returns the final result of the nested formula.
  • What you can do next: You can continue editing either the outer formula or the MIN arguments.

Tips While Using

  • Common mistake: In multi-level formulas, it is easy to miss a parenthesis or separator.
  • Environment note: If the formula is long, editing in the formula bar makes the full content easier to review.