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

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).

MINA() calculates the smallest value in a data set containing text and logical values.

Figure 12-98. MINA() calculates the smallest value in a data set containing text and logical values.

See Also

DMIN(), MAXA()