Excel MIN Function


MIN Function

The MIN function is a premade function in Excel, which finds the lowest number in a range.

It is typed =MIN

The function ignores cells with text. It will only work for cells with numbers.

Note: There is another function called , which finds the highest value in a range, the opposite of MIN.

How to use the =MIN function:

  1. Select a cell (G5)
  2. Type =MIN
  3. Double click the MIN command
  4. Select a range (D2:D21)
  5. Hit enter

Let's have a look at an example!

Find the Pokemon which has the lowest total stats in the range D2:D21:


Look at that! The function has successfully found the lowest value, 200. Magikarp has the lowest Total stats of the Pokemons in the range D2:D21.

Let's add text to a cell in the range D2:21 to see what happens. Type Kadabra to D21.

Right on! The function ignores the text typed in the range. 253 is returned as the new lowest value, as the old one was replaced with text. Rattata is now the Pokemon with the lowest Total stats in the range D2:D21.



Login
ADS CODE