SheetFX
≡
<< Go back to all functions

MINA

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

Function Syntax and Parameters

Syntax: MINA(value1, value2)

Parameters:

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

Step-by-Step Tutorial

  1. Using MINA with individual numbers:

    • Example: =MINA(3, 10)
    • Result: 3

  2. Using MINA with a range of cells:

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

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.
  • MIN: Find the smallest value in a set.

Related Articles