[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
MINA ( argument-list )
Description: Computes the smallest of a set of numbers.
Arguments:
|
Name |
Type |
Description |
|
argument-list |
logical, number, name, arrays, reference to number. Any argument can be an array or a reference to an array. |
The arguments in argument-list designate the values for which the largest value is to be computed. Logical values and text representations of numbers occurring directly in the list of arguments are included. Logical values and numbers in strings inside references are also included. [Note: To ignore these, use MIN (§3.17.7.210). end note] If an array or reference argument contains non-numeric text or empty cells, those values are ignored; however, cells with the value 0 are included. |
Any argument in argument-list can be an array or a reference to an array.
Return Type and Value: number – The smallest of a set of numbers; however, if the arguments contain no numbers, zero is returned.
[Example:
MINA(10.4,-3.5,12.6) results in -3.5
MINA(10.4,{-3.5,12.6}) results in -3.5
MINA({"ABC",TRUE}) results in 0
Consider the case in which cell B3 contains 0:
MIN(10,12,15,B3) results in 10
MINA(10,12,15,B3) results in 0
end example]