The MAX function is similar to the MIN function, except that it returns the maximum value in a range of cells. For example, if you had three cells with the values 2, 3, and 4, the MAX function will enter the number 4the maximum value in the three cells. To use the MAX function, follow these steps:
Google Spreadsheets now examines the selected cells and notes the one with the highest value; it places that highest value into the current cell. |