SMALL in WPS on Windows FAQ

When using SMALL, common questions usually involve syntax errors, unexpected results, cross-sheet references, and automatic recalculation; this FAQ includes 4 common questions and a glossary.

FAQ

What should I do if the SMALL function shows an error?

1. Check whether the formula starts with the equals sign =.
2. Check whether the parentheses are paired correctly and the arguments are separated correctly.
3. Confirm that all required arguments are present and that the rank value is valid.
4. Press Enter again after correcting the formula.

How can I view the parameter guidance for the SMALL function?

1. Select the target cell.
2. Type =SMALL(.
3. Review the syntax guidance that appears while editing the formula.
4. Fill in the data range and rank value as prompted.

Why is the SMALL result not correct?

1. Check whether the referenced range contains text-formatted numbers or abnormal values.
2. Confirm that the rank value does not exceed the number of data items.
3. Check whether the formula points to the correct worksheet and range.
4. If needed, update the data and confirm whether the result recalculates.

Does SMALL update automatically after data changes?

1. Change a value in the source data range.
2. Check whether the result cell changes at the same time.
3. If it does not update, confirm that the cell still contains a valid formula.
4. Check the workbook calculation status, then edit or confirm the formula again if needed.

Glossary