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 > Maxa
The function wizard for the Maxa function:
Maxa(Value1,...)
Value1, Value2, …, ValueN. Range of cells, the maximum of which you want to find.
It returns the maximum value in the cell array that contains 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 |
| =Maxa(A7:A9, A11, A6) | 270 | Maximum 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. |
| =Maxa(true, false, 15, 10) | 15 | Maximum number in the specified array. |
See also:
Function Wizard │ Mathematical Functions
