Using the MAX Function


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:

1.

Select the cell where you want the result to appear.

2.

Click the Max link; this inserts =Max( into the selected cell.

3.

Use your keyboard or mouse to select the range of cells.

4.

Use your keyboard to enter the ) character to close the function argument.

5.

Press the Enter key.

Google Spreadsheets now examines the selected cells and notes the one with the highest value; it places that highest value into the current cell.




Using Google Spreadsheets
Using Google Spreadsheets
ISBN: B000P28WL2
EAN: N/A
Year: 2007
Pages: 78

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net