Maximum (MAX)
Syntax: MAX(x1; x2; … x30)
The MAX function can take up to 30 arguments, which can be ranges of cells, and returns the maximum value found in the given set. For example:
=MAX(B138; C138; D138; B140; C140; D140, B142; C142; D142)
results in 100.
Figure 7-9. Sample result of the MAX function
See also the sections on the LARGE, MIN, and SMALL functions.
Get Beginning OpenOffice Calc: From Setting Up Simple Spreadsheets to Business Forecasting now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
