How to Use FORMULATEXT in Excel

What this does

FORMULATEXT shows what formula a cell contains, as a string. It exists for auditing and documentation: a column beside a calculation block that displays each formula makes a model reviewable without clicking through every cell, and it stays correct when the formulas change. It returns #N/A when the referenced cell holds a constant rather than a formula, which pairs naturally with ISFORMULA as a guard. Requires Excel 2013 or later. Most people learn this as a sequence of clicks and forget it by next week; learning it as a pattern instead is what lets you apply it to the next, slightly different version of the problem without starting from scratch. That is the difference this page is trying to make. For “use formulatext in excel”, the reliable version is a short checking loop, not just the first command that appears to work. Run it on a deliberately small range first, watch how the affected formula change, and only then apply the same setup to the full sheet. When a formula is involved, keep the inputs labelled beside it, reference cells instead of typing values, and apply number formatting only after the result checks out. That is what makes a workflow that saves repeating the same clicks every week useful in real work: repeatable, auditable, and not dependent on memory or luck.

A worked example

Documenting a model: =FORMULATEXT(C5) in a notes column returns the string "=B5*(1+$B$2)" for the reader to see. Guarding against constants: =IF(ISFORMULA(C5), FORMULATEXT(C5), "hard-coded"), which turns the same column into an audit flagging every typed-in number. FORMULATEXT makes a model self-documenting, which is the only kind of documentation that stays in step with the workbook. One habit worth forming early: name the cells that hold your inputs, so the formula reads in plain language instead of a string of cell addresses. A reviewer — or you in three months — can then follow the logic without decoding what B7 and D2 were supposed to mean, which is most of what makes a sheet maintainable.

In Google Sheets

Everything above works in Google Sheets too. Excel and Sheets share the formula syntax used here; only the surrounding menus are arranged differently. That portability is deliberate — learn it once and it follows you between the two tools and across Windows and Mac. The aim was to get you unstuck fast and leave you a little more capable than a copy-paste would. The answer is at the top, the tool proves it, and the detail above shows why it holds — so the next time a colleague asks, you can answer without reaching for search. Here is the takeaway for “use formulatext in excel”: copy the answer if you are busy, but if you have a spare few minutes, rebuild the example in Excel yourself with the tool above open beside it. That single pass — type it, run it, watch the result move when you change an input — is what turns a formula you found into a technique you trust. Keep your inputs labelled and referenced, never hard-coded, and the same sheet stays correct and auditable as it grows. Done that way, you will not need to look this up again, and you will be the person others ask.

Common mistakes

• Pointing it at a cell containing a constant, which returns #N/A — that is information, but guard it with ISFORMULA for a tidy sheet.
• Expecting it to evaluate the formula; it returns the text only.
• Using it in Excel 2010 or earlier, where it does not exist.

Frequently asked questions