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:

- Open Microsoft Excel and select the cell where you want the smallest value to appear.
- Type the following formula into the cell: =SMALL(range, n)
- Replace “range” with the range of cells that you want to find the smallest value in.
- 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).
- 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.

## Leave a Reply

You must be logged in to post a comment.