Creating Pixel-Perfect Reports > Getting Started with the Reports Tool in the Desktop Application > Building Report > Adding a New Sheet and Working with It > Working with Report Sheet Data > Using Formulas > Function Wizard > Mathematical Functions > Mina
The function wizard for the Mina function:
Mina(Value1,...)
Value1, Value2, …, ValueN. The range of cells minimum value of which is to be defined.
It returns the minimum number in the cell array containing not only numeric values.
Parameter values can include numbers, empty cells, logical values, text, cell references, formulas. The number of values can be from 1 to 255.
The True value is interpreted as -1, text values, and the False value is interpreted as 0.
Only Latin letters are allowed.
| Formula | Result | Description |
| =Mina(A7:A9, A11, A6) | 2 | Minimum number in the array stored in A7:A9, A11, A6. The A6 cell contains the 180 number, A7 contains the 2 number, A8 contains the 270 number, A9 contains the 50 number, A11 contains the 100 number. |
| =Mina(true, false, 15, 10) | -1 | The minimum number in the specified array that corresponds to True. |
See also:
Function Wizard │ Mathematical Functions
