Search

MIN - MAX - AVERAGE

MIN is a formula that will give a lowest value in a specified range.


MAX is a formula that will give a highest value in a specified range.


AVERAGE is a formula that will give an average value in a specified range.


Example:


=MIN(A1:A5) will return 1.


=MAX(A1:A5) will return 5.


=AVERAGE(A1:A5) will return 3.

4 views