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.

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

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