the cell adress Ab143 denotes _row number and column label
Answers
Answer:
What is the Cell ADDRESS Function?
The cell ADDRESS function is categorized under Excel Lookup and Reference functions. It will provide a cell reference (its “address”) by taking the row number and column letter. The cell reference will be provided as a string of text. The function can return an address in a relative or absolute format and can be used to construct a cell reference inside a formula.
As a financial analyst, cell ADDRESS can be used to convert a column number to a letter, or vice versa. We can use the function to address the first cell or last cell in a range.
Formula
=ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text])
The formula uses the following arguments:
Row_num (required argument) – This is a numeric value specifying the row number to be used in the cell reference.
Column_num (required argument) – A numeric value specifying the column number to be used in the cell reference.
Abs_num (optional argument) – This is a numeric value specifying the type of reference to return:
Explanation:
i puts many extra for you
formulas ok love you all,