When using the SMALL function, common questions usually involve parameter errors, unexpected results, and batch fill behavior; this section includes 3 frequently asked questions.
FAQ
What should I do if the SMALL function shows a #VALUE! error?
- Check whether the input arguments contain text, extra spaces, or non-numeric content.
- Confirm that the referenced range is correct and that the argument order matches the SMALL syntax.
- Clean the source data if needed, then re-enter or edit the formula.
Why does the SMALL function return a result I did not expect?
- Check whether the referenced range covers the correct data area.
- Make sure the cells being calculated are stored as numbers instead of text-formatted numbers.
- Review whether the k value matches the rank you want, such as the 1st, 2nd, or 3rd smallest value.
How can I use the SMALL function in multiple cells at once?
- Enter and confirm the SMALL formula in the first target cell.
- Select that cell, then drag the fill handle across the target range, or copy and paste the formula.
- Check whether relative and absolute references behave as expected, and use $ when you need to lock a reference.
Glossary
| Term | Definition |
|---|---|
| SMALL | A statistical function that returns the k-th smallest value in a data set. |
| Parameter | An input used by a function, such as the data range or rank value. |
| Reference range | The cell range used by a formula for calculation. |