FormulaText in Excel 2013

This is a new feature introduced in Excel 2013. This is used to return the string formula (if any) present in the cell of which we provide a reference to. If the cell does not contain a formula then it returns a NULL value .i.e. NA. The syntax of it is =FORMULATEXT(reference). Here reference is the reference to the cell of which we need to determine the formula.

Let's have a look at the following steps.

Step 1

First go to Excel 2013.

Step 2

Now open the blank workbook template from the available templates.

formulatext.jpg

Step 3

Now enter some data into a few cells of the sheet as the outcome of the formula that we are using like this:

formulatextinexcel.jpg

Step 4

Now if we want to see the formula which we have applied in the few cells by using keyboard shortcut key then first we will select the cell and then will press the ctrl+` key in the keyboard.

Step 5

The output will be like this:

excelformulatext.jpg

Step 6

If we want it to return to the same position then we will again press the ctrl + ` key on the keyboard and the output will be like this:

formulatextexcel2013.jpg

Step 7

If we want to see the formula we applied in the few cells but in front of the cells then we will use the FormulaText() function and  for that we write a title named FormulaText in the cell.

formulainexcel.jpg

Step 8

Now write the following formula in front of the cell:

textofformulainexcel.jpg

Step 9

Now press enter; the output will be like this:

excel2013formulatext.jpg

Step 10

Now copy this cell in which we have used the formulaText() formula and paste it into the cells we want to show the formula just in front of the formula applied cells and the output will be like this:

formulatextexcel.jpg


formulatextinexcel2013.jpg


Similar Articles