Find the Smallest Value from a Range of Cells (Smallest Number)

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.
find-smallest-value
=SMALL(A2:A12,1)
formula-to-find-lowest-number

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 3rd smallest number you can use the 3 in the k argument in the function.

Download Sample File