Functions
Function MAX - Example

Returns the laregest values in a set of values. Ignores logical values and text.

 

A

1

11

2

22

3

33

4

text

5

 

 

Cells

Function

Resultat

A1, A2, A3, A4, A5

=MAX(A1:A5)

33

A1, A2, A3, A4, A5 and 100

=MAX(A1:A5, 100)

100

A1, A3

=MAX(A1, A3)

33

A1, A5

=MAX(A1, A5)

11

 

Function MAX - Example, steps:

  1. Select the cell for result.
  2. Click the INSERT FUNCTION button .
  3. Select a function MAX.
  4. Select the cell(s) - range for calculation;
  5. OK button.
  6. The end (Kraj).

Functions    Index