Exceltechie.comEasiest way to learn excel on the planet |
|
|
|
| || | Novice | || | Beginner | || | Intermediate | || | Advanced | || | Specialist | || | Expert | || |
Types of Formula
ROW
ROW returns the row number of a cell reference.
Syntax ROW(reference)
| reference | Cell or range of cells for which we want the row number |
COLUMN
COLUMN returns the Column number of a cell reference.
Syntax COLUMN(reference)
| reference | Cell or range of cells for which we want the Column number |
INDIRECT
Returns the reference specified by a text string.
Syntax INDIRECT(ref_text,[a1])
| Ref_text | refers to a cell as a text string |
| a1 | is a logical value that specifies what type of reference is contained in the cell ref_text. |