## 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,`

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

`=SMALL(A2:A4,2)` For example I have chosen to find 2nd Smallest Value to show you.

Here is the result of 2nd smallest value;