Manuals/calci/MAX

MAX()

• Parameters are any set of numbers.
  • MAX(), returns the maximum value in a list of arguments.

Description

MAX()

• For Example,MAX(10,40,5,2,100) returns 100
• MAX(-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, they are considered in finding the MAX value.
• If the logical values and text values are entered as a part of array or reference, they are not counted.

ZOS

• The syntax is to calculate the maximum value in the set of numbers in ZOS is $MAX()$.
  • Parameters are any set of numbers.
• For e.g.,MAX(2..8,10..15)

Examples

0.02
0.5
-6
TRUE
100
NAME

=MAX(A1:A6)  : Calculates the maximum value in the range A1 to A6. TRUE and NAME are not counted. Displays 100 as a result.
=MAX(200,A3)  : Calculates the maximum value between 200 and -6. Displays 200 as a result.
=MAX(A1:A3, 2)  : Calculates the maximum value in the range A1 to A3 and value 2. Displays 2 as a result.

Related Videos

MAX

See Also

• MAXA

References

• Large Number
• Small Number

• List of Main Z Functions

• Z3 home