How to Use the MIN Function in WPS on Windows

Last updated:July 23, 2026

Use the MIN function in WPS with 3 how-to topics, all available without membership; choose a topic from the index and follow the entry path and steps.

How-to Index

No.TopicMembership Requirement
11. Create a formula field and call MINFree
22. Check the argument format and enter the formulaFree
33. Use a MIN formula and review the resultFree

How-to Guide

1. Create a formula field and call MIN

Entry path: Add Field → Formula

  1. Click Add Field.
  2. Select Formula as the field type.
  3. Enter a formula that includes MIN in the formula editor.
  4. Click Confirm to save the setting.

Success Criteria

  • On-screen result: a new formula field appears in the table.
  • Next action available: you can continue editing the formula and review the calculated result.

Tips While Using

  • Common mistake: choosing the wrong field type prevents formula entry.
  • Environment note: you need edit permission for the current multidimensional table.

2. Check the argument format and enter the formula

Entry path: Formula Editor → Function Library → MIN

  1. Open the function library in the formula editor.
  2. Select MIN to review its format.
  3. Enter the arguments in this structure:
MIN(
  [argument1],
  [argument2],
  ...
)
  1. Enter the target range or other arguments as needed.

Success Criteria

  • On-screen result: the full MIN formula appears in the editor.
  • Next action available: you can save the formula and run the calculation.

Tips While Using

  • Common mistake: incorrect separators or parentheses can cause a formula error.
  • Environment note: the arguments should match a numeric calculation scenario.

3. Use a MIN formula and review the result

Entry path: Formula Field → Enter Formula and Save

  1. Enter a sample formula such as =MIN(target range) in the formula field.
  2. Click Confirm or Save.
  3. Review the smallest value returned in the formula field.
  4. Update the source data and check whether the result refreshes automatically.

Success Criteria

  • On-screen result: the formula field displays the minimum value.
  • Next action available: when source data changes, the result updates accordingly.

Tips While Using

  • Common mistake: referencing non-numeric content can lead to unexpected results.
  • Environment note: if the data is not imported correctly, the result may not display as expected.