# Manuals/calci/MAXA

Jump to navigation
Jump to search

# MAXA()

- Parameters are any set of numbers.

MAXA() calculates the largest value in a set of given 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