Min and Max functions in Excel are used to finding the smallest (or biggest) number in a list.
For that, you can use functions in Excel, Min (for smallest – minimum) and Max (for largest – maximum)
These functions just can take one input, the range of cells that you are looking at where you want to find what the smallest or biggest number is, or they can take input from lots of different places or cells, up to 255! You need to give the formula at least 1 input. Notice the square brackets in the formula below, this means that input is optional.
=MIN(number1, [number2], …)
=MIN(5,10,15) is valid (but a bit boring!). =MIN(A1, C5, D6) is also valid and will return whichever is the lowest of the numbers in those cells.
More common would be =MIN(A1:A50) This looks for the smallest number in all the cells from A1 to A50. The colon in Excel means include all the cells between the start one and the end one.
You can also then add different ranges, or values. For example, =MIN(A1:A50, 10) will find the lowest of the values in A1 through to A50, but if this lowest is more than 10, then it will return 10. This is useful if you want to cap the value that is being returned.
The Max function works with the same inputs, but will return the biggest of the values.