Formula MIN is used to search the least value. Example of formula is =MIN(RANGE X:RANGE Y)
Example 1 : To find the minimum value of a row or column.
In selected destination cell, type =MIN(RANGE X:RANGE Y). In this example, the formula would be =MIN(B2:B7).
Hit the enter button to get the minimum result.
Example 2 : To find minimum value of multiple rows or columns.
In selected destination cell, type =MIN(RANGE X:RANGE Y). In this example, the formula would be =MIN(B2:D7).
Hit the enter button to get the minimum result.
