I. Intro
The SMALL function returns the nth smallest value in the specified range, with n defined by the user.
II. About the function
- Formula: =SMALL(data,n)
- Parameters:
- data (required): The array or range used to find the nth minimum value.
- n (required): The position of the data to be returned in the array or range (from smallest to largest). For example: n = 1 returns the smallest value.
- Example: =SMALL(A2:B100,4)
III. Steps
Use the SMALL function
- Select a cell and click Formulas on the toolbar, then select Statistical > SMALL. You can also directly enter =SMALL in a cell.
- Enter the parameters in the cell. For example: =SMALL(C2:C12,1).
- Press Enter to get the result, which is 20 in this example.
250px|700px|reset
Delete the SMALL function
Select the cell with the SMALL function and press Delete.
IV. Use cases
Teachers: Find the lowest scores
- Formulas used below:
- =SMALL(E2:E6,1)
- =SMALL(E2:E6,2)
- About the parameters: The two formulas return the smallest value (n = 1) and the second smallest value (n = 2) in the "total score" (E2:E6) range.
250px|700px|reset