Difference between revisions of "Documentation/How Tos/Calc: MAX function"

Revision as of 14:03, 25 February 2009

Returns the maximum of a list of arguments, ignoring text entries.

MAX(number1; number2; ... number30)

number1 to number30 are up to 30 numbers or ranges containing numbers.

MAX(2; 6; 4)

returns 6, the largest value in the list.

MAX(B1:B3)

where cells B1, B2, B3 contain 1.1, 2.2, and apple returns 2.2.

Calc assumes that logical values are 1 (TRUE) and 0 (FALSE). Excel ignores logical values.

@@ Line 17: / Line 17: @@
 : where cells <tt>'''B1'''</tt>, <tt>'''B2'''</tt>, <tt>'''B3'''</tt> contain <tt>'''1.1'''</tt>, <tt>'''2.2'''</tt>, and <tt>'''apple'''</tt> returns <tt>'''2.2'''</tt>.
-=== See also: ===
+{{Documentation/SeeAlso|
-[[Documentation/How_Tos/Calc: MAXA function|'''MAXA''']],
+* [[Documentation/How_Tos/Calc: MAXA function|MAXA]],
-[[Documentation/How_Tos/Calc: MIN function|'''MIN''']],
+* [[Documentation/How_Tos/Calc: MIN function|MIN]],
-[[Documentation/How_Tos/Calc: MINA function|'''MINA''']],
+* [[Documentation/How_Tos/Calc: MINA function|MINA]],
-[[Documentation/How_Tos/Calc: DMAX function|'''DMAX''']]
+* [[Documentation/How_Tos/Calc: DMAX function|DMAX]]
-[[Documentation/How_Tos/Calc: Statistical functions|'''Statistical functions''']]
+* [[Documentation/How_Tos/Calc: Statistical functions|Statistical functions]]
-[[Documentation/How_Tos/Calc: Functions listed alphabetically|'''Functions listed alphabetically''']],
+* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
-[[Documentation/How_Tos/Calc: Functions listed by category|'''Functions listed by category''']]
+* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}}
 ===Issues: ===
 * Calc assumes that logical values are <tt>'''1'''</tt> (<tt>'''TRUE'''</tt>) and <tt>'''0'''</tt> (<tt>'''FALSE'''</tt>). Excel ignores logical values.