Formulas > =SMALL()

How To Use SMALL() Function in Google Sheets


Returns the nth smallest element from a data set, where n is user-defined.

Common questions about the SMALL formula:
What is the syntax of the SMALL formula? How do you select the smallest value from a range of cells?

How can the SMALL formula be used appropriately?
The SMALL formula can be used to select the smallest numeric value from a list of values in a range of cells.

How can the SMALL Formula be commonly mistyped?
The SMALL formula can be miscoded or misused with the wrong input values, referencing the wrong range of cells, or forgetting to enclose certain arguments in parentheses.

What are some common ways the SMALL formula is used inappropriately?
The SMALL formula cannot be used to calculate the smallest text value; instead, the MIN function can be used for this purpose. Additionally, the formula should not be used to select text values from a list.

What are some common pitfalls when using the SMALL formula?
The SMALL formula can only be used to calculate the smallest numeric value in a list. Text values or empty cells should be avoided as inputs to the SMALL formula. Additionally, the values should be organized numerically or there can be unexpected results.

What are common mistakes when using the SMALL Formula?
Common mistakes when using the SMALL function include misusing cell range references, forgetting to enclose arguments in parentheses, and misusing parameters.

What are common misconceptions people might have with the SMALL Formula?
Some common misconceptions with the SMALL formula may include believing that it can be used for selecting text values or forgetting that the values need to be arranged numerically.

How To Actually Use SMALL() in Sheets

SMALL(data, n)

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at

Learn more about the SMALL() formula:

Generate a SMALL() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members. Free to try for non-members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.