Excel MINA Function

This post will guide you how to use Excel MINA function with syntax and examples in Microsoft excel.

Description

The Excel MINA function returns the smallest numeric value from the numbers that you provided, while counting text and the logical values (The TRUE value is treated as value 1 and the FALSE value is treated as value 0).

The MIN function is a build-in function in Microsoft Excel and it is categorized as a Statistical Function.

The MIN function is available in Excel 2016, excel 2013, excel 2010, excel 2007, excel 2003, excel XP, excel 2000, Excel 2011 for Mac.

Syntax

The syntax of the MINA function is as below:

= MINA (value1,[ value 2], …)

Where the MINA function arguments are:

  • value1 -This is a required argument. A number, or a reference to a number or a range that contains numeric values, text representations of numbers, or logical values
  • value2,… – This is an optional argument. A number, or a reference to a number or a range that contains numeric values. It can be up to 255 value argument in Excel 2007 or later, and it only can be up to 30 value argument in Excel 2003.

Note:

  • The arguments can be the following values: numbers, arrays or cell reference that contain numbers, text representation of numbers, or logical values (TRUE and FALSE).
  • If the argument is an array or reference that contain empty cells or text values, and those values will be ignored.
  • The logical TRUE value will be treated as 1; and the logical FALSE value will be treated as 0.
  • If an argument that contain error values or text that cannot be converted into numbers and it will return errors.
  • If the argument do not want to contain logical values and the text representation of numbers in array or reference, you can use the MIN function.

Excel MINA Function Examples

The below examples will show you how to use Excel MIN Function to get the smallest value form the numbers you provided in a range.

Example 1:  To get the smallest value from a range A1:A4, just using the following excel formula in Cell B1:

=MINA(A1:A4)

excel mina examples1

Example 2:  to get the smallest of the numbers in the range A1:A5 that contain logical FALSE (the value FALSE is evaluated to 0, so it is the smallest value), just using the following excel formula in Cell B1:

=MINA(A1:A5)

excel mina examples2


Related Functions

  • Excel MIN function
    The Excel MIN function returns the smallest numeric value from the numbers that you provided. Or returns the smallest value in the array.The MIN function is a build-in function in Microsoft Excel and it is categorized as a Statistical Function.The syntax of the MIN function is as below:= MIN(num1,[num2,…numn])….
  • Excel MAX function
    The Excel MAX function returns the largest numeric value from the numbers that you provided. Or returns the largest value in the array.= MAX(num1,[num2,…numn])…
  • Excel MAXA function
    The Excel MAXA function returns the largest numeric value from a range of values. The syntax of the MAXA function is as below:= MAXA(value1,[value2,…valueN])…
Related Posts

Excel DVAR Function
excel dvar examples1

This post will guide you how to use Excel DVAR function with syntax and examples in Microsoft excel. Description The Excel DVAR Function will get the variance of a population based on a sample of numbers in a column in ...

Excel DSUM Function
excel dsum examples1

This post will guide you how to use Excel DSUM function with syntax and examples in Microsoft excel. Description The Excel DSUM Function will add the numbers in a column or database that meets a given criteria. And so you ...

Excel DSTDEVP Function
excel dstdevp examples1

This post will guide you how to use Excel DSTDEVP function with syntax and examples in Microsoft excel. Description The Excel DSTDEVP returns the standard deviation of a population based on the entire population of numbers in a column or ...

Excel DSTDEV Function
excel dstdev examples1

This post will guide you how to use Excel DSTDEV function with syntax and examples in Microsoft excel. Description The Excel DSTDEV returns the standard deviation of a population based on a sample of numbers in a column or database ...

Excel DMIN Function
excel dmin function example1

This post will guide you how to use Excel DMIN function with syntax and examples in Microsoft excel. Description The Excel DMIN returns the minimum value from a database or a column of a list that matches the specified conditions. ...

Excel DPRODUCT Function
excel dproduct examples1

This post will guide you how to use Excel DPRODUCT function with syntax and examples in Microsoft excel. Description The Excel DPRODUCT returns the product of values from a set of records that match criteria that you specify. The DPRODUCT ...

Excel XIRR Function
excel xirr examples1

This post will guide you how to use Excel XIRR function with syntax and examples in Microsoft excel. Description The Excel XIRR function returns the internal rate of return for a series of cash flows that is not necessarily periodic. ...

Excel VDB Function
excel vdb examples1

This post will guide you how to use Excel VDB function with syntax and examples in Microsoft excel. Description The Excel VDB function calculates the depreciation of an asset for a specified period based on the double declining balance method. ...

Excel SYD Function
excel syd examples1

This post will guide you how to use Excel SYD function with syntax and examples in Microsoft excel. Description The Excel SYD function calculates the sum-of-years’digits depreciation of an asset for a specified period. And it will return a numeric ...

Excel SLN Function
excel sln examples1

This post will guide you how to use Excel SLN function with syntax and examples in Microsoft excel. Description The Excel SLN function calculates the depreciation of an asset for one period based on the straight line depreciation. And it ...

Sidebar