Goal: Find the extremes in the dataset.
MIN: Lowest number. MAX: Highest number.
Ready...
💻 Formula Structure
=MAX(number1, [number2], ...)
- Logic: Returns the largest value.
- Ignores: Text and Empty cells.
=MIN(number1, [number2], ...)
- Logic: Returns the smallest value.
- Ignores: Text and Empty cells.
-- Select a function...
...
⚠️ Common Pitfalls
🚫 Zero is not Empty
MIN will count 0 as a value. If you have "0" for missing data, MIN might return 0 instead of the real lowest score.
🚫 Dates are Numbers
Since dates are numbers (e.g., 45000), MAX can find the latest date, and MIN can find the earliest date.