ProductSolutionsTemplatesResources

MINA

Returns the minimum numeric value in a dataset. Learn more

Video field
Statistical

In Google Sheets, the MINA() function is used to find the minimum numerical value among the specified arguments.

It returns the smallest value from a range of numbers or a list of values.

The syntax for the MINA() function is as follows:

MINA(value1, [value2, …])

value1 is the first value or range of cells from which you want to find the minimum value.

value2 (optional) is the second value or range of cells. You can include additional values or ranges separated by commas.

Here's an example to demonstrate how the MINA() function works:

=MINA(A1:A5)

In this example, the MINA() function is used to find the minimum value in the range A1 to A5.

=MINA(10, 5, 7, 3, 9)

In this example, the MINA() function is used to find the minimum value among the given numbers (10, 5, 7, 3, and 9), and it will return the value 3.

Note that the MINA() function ignores any non-numeric values or treats them as 0 when calculating the minimum.

Visit Official Docs

Want even more from Google Sheets?


With Softr, you can turn your spreadsheets into powerful web apps.You can give advanced roles and permissions to each user, build advanced logic and automation flows, customize the design to your needs, and much more.


Softr also offers a growing library of templates for internal tools, client portals, community hubs, and more. The templates come with a Google Sheet or an Airtable base that you can use to store and manage your data easily.


Try Softr now and build your custom web apps in 10 minutes – no code required!