# Documentation/Calc Functions/MAXA

Jump to navigation
Jump to search

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## Function name:

MAXA

## Category:

Statistical Analysis

## Summary:

Identifies the maximum value in the list of numbers passed as arguments. Cells containing text are given the value 0 and empty cells are ignored.

## Syntax:

MAXA(**Number 1** [; **Number 2** [; … [; **Number 255**]]])

## Returns:

Returns the largest value from the list of numbers passed as arguments. Empty cells are ignored and cells containing text are given the value 0.

## Arguments:

**Number 1**, **Number 2**, … , **Number 255** are numbers, references to cells or to cell ranges of numbers. Empty cells are ignored and cells containing text are given the value 0.

The logical value TRUE counts as 1, while FALSE counts as 0

- The function MAXA() returns 0 if no value (numeric or text) and no error was encountered either directly in arguments or in the cell range(s) passed as cell reference(s).
- Passing a literal string argument to MAXA(), e.g. MAXA("string"), counts it as 0.

## Additional details:

None

## Examples:

Formula | Description | Returns |
---|---|---|

=MAXA(A1:A5) where A1,A2,A3,A4,A5 are 1,2,3,4,5 | returns the largest value from 1,2,3,4,5 | 5 |

=MAXA(1.5;-2;0;-4.2) | returns the largest value from 1.5,-2,0,-4.2 | 1.5 |

=MAXA(1.5;"alpha";0;-4.2) | returns the largest value from 1.5,0(for "alpha"),0,-4.2 | 1.5 |

=MAXA(-1.5;"alpha";-3;-4.2) | returns the largest value from -1.5,0(for "alpha"),-3,-4.2 | 0 |

## Related LibreOffice functions:

## ODF standard:

## Equivalent Excel functions:

MAXA