abc MICROSOFT EXCEL 2010 - Functions
The maximum value /MAX/

Function MAX finds and writes the largest value in a selected group of cells. Function MAX is a statistical function.


Picture 1. The maximum value /MAX/

The maximum value /MAX/, steps:

  1. Select the cell for printing the largest value.
  2. Click on the button Insert Function /INSERT FUNCTION/ .
  3. STATISTICAL Option in the dropdown menu.
  4. Select MAX function.
  5. OK button
  6. Define the area (group of cells).
  7. OK button
  8. The end (Kraj).

Functions    Index