
The MIN and MAX functions identify the smallest and largest values in a range of cells. These functions are useful when analyzing datasets that contain many numbers and you need to locate extremes quickly.
For example, =MIN(C1:C20) returns the lowest value while =MAX(C1:C20) returns the highest. They are commonly used in performance tracking, sales reporting, and operational dashboards.
Reference:
TaskLoco™ — The Sticky Note GOAT