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:
- Select a cell (
G5
) - Type
=MIN
- Double click the MIN command
- Select a range (
D2:D21
) - 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
.