Formulatext() Function

The Excel FORMULATEXT function returns a formula as a text string from given reference. You can use FORMULATEXT to extract a formula as text from a cell. If you use FORMULATEXT on a cell that doesn't contain a formula, you'll get an #N/A error.

Syntax

The syntax for the FORMULATEXT function in Microsoft Excel is:

=FORMULATEXT (reference)

Parameters or Arguments

reference

Reference to cell or cell range.

FormulaText Function Example

The Excel FormulaText function is used in cell C1 of the following spreadsheet, to display the formula from cell B4.

Formula:

A B C 1 25 =FORMULATEXT( B4 ) 2 31 3 28 4 SUM: 84

Result:

A B C 1 25 =SUM(B1:B3) 2 31 3 28 4 SUM: 84

Notes

►   If you use FORMULATEXT on a cell that doesn't contain a formula, you'll get an #N/A error.

►   You can reference another workbook, but if the workbook is not open, you'll get an #N/A error.

►   FORMULATEXT was introduced in Excel 2013.

Reference:

https://exceljet.net/excel-functions/excel-formulatext-function

http://www.excelfunctions.net/excel-formulatext-function.html

follow us on http://arivilm.blogspot.in  

like us on https://www.facebook.com/Arivilm2501/