writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 3:
Line 3: − + Line 15:
Line 15: + + + Line 55:
Line 58: + + + + + + − =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.+
no edit summary
*Where n1,n2,... are numbers.
*Where n1,n2,... are numbers.
MAX() calculates the largest value in a set of values.
MAX() calculates the largest value in a set of given values.
== Description ==
== Description ==
MAX(-3,0.02,TRUE,-7) ''returns 1''
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.
*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.
== Examples ==
== Examples ==
=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(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.
== See Also ==
*[[Manuals/calci/MAXA| MAXA]]
==References==
*[]