Microsoft Office Tutorials and References
In Depth Information
Using FORMULATEXT to Document a Worksheet
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.
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.
Figure 12.33. A FORMULATEXT
FORMULATEXT function in C3 shows the formula used in B3.
function in C3 shows the formula used in B3.
This function returns a formula as text.