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