Google Sheets

SMALL: Google Sheets Formulae Explained

How do you use SMALL in Google Sheets?

There are a few ways to use SMALL in Google Sheets. One way is to use the function to return the smallest value in a range of cells. For example, if you have a list of numbers in column A, and you want to find the smallest number in the list, you can use the SMALL function to return that value. The function takes two arguments: the first argument is the row number of the first cell in the range, and the second argument is the column number of the first cell in the range. So, if you want to find the smallest number in the list in column A, you would use the following function:

=SMALL(A1:A10)

This function would return the smallest number in the list, which would be 3.

What is the syntax of SMALL in Google Sheets?

The syntax of SMALL in Google Sheets is to use the function's name followed by the number of items you want returned in parentheses. For example, the following formula would return the third smallest number in a list of numbers:

=SMALL(A1:A10)

What is an example of how to use SMALL in Google Sheets?

There are a few ways to use SMALL in Google Sheets. One way is to use the SMALL function. The SMALL function takes a list of numbers and returns the smallest number in the list. Another way to use SMALL is to use the filter function. The filter function takes a list of numbers and returns a list of the smallest numbers in the list. The third way to use SMALL is to use the sort function. The sort function takes a list of numbers and sorts them from smallest to largest.

When should you not use SMALL in Google Sheets?

There are a few instances in which you should not use SMALL in Google Sheets. One is when you want to create a range of numbers starting with a number other than 1. For example, the following formula would return the numbers 2, 3, 4, 5, and 6:

=SMALL(1:6)

If you want to start the range at 0 instead of 1, you would use the following formula:

=SMALL(0:6)

Another instance in which you should not use SMALL is when you want to find the largest or smallest number in a range of cells. For example, the following formula would return the number 5, which is the smallest number in the range A1:A5:

=SMALL(A1:A5)

What are some similar formulae to SMALL in Google Sheets?

There are a few formulae that are similar to SMALL in Google Sheets. They are: SMALL.INT, SMALL.NUM, and SMALL.STR. They all return a value that is smaller than the given argument.

Move beyond 

Google Sheets

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.