# Manuals/calci/MAXA

Jump to navigation
Jump to search

**MAXA()**

- Parameters are any set of numbers.
- MAXA(), returns the maximum value in a list of arguments, including numbers, text, and logical values.

## Description

MAXA()

- For Example,MAXA(140,5,-2,10)
*returns 140* - MAXA(-3,0.02,TRUE,-7)
*returns 1* - Arguments can be numbers, logical values, text, array or references that contain numbers.
- Calci displays zero if the arguments do not have any numbers.
- If the logical values and text values are entered directly in the argument, or as a part of array or reference, are counted in finding the MAX value.
- The logical value TRUE is considered '1' and FALSE is considered '0'. Any text is evaluated with value 0.

## ZOS

- The syntax is to calculate maximum numbers in the set of numbers in ZOS is .
- Parameters are any set of numbers.

- For e.g.,MAXA(-10..-1,false)

## Examples

0.02 | |

0.5 | |

-6 | |

TRUE | |

FALSE | |

NAME |

=MAXA(A1:A6) : Calculates the maximum value in the range A1 to A6. Displays1(for TRUE ) as a result. =MAXA(-2,FALSE) : Calculates the maximum value between -2 and FALSE. Displays0(for FALSE) as a result. =MAXA(A1:A3, 2) : Calculates the maximum value in the range A1 to A3 and value 2. Displays2as a result.

## Related Videos

## See Also

## References