![Free-eBooks.net](/resources/img/logo-nfe.png)
![All New Design](/resources/img/allnew.png)
Exercise 20: View the Formula of cell in another Cell
1. Create a UDF Formuladisplay (User Defined Function)
To create this Function, execute the following steps
Insert the below code in a New Module
This Code lines will create function Formuladisplay () , In Cell D1 Type
= Hedqtrs( (C1)
Syntax FORMULATEXT(reference)
2. Use Excel Formulas (FORMULATEXT)
=FORMULATEXT(C1)