2.6 Smallest and largest

These are two weeks of daily sales. In E2, find the best day's sales. In E3, find the worst day's.

MAX(range) gives the largest number in a range and MIN(range) the smallest. They work like SUM: type =MAX(, then drag across the cells.

05 Smallest and largest MIN, MAX Starter

Click a cell while typing to insert it, drag to select a range, F4 adds $, Esc cancels.

Tap a cell while writing a formula to insert it, or slide across cells for a range. The strip above the keyboard has = ( ) : , $.