Article updated on April 14, 2018

The FORMULATEXT function returns a formula as a text string.

Formula in cell C3:


Excel Function Syntax



reference Required. The cell you want to display the formula.


The FORMULATEXT function was introduced in Excel 2013.

Keep in mind, the FORMULATEXT function returns an #N/A error if cell is empty or contains a number, text or boolean value.

It also displays the formula even if the returning value is an error value.