This function returns a formula as a string.

Syntax

FORMULATEXT(reference)

Arguments

Specify the reference to single cell or range of cells for the argument.

Remarks

In this function, text displayed in the formula bar of the specified cell is returned. Reference argument can refer to cell (or cells) of another worksheet or workbook too. Value of upper leftmost cell or row is returned, if an entire row or column is refered.

Data Types

Accepts cell reference for argument. Returns string data.

Examples

FORMULATEXT(B7) gives the value #N/A