Maximum and minimum functions

To use these functions, choose Calc > Calculator.

Identifies the largest and smallest value of the data.

Syntax

Column statistics
MAX(number)
MIN(number)

For number, specify the column number.

Row statistics
RMAX(number,number,...)
RMIN(number,number,...)

For number, specify each column number to define the length of the rows.

Examples

Columns Calculator expression Result
C1 contains 6, 3, 15 MAX (C1) 15
C1 contains 22, 3, 7 MIN (C1) 3
C1 contains 6, C2 contains 3, and C3 contains 15 RMAX (C1, C2, C3) 15
C1 contains 22, C2 contains 3, and C3 contains 7 RMIN (C1, C2, C3) 3