The SMALL Function’s primary objective is to provide the range’s nth-lowest value.
Read on to learn more.
You just have to set thenargument to whichever value youd like to find.
Syntax of the SMALL Function
The SMALL function uses two arguments to complete its calculations.
Below is an example of the syntax structure for the SMALL function.
If you dont use the n argument, it will search for the smallest value in the range.
How to Use the SMALL Function in Google Sheets
Let’s look at a few practical illustrations.
Check out the below examples to better understand how to use the SMALL function in Google Sheets.
Simple SMALL Function
Consider the below data set.
Lets say we wanted to figure out the lowest value.
We employ the SMALL Function and the ROW Function to sort the data.
This function uses the ROW Function to define the n-value.
Check out ourGoogle Sheets IF Function Guideif you want to learn more about how this works.
Heres an example:
However, columns with no numeric data will return a #NUM!
error, like this:
This is because the SMALL function cant process non-numerical data.
Out-of-Range Error
SMALL will produce a #NUM!
Error when you input a numbern,bigger than the value of entries in the data range.
You’ll see we are looking for the 12th least number out of a possible set of just 10.
Therefore, SMALL gives #NUM!
The MIN function returns the lowest value among the given numbers and is entirely automated.
In this instance, we provide two numbers to the MIN function, and MIN returns the lower value.
However, the MIN function can only find the lowest value, not the nth lowest.
