# Google Sheets MIN Function

## MIN Function

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

It is typed `=MIN` and gets a list of cells:

=MIN(value1, [value2, ...])

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.

Let's have a look at an example!

## Min Function Example

Find the lowest total stats in the range `C2:C21`:

1. Select the cell `G5`
2. Type `=MIN`
3. Click the MIN command

1. Specify a range `C2:C21` for the Total stats values
2. Hit enter

Now, the function returns the lowest value from the cells in the range:

Look at that! The function has successfully found the lowest value, `200`. Magikarp has the lowest Total stats of the Pokemons in this list.

Let's add text to a cell in the range `C2:C21` to see what happens. Type Kadabra into the cell `C21`:

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 `C2:C21`.