Miscellaneous functions

CHIGH Highest column number

The CHIGH() function takes no argument and returns the highest column number used in the spreadsheet.

COLUMN Spreadsheet column identifier

The identifier COLUMN refers to the column number (corresponding with variables) in the spreadsheet.

FALSE Logical constant FALSE

The logical constant FALSE corresponds to the numeric value 0.

RHIGH Highest row number

The RHIGH() function takes no argument and returns the highest row number used in the spreadsheet.

ROW Spreadsheet row identifier

The identifier ROW refers to the row number (indicating cases) in the spreadsheet (see e.g. Fill column dialog box).

TRUE Logical constant TRUE

The logical constant TRUE corresponds to the numeric value 1.

See also

• Spreadsheet: Introduction
• Operators
• Relative and absolute cell addresses
• Mathematical functions
• Statistical functions
• Statistical functions on variables
• String functions
• Logical functions
• Date and time functions