FORMULATEXT(reference)

Returns the formula from a particular cell.

referenceThe cell or range reference.

Remarks

* Added in Excel 2013.
* If "reference" does not contain a formula, then #N/A is returned.
* If "reference" > 8192 characters, then #N/A is returned.
* If "reference" contains an external reference that cannot be opened, then #N/A is returned.
* If "reference" refers to a workbook that is not open, then #N/A is returned.
* The "reference" can refer to another worksheet or workbook.
* You can use the shortcut key (Ctrl + ') to quickly toggle the display of formulas.
* You can use the ISFORMULA function to return True or False if a particular cell contains a formula.
* For the Microsoft documentation refer to support.microsoft.com

 AB
1=FORMULATEXT(C4) = SUM(C1:C3)5
2=FORMULATEXT(A2) = FORMULATEXT(A2)10
3=FORMULATEXT(#REF!) = #REF!15
4=FORMULATEXT(B1) = #N/A=SUM(B1:B3) = 30

© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top