SMALL in WPS on Windows FAQ

Last updated:July 23, 2026

When using the SMALL function, common questions usually focus on formula entry, parameter setup, and result checking; this section includes 4 frequent questions and a glossary.

FAQ

What does the SMALL function do?

  1. SMALL returns the nth smallest value in a data range.
  2. The first argument is the data range, and the second argument is the rank number.
  3. For example, =SMALL(A2:A10,1) returns the smallest value in that range.

Why does SMALL not return a result after I type it?

  1. Check whether you entered the equal sign = before the function.
  2. Check whether the parentheses, comma, and argument order are complete.
  3. Press Enter and then confirm whether the cell shows a calculated result.

How should I write the second argument in SMALL?

  1. The second argument is the rank from smallest to largest.
  2. Enter 1 for the smallest value and 2 for the 2nd smallest value.
  3. If the rank is larger than the number of valid values, adjust the parameter.

How do I find the nth smallest value in WPS Spreadsheet?

  1. Select the result cell and enter =SMALL(data range, rank).
  2. For example, enter =SMALL(B2:B20,3).
  3. Press Enter to return the 3rd smallest value in that range.

Glossary

TermDefinition
SMALLA spreadsheet function that returns the nth smallest value in a selected range.
Data rangeA group of cells used in the calculation, such as A2:A10.
Rank parameterThe numeric argument that specifies which smallest value to return, such as 1, 2, or 3.
Formula editingThe process of entering a function, references, and arguments in a cell.