FORMULATEXT function.Acquire formulas in specified cells as strings.(Microsoft Excel)

03/26/2024

Acquire formulas in specified cells as strings.

How it works

=FORMULATEXT(reference)
ArgumentOmissionSpecify
referenceRequired argument.Target cell.

Example Results

It is possible to display formulas for specified cells.

If a cell that is not a formula is specified, a #N/A error will result.

Spill

If you specify the argument "reference" the cell range, it will be Spil.

---

Links

Lookup & Reference(Microsoft Excel Functions)