**SMALL Formula in Excel**

If you are thinking about to learn what small formula is in excel, then this tutorial will help you in this.

### You must be wondering what does it actually do in excel, am I right?

Here is your answer; with the help of small formula, you can find the ‘**nth**’ smallest value from a range of value cells.

## The SMALL formula breakdown:

`=SMALL(array, k)`

In this formula, **array** means the range of values and **k** means the position of the smallest value.

Here I am explaining the process with step-by-step to find the nth smallest value from a range of values.

**Previously In Excel Formulas: ****How to use SEARCH Formula in Excel (3 SIMPLE STEPS)**

## STEP 1: First you need to enter the SMALL function in a blank cell

` =SMALL( `

## STEP 2: Now continue the formula with the SMALL argument

`array `

Select those ranges of cells that contain your values e.g.

`=SMALL(A2:A4,`

**k **

Write the nth smallest value you want to achieve in last e.g.

`=SMALL(A2:A4,2)`

Here is the result of 2nd smallest value;