See Formulas Next to the Answer
July 18, 2022 - by Bill Jelen
![See Formulas Next to the Answer See Formulas Next to the Answer](/img/excel-tips/2022/07/see-formulas-next-to-the-answer.jpg)
Problem: I need to audit several formulas. I already know how to use Show Formulas mode, but I need something more permanent.
Strategy: Use the =FORMULATEXT()
function. It was introduced in Excel 2013.
![The answer from formulas appear in C4:C6. Use =FORMULATEXT(C4) in D4 to see the formula next to the answer.](/img/content/2022/07/LE1481.png)
This article is an excerpt from Power Excel With MrExcel
Title photo by Antoine Dautry on Unsplash