Excel Tutorial – SMALL

The SMALL function in Microsoft Excel is a function that returns the nth smallest value from a range of cells or values. This function is useful for finding the smallest value in a range of cells, or for comparing multiple values to see which is the smallest.

To use the SMALL function, follow these steps:

1. Open Microsoft Excel and select the cell where you want the smallest value to appear.
2. Type the following formula into the cell: =SMALL(range, n)
3. Replace “range” with the range of cells that you want to find the smallest value in.
4. Replace “n” with the position of the smallest value that you want to find. For example, to find the smallest value in A1:A10, you would type: =SMALL(A1:A10, 1). To find the second smallest value, you would type: =SMALL(A1:A10, 2).
5. Press Enter to see the result.

You can also use the SMALL function to find the smallest value in a range of cells based on a specific criteria. To do this, you will need to use the SMALL function in combination with the IF function.

The SMALL function is a very useful tool for finding the smallest value in a range of cells or values. You can use it to analyze data, compare values, and make informed decisions based on the smallest value in a range.