ExcelMIN Function
MIN Function
TheMIN 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 calledMAX, which finds the highest value in a range, the opposite ofMIN.
How to use the=MIN function:
- Select a cell (
G5) - Type
=MIN - Double click theMIN 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 rangeD2:D21:
Look at that! The function has successfully found the lowest value,200. Magikarp has the lowest Total stats of the Pokemons in the rangeD2:D21.
Let's add text to a cell in the rangeD2:21 to see what happens. Type Kadabra toD21.
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 rangeD2:D21.
