**Table of Content**Close

To find the smallest number in Excel, you can use Excel’s SMALL Function. This function allows you to refer to a range where you have numbers, and specify the n value (for example, if you want to get the smallest number, enter 1).

This tutorial will teach you to write a quick formula to get the smallest number.

## Formula to Find Lowest Number in Excel

You can use the following steps:

- First, enter the SMALL function in a cell.
- After that, refer to the range where you have numbers.
- Next, enter the n values to find the nth number.
- In the end, hit enter to get the result.

`=SMALL(A2:A12,1)`

In your list 104 is the smallest number and that’s exactly what you have got in the result. And if you somehow want to get the 3^{rd} smallest number you can use the 3 in the k argument in the function.