Excel Function : FORMULATEXT

Download now!

Excel Function : FORMULATEXT

Category

Lookup and reference

Description

Returns the formula at the given reference as text

Microsoft Excel Reference Page

https://support.office.com/en-us/article/FORMULATEXT-function-0a786771-54fd-4ae2-96ee-09cda35439c8

Syntax and Description of the FORMULATEXT Excel Function

The syntax for the FORMULATEXT function in Microsoft Excel is: FORMULATEXT( reference ) Reference is a cell reference. The FORMULATEXT function returns the formula in a cell as text.

About FORMULATEXT Excel Function

The FORMULATEXT function returns a string that represents the formula in a cell. For example, if cell A1 contains the formula =B1+C1, the formula in A1 is returned as =B1+C1.