📊 Excel Basics #12 – MIN() & MAX() Functions

The "MIN()" and "MAX()" functions help you quickly find the smallest and largest values in a dataset. They are commonly used in reports, dashboards, and data analysis.

📌 What is the MIN() Function?
The "MIN()" function returns the smallest numeric value in a range.

Syntax:
=MIN(number1, [number2], ...)

Example:
A
45
82
19
67
Formula:
=MIN(A2:A5)

Result:
19

📌 What is the MAX() Function?
The "MAX()" function returns the largest numeric value in a range.

Syntax:
=MAX(number1, [number2], ...)

Using the same data:
Formula:
=MAX(A2:A5)

Result:
82

📌 Real-World Example
Employee | Sales
Rahul | 45000
Priya | 62000
Amit | 51000
Neha | 70000

Formula to find the highest sales:
=MAX(B2:B5)
Result: 70000

Formula to find the lowest sales:
=MIN(B2:B5)
Result: 45000

📌 Things to Remember
• Blank cells are ignored.
• Text values are ignored.
• Zero ("0") is treated as a valid number.

📌 Related Functions
• =LARGE(range, k) → Returns the k-th largest value.

Example: =LARGE(A2:A10,2) Returns the 2nd largest value.

• =SMALL(range, k) → Returns the k-th smallest value.

Example: =SMALL(A2:A10,3) Returns the 3rd smallest value.

📌 Common Mistakes
• Selecting the wrong range.
• Expecting text values to be included.
• Forgetting that zero is considered a number.

✅ Best Practices
• Use "MIN()" and "MAX()" to identify the lowest and highest values quickly.
• Combine them with Conditional Formatting to highlight extreme values.
• Use "LARGE()" and "SMALL()" when you need rankings instead of just the highest or lowest value.
• Always verify your data range before applying the functions.

The "MIN()" and "MAX()" functions are essential for finding key insights in any dataset.

Double Tap ❤️ For More