MINA()
Syntax. MINA(value1,value2,...)
Definition. This function returns the smallest value in an argument list. Not only numbers but also text and logical values (TRUE and FALSE) are compared.
Arguments
value1 (required) and value2 (optional). At least one and up to 255 arguments (30 in Excel 2003 and earlier versions) for which you want to find the smallest value
Background. The MINA() and MAXA() functions as well as their arguments were already explained in detail in the description of MAXA().
Example. Using the same example as for MAXA(), the MINA() function returns 0 because the smallest value is the logical value FALSE (see Figure 12-98).
Figure 12-98. MINA() ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
