Manuals/calci/MAXA

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. Displays 1 (for TRUE ) as a result.
=MAXA(-2,FALSE)  : Calculates the maximum value between -2 and FALSE. Displays 0 (for FALSE) as a result.
=MAXA(A1:A3, 2)  : Calculates the maximum value in the range A1 to A3 and value 2. Displays 2 as a result.

Related Videos

MAXA

See Also

References