Show Formulas with FORMULATEXT in Excel 2013

There is a new function in Excel 2013 – FORMULATEXT – that lets you show the text from a cell’s formula.

In the screen shot below, cell C2 contains the formula:

=FORMULATEXT(B2)

formulatext02

It shows the formula that’s in cell B2, just as if you had clicked on cell B2 and looked in the formula bar.

formulatext04

Use FORMULATEXT for Troubleshooting

You can use FORMULATEXT for auditing or troubleshooting a worksheet. For example, combine FORMULATEXT with the INDIRECT function, to check the formula in any cell.

In the screenshot below, a cell address (B2) is entered in cell B4, and the FORMULATEXT result shows the formula from cell B2.

=FORMULATEXT(INDIRECT(B4))

formulatext08

More on FORMULATEXT

For more FORMULATEXT information and examples, please visit my Contextures website. You can read the details there, and download the sample file: Excel FORMULATEXT Function

Video: Excel FORMULATEXT Function

To see the steps for creating a FORMULATEXT function, and a few examples, please watch this short video tutorial.

Or watch on YouTube: Get Formula Text with Excel 2013 FORMULATEXT Function

______________

4 comments to Show Formulas with FORMULATEXT in Excel 2013

Leave a Reply

  

  

  

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>