Returns formula expression as text. It returns an error if the cell reference does not contain a formula.
Sample Usage
FORMULATEXT(C5)
Syntax
FORMULATEXT(cell_reference)
- cell_reference - the cell whose formula expression is to be returned
Examples
FORMULATEXT(C5) returns the formula contained in cell C5. If the cell does not have any formula, the #N/A error is returned.
Notes
- FORMULATEXT returns what is displayed in the formula bar of the cell_reference.
- If the reference argument is to an entire row or column, or to a range, FORMULATEXT returns the value in the upper leftmost cell of the row, column, or range.