FORMULATEXT
Description
Returns a formula as text.
Syntax
FORMULATEXT(
reference
)
- reference: The reference to a cell that contains the formula.
Example
Formula | Result |
|---|---|
=FORMULATEXT(!'Sheet 1'!A1) |
The formula contained in
Sheet 1
in cell
A1
.
|