Excel MIN Function
The MIN function is a premade function in Excel, which finds the lowest number in a range.
It is typed
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
- Select a cell (
- Double click the MIN command
- Select a range (
- Hit enter
Let's have a look at an example!
Find the Pokemon which has the lowest total stats 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 the range
Let's add text to a cell in the range
D2:21 to see what happens. Type Kadabra to
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