# Difference between revisions of "Manuals/calci/MAXA"

Jump to navigation
Jump to search

Line 1: | Line 1: | ||

− | =MAXA() | + | <div style="font-size:30px">'''MAXA()'''</div><br/> |

− | |||

*Parameters are any set of numbers. | *Parameters are any set of numbers. | ||

− | + | **MAXA(), returns the maximum value in a list of arguments, including numbers, text, and logical values. | |

− | MAXA() | ||

== Description == | == Description == | ||

− | |||

MAXA() | MAXA() | ||

− | + | *For Example,MAXA(140,5,-2,10) ''returns 140'' | |

− | For Example, | + | *MAXA(-3,0.02,TRUE,-7) ''returns 1'' |

− | |||

− | 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. | *Arguments can be numbers, logical values, text, array or references that contain numbers. | ||

*Calci displays zero if the arguments do not have any numbers. | *Calci displays zero if the arguments do not have any numbers. |

## Latest revision as of 15:22, 8 August 2018

**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