How to Use the SMALL Function in WPS on Windows

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

How-to Index

How-to Guide

1. Enter SMALL from the Insert Function dialog box

Entry path: Formulas tab → Insert Function, or the fx button on the formula bar.

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

Success Criteria

• Interface result: The target cell contains a SMALL function.
• Next actions: You can continue editing parameters, copying the formula, or filling it down.

Tips While Using

• Common mistake: A misspelled function name can make SMALL harder to find in search.
• Environment note: If the file is not open in the spreadsheet editing view, the Formulas tab may not be visible.

2. Type a SMALL formula directly in a cell

Entry path: The target cell or the formula bar.

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

Success Criteria

• Interface result: The cell shows a calculated result, and the formula bar keeps the SMALL formula.
• Next actions: You can change the referenced range, adjust the k value, or copy the formula to other cells.

Tips While Using

• Common mistake: Incomplete separators or parentheses can cause a formula error.
• Environment note: If the referenced range contains unexpected content, the result may differ from what you expect.

3. Check SMALL syntax and parameter details

Entry path: Formulas tab → Insert Function.

1. Click Insert Function on the Formulas tab.
2. Type SMALL in the search box.
3. Select the function to review its syntax and parameter details.
4. Open the related help entry for more guidance on how to fill in the arguments.

Success Criteria

• Interface result: You can see the SMALL function name, syntax structure, and parameter description.
• Next actions: You can return to the worksheet and continue entering or editing the formula.

Tips While Using

• Common mistake: Checking only the function name without confirming parameter order can lead to incorrect results.
• Environment note: The way help content is displayed can vary with the current interface layout.