Rational
To display formula as text.
Description
The Excel FORMULATEXT function display the syntax of a reference cell as a string.
For example, Reference cell B5 contains the addition of two number =5+2 which return 7, = FORMULATEXT(B5) return a text value “=5+2”, not the result of the calculations.
Syntax
= FORMULATEXT(reference)
Parameters
reference – A reference to a cell or range of cells.
Return Value
The formula in text format.
Key Notes
The FORMULATEXT can be a great feature to highlight the cell that links to a given formula.
Note that formula is in a text format and cannot be part of any other calculation.
There are other options to display the formula in Excel:
- By using keyboard shortcut – Ctrl+` (Windows) and ^+` (Mac). This formula converts all formulas to text in a worksheet.
- If you want to highlight only a single cell, at the start of formula we can enter an apostrophe (‘) or space “ “ to convert into text. Example ‘=A23*(1+C$1) is a text format and won’t return calculations.
Example
For example, If there is no formula it return #N/A (Not Available) like here in cell C8 (Result).
Keep Reading Similar Functions:
TRANSPOSE
The TRANSPOSE function “switch data direction” or the range of data from vertical format (row) to horizontal format (column), or vice versa.
HYPERLINK
The HYPERLINK function creates a shortcut or clickable link of a given location with a “friendly name”. User Click that initiates a call for action.