Microsoft Office Tutorials and References
In Depth Information
Using FORMULATEXT to Document a Worksheet
Using
Using FORMULATEXT
FORMULATEXT to Document a Worksheet
to Document a Worksheet
Quiz: Which Excel function is used the most in this topic? It is FORMULATEXT.
The FORMULATEXT function is brand new in Excel 2013. If you ask for the
=FORMULATEXT(A1), Excel will show the formula that is in cell A1 as text.
All the formulas shown in this topic (such as cell C1 in Figure 12.32 ) are
generated with the FORMULATEXT function.
You can use FORMULATEXT to document the formulas used in your work-
sheet. Normally, you can either print your worksheet with formulas showing
or with the results from the formulas. By using FORMULATEXT, you can
show both the formula and the result.
In Figure 12.33 , the text of the formula shown in C3 comes from a
FORMULATEXT function.
Figure 12.33.
Figure 12.33. A FORMULATEXT
FORMULATEXT function in C3 shows the formula used in B3.
function in C3 shows the formula used in B3.
Syntax
FORMULATEXT(reference)
This function returns a formula as text.
Search JabSto ::




Custom Search