FORMULATEXT Function

About

FORMULATEXT function in Excel returns a formula as a text string from given reference.

Function Type

Lookup and reference

Purpose

Get the formula in a cell

Return value

Formula as text

Syntax

=FORMULATEXT(reference)

Arguments

reference – A cell reference


Example 1


Notes

TEXT function will not convert numbers into words.


Read about Excel Functions

Excel Functions in Alphabetical Order (Complete list)

Complete List of Excel Functions (Category wise)


New Dynamic Array Functions in Excel

LET Function in Excel

STOCKHISTORY Function in Excel