Beginning OpenOffice Calc: From Setting Up Simple Spreadsheets to Business Forecasting by Jacek Artymiak

Author:Jacek Artymiak
Language: eng
Format: epub
Publisher: Apress®
Published: 2011-08-29T16:00:00+00:00

Figure 7-8. Sample result of the SMALL function

You can set the k argument to any integer value you like, but it must not be zero or larger than the number of elements in the given set of numbers.

See also the sections on the LARGE, MAX, and MIN functions.

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.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.