min

Previous chapterNext chapter Show allShow all    Hide allHide all

The function min (range) calculates the lowest value in a range.

Syntax: =min(range)

Example Example

Cells A1 to A10: any numbers

Cell B1 = min(A1:A10)

 

R / C

A

B

1

1

1

2

2

3

3

4

4

5

5

6

6

7

7

8

8

9

9

10

10