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.