General Functions in Excel: Difference between revisions
Jump to navigation
Jump to search
(Created page with "=Internal= * Excel =<tt>INDEX</tt>= The <code>INDEX</code> function returns a value or a reference to a value from a table or range. <font size...") |
(→ROW) |
||
| (One intermediate revision by the same user not shown) | |||
| Line 15: | Line 15: | ||
* '''row_num''' selects the row in array from which to reenter the value. | * '''row_num''' selects the row in array from which to reenter the value. | ||
=<tt>ROW</tt>= | |||
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", ...)