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() calculates the smallest value in a data set containing text and logical values.
Sample Files
Use the MAXA&MINA worksheet in the Count.xls or Count.xlsx sample file. The sample files are found in the Chapter12 folder. For more information about the sample files, see the section titled Using the Sample Files.
3.144.113.163