Investment Studio > Expressions > Functions > Reference

Also see Matrix functions.

Result type Function name Arguments
string address (integer row_number, integer column_number, integer absolute = 1)
array array (reference cell_reference)
  choose (integer argument_index, argument [, ...])
integer column ()
integer   (reference cell_reference)
integer array[1][*]   (reference range_reference)
integer columns (array[*][*] argument)
  hlookup (lookup_value, array[*][*] table, integer result_row = 1, boolean range_lookup = TRUE)
  index (array[*][*] table, integer row = 0, integer column = 0)
  indirect (reference cell_reference)
  lookup (lookup_value, array[*][*] table)
    (lookup_value, array values, array results)
integer match (lookup_value, array[*][*] table, integer match_type = 1)
reference offset (reference base_reference, integer rows, integer columns, integer height = 0, integer width = 0)
integer row ()
integer   (reference cell_reference)
integer array[*][1]   (reference range_reference)
integer rows (array argument)
array[*][*] subarray (array[*][*] source_array, integer start_row, integer end_row, integer start_column, integer end_column)
  vlookup (lookup_value, array[*][*] table, integer result_column = 1, boolean range_lookup = TRUE)