SheetFX
≡
<< Go back to all functions

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.

Function Syntax and Parameters

Syntax: MIN(value1, [value2, ...])

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.

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