FORMULATEXT
Returns the formula at the given reference as text.
Lookup & ReferenceLookup & Matching Essentials
What it does
Displays the formula string from a cell.
Syntax
FORMULATEXT(reference)
Arguments
reference(reference) — A cell containing a formula.
Examples
Show Formula
Display formula in A1.
FORMULA
=FORMULATEXT(A1)
RESULT
=SUM(B1:B10)
SAMPLE DATA
| A | |
|---|---|
| 1 | Total |
| 2 | 55 |