How to Use the MINIFS Function in WPS on Windows

Last updated:July 23, 2026

Use MINIFS 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 use MINIFSFree
22. Review the parameter formatFree
33. Use an example to calculate a conditional minimumFree

How-to Guide

1. Create a formula field and use MINIFS

Entry path: Add Field → Formula → Formula Editor

  1. Open the multidimensional spreadsheet you want to edit.
  2. Click Add Field on the toolbar.
  3. Select the Formula field type.
  4. Enter a formula that includes MINIFS in the formula editor.
  5. Click Confirm and check whether the result appears in the formula field.

Success Criteria

  • Interface result: A new formula field appears in the table and shows a calculated result.
  • Next action available: You can continue editing the formula parameters or add more fields.

Tips While Using

  • Common mistake: If you do not choose the Formula field type first, you may not be able to enter the function formula.
  • Environment note: You need edit permission for the current multidimensional spreadsheet.

2. Review the parameter format

Entry path: Formula Editor → Function Library → MINIFS

  1. Open the formula editor in your multidimensional spreadsheet.
  2. Go to the function library and select MINIFS.
  3. Review the parameter format for the function.
  4. Fill in the target range and criteria as needed.

Parameter format example:

MINIFS(
  [parameter1],
  [parameter2],
  ...
)

Success Criteria

  • Interface result: You can view the parameter structure for MINIFS.
  • Next action available: You can complete the formula and continue calculating.

Tips While Using

  • Common mistake: If the parameter order is incomplete, the result may not return as expected.
  • Environment note: The field content should match the calculation target.

3. Use an example to calculate a conditional minimum

Entry path: Formula Field → Enter an example formula

  1. Create or select a formula field.
  2. Enter an example formula such as =MINIFS(target_range).
  3. Replace the target range and criteria with your actual data.
  4. Save the formula and check whether the result refreshes when the data changes.

Success Criteria

  • Interface result: The formula field returns a minimum value.
  • Next action available: When source data changes, the result updates with it.

Tips While Using

  • Common mistake: If the referenced range or criteria does not match the data, the result may be incorrect.
  • Environment note: Test with a small dataset before applying the formula to a full table.