max

Previous chapterNext chapter Show allShow all    Hide allHide all

The function max (range) calculates the highest value in a range.

Syntax: =max(range)

Example Example

Cells A1 to A10: any numbers

Cell B1 = max(A1:A10)

R / C

A

B

1

1

10

2

2

3

3

4

4

5

5

6

6

7

7

8

8

9

9

10

10