writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + − + Line 7:
Line 7: − + Line 15:
Line 15: − + Line 21:
Line 21: − + − +
no edit summary
=MAX(n1,n2,...)=
=MAX()=
*where <math>n1,n2,...</math> are numbers.
*Parameters are any set of numbers.
MAX() calculates the largest value in a set of given values.
MAX() calculates the largest value in a set of given values.
== Description ==
== Description ==
MAX(n1,n2,....)
MAX()
For Example,
For Example,
MAX(-3,0.02,TRUE,-7) ''returns 1''
MAX(-3,0.02,TRUE,-7) ''returns 1''
*Arguments <math>n1,n2,...</math> 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.
*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 directly in the argument, they are considered in finding the MAX value.
==ZOS==
==ZOS==
*The syntax is to calculate the maximum value in the set of numbers in ZOS is <math>MAX(n1,n2,...)</math>.
*The syntax is to calculate the maximum value in the set of numbers in ZOS is <math>MAX()</math>.
**where <math>n1,n2,...</math> are numbers.
**Parameters are any set of numbers.
*For e.g.,MAX(2..8,10..15)
*For e.g.,MAX(2..8,10..15)