MIN

The MIN function in Google Sheets is a powerful tool to extract the smallest value from a given set of numbers. Whether you're comparing sales data, student grades, or tracking daily expenses, the MIN function simplifies the task. Dive into our comprehensive guide to master its application.

Parameters

• value1: The first value or range to consider for the minimum.
• value2, ...: [Optional] Additional numbers or ranges to consider.

Step-by-Step Tutorial

1. Using MIN with individual numbers:

   • Example: =MIN(3, 10, 5)
   • Result: 3

2. Using MIN with a range of cells:

   • Example: If A1:A5 has the values 5, 10, 3, 8, 7, then =MIN(A1:A5) will return 3.

Working with a Single Value, a List, and a Range

MIN accepts numbers one at a time, as a comma-separated list, or as a range — mix and match freely.

• Single value: =MIN(A1) — just returns the value in A1.
• List of values: =MIN(A1, A2, A3) — compares each cell individually and returns the smallest.
• Range: =MIN(A1:A10) — scans every cell in the range for the smallest value.
• Mixed: =MIN(A1, A3:A6, 10) — you can combine single cells, ranges, and literal numbers in one call.

Video Example

Use Cases and Scenarios

1. Budget Tracking: Find the lowest expense in a month.
2. Sales Analysis: Identify the product with the lowest sales figure.
3. Sports Statistics: Determine the lowest score in a golf tournament.

Related Functions

• MAX: Find the largest value in a set.
• MINA: Like MIN, but it evaluates text and other data types as well.

Related Articles

• Top 4 Basic Arithmetic Functions Every Google Sheets User Should Know
• 10 Essential Google Sheets Formulas Every User Should Know