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

- Written by Puneet

excelchamps-free-courses-puneet-gogia

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.

Get the Excel File

Last Updated: December 26, 2023