September 2011
Beginner
140 pages
3h 40m
English
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.
Read now
Unlock full access