How to Use the MIN Function in WPS on Windows

This section includes 3 how-to topics for using the MIN function in WPS Spreadsheet on Windows, and all 3 are available without membership.

How-to Index

How-to Guide

1. Insert MIN from the Insert Function dialog

Entry: Formulas tab → Insert Function, or the fx button in the formula bar

1. Select the cell where you want to place the formula.
2. Click the fx button in the formula bar, or click Insert Function on the Formulas tab.
3. Search for MIN in the Insert Function dialog box.
4. Select the function and click OK.
5. Enter the required parameters in the Function Arguments dialog box.
6. Click OK to finish inserting the function.

Success Criteria

• Interface result: The target cell shows the MIN function result.
• What you can do next: You can continue editing parameters, copying the formula, or filling it down.

Tips While Using

• Common mistake: If you do not select the target cell first, the formula may be inserted in an unexpected location.
• Environment note: Open a worksheet in WPS Spreadsheet before starting.

2. Type the MIN formula directly in a cell

Entry: Cell or Formula Bar

1. Select the cell where you want to enter the formula.
2. Type =MIN(...) directly in the cell or in the formula bar.
3. Press Enter to confirm.
4. If you want to review parameter guidance, type =MIN( and press F1 to check the syntax prompt.

Success Criteria

• Interface result: The cell displays the smallest-value calculation result.
• What you can do next: You can drag the fill handle to copy the formula to other cells.

Tips While Using

• Common mistake: Incorrect parentheses, separators, or cell references can cause unexpected results.
• Environment note: Make sure the referenced range matches the data in the current worksheet.

3. Review MIN syntax and parameter details

Entry: Formulas tab → Insert Function

1. Click Insert Function on the Formulas tab.
2. Enter MIN in the search box.
3. Select the function to review the syntax MIN(...).
4. Click the help link for more details about the function.

Success Criteria

• Interface result: You can see the MIN function name, syntax, and parameter area.
• What you can do next: You can insert the function or return to the worksheet and type the formula manually.

Tips While Using

• Common mistake: Reviewing only the function name without checking the parameter range can affect later results.
• Environment note: Opening detailed help may require an internet connection.