# 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 MAX, 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`.