Max & Min Formula

1. MAX 

The MAX functions help in finding the maximum number in a range of values.

Example:

=MAX(number1, [number2], …)

=MAX(C2:C11)

2. MAXA

3. MIN

The MIN functions help in finding the minimum  number in a range of values.

Example:

=MIN(number1, [number2], …)

=MIN(C2:C11)