General Functions in Excel

From NovaOrdis Knowledge Base
Jump to navigation Jump to search

Internal

INDEX

The INDEX function returns a value or a reference to a value from a table or range.

INDEX(array, row_num, [column_num])

where:

  • array is a range of cells or an array constant.
  • row_num selects the row in array from which to reenter the value.


ROW

Returns the town number of a reference. The reference is a cell or a range.

ISBLANK

Returns true if the cell is blank:

IF(ISBLANK(D2), "N/A", ...)