General Functions in Excel: Difference between revisions
Jump to navigation
Jump to search
(→INDEX) |
(→ROW) |
||
| Line 20: | Line 20: | ||
Returns the town number of a reference. The reference is a cell or a range. | Returns the town number of a reference. The reference is a cell or a range. | ||
=<tt>ISBLANK</tt>= | |||
Returns true if the cell is blank: | |||
<font size=-2> | |||
IF(ISBLANK(D2), "N/A", ...) | |||
</font> | |||
Latest revision as of 06:06, 23 December 2023
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", ...)