Find the Smallest Value from a Range (Smallest Number) in Excel (Formula)

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:

1. First, enter the SMALL function in a cell.
2. After that, refer to the range where you have numbers.
3. Next, enter the n values to find the nth number.
4. 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.