In Excel: select the cell and go to Formulas ▸ Formula Auditing ▸ Evaluate Formula to step through the calculation one piece at a time, or select just part of the formula in the formula bar and press F9 to see that fragment's value — press Esc afterward, not Enter, or the selected part gets permanently overwritten with its result.
Click the cell with the formula, then go to Formulas ▸ Formula Auditing ▸ Evaluate Formula.
Click Evaluate repeatedly; the underlined part shows what will be calculated next, and the dialog updates to show the substituted result.
Click Step In to expand a cell reference used inside the formula, and Step Out to collapse back.
For a quicker one-off check, click into the formula bar, select just the fragment you want to test, and press F9.
Press Esc (not Enter) to leave the formula bar without overwriting the formula with the calculated fragment.
Need it as an auditable file?
Ships inside the linked template — formula-driven, unlocked, audit-ready.
What this does
Excel has two separate tools for seeing how a formula arrives at its answer, not one. Evaluate Formula opens a dialog that walks through the formula's evaluation order step by step, showing which nested function or reference resolves first, similar to a debugger stepping through code. The F9-in-the-formula-bar trick is faster for a single question: highlight just the part of the formula you're unsure about and press F9 to see that fragment's computed value inline, without opening any dialog — but it is destructive if you press Enter instead of Esc, because Excel then replaces the highlighted formula text with the static number it just calculated. The same idea underpins a lot of everyday Excel work, so the few minutes spent getting it right here pay back across every sheet you build afterwards. Treat it as a pattern, not a one-off, and it stops being something you look up and starts being something you reach for. The difference between a quick fix and a sheet you can trust is the extra minute you spend validating “excel evaluate formula”. Start on a copy or a tiny sample, keep the affected formula visible, and compare the result with the tool above before you touch the real workbook. When this is a ribbon command, the selection matters more than the button: confirm the range, apply the command, then spot-check the output before saving. The point is a calculation you can defend to a CFO or an auditor, but the practical win is that someone else can open the file and understand what happened without asking you.
A worked example
A cell contains =VLOOKUP(A2,Data!$A:$C,MATCH("Price",Data!$A$1:$C$1,0),FALSE) and returns #N/A. Formulas ▸ Formula Auditing ▸ Evaluate Formula, then click Evaluate repeatedly: the dialog resolves MATCH("Price",...) first, showing it returns 3, then substitutes that 3 into the VLOOKUP, then shows the VLOOKUP itself failing — revealing the lookup value in A2 has trailing spaces that MATCH resolved fine but VLOOKUP's exact match could not. Alternatively, in the formula bar, highlighting just MATCH("Price",Data!$A$1:$C$1,0) and pressing F9 shows 3 immediately inline, then Esc restores the live formula unchanged. A wrong result from a nested formula is hard to debug by staring at the formula bar; stepping through the actual evaluation order — or spot-checking one fragment with F9 — finds the exact function that produced the bad value instead of guessing. If there is any chance you will reuse this, drop it into a small template tab right now: a labelled input area on the left and the formula beside it, checked once against the tool above. Next time the same question comes up, the answer is a single paste away instead of a rebuild from memory.
In Google Sheets
If you are in Google Sheets rather than Excel, the good news is that the formula shown here is identical and the workflow barely changes — menus sit across the top instead of in a ribbon, and a few function names differ slightly, but anything you build here moves across with little or no rework. Keep this page bookmarked for the next time the same question comes up. Better still, rebuild the example once in your own sheet — doing it yourself, with the tool above to check against, is what turns a copied formula into a technique you own. Here is the takeaway for “excel evaluate formula”: 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
- Pressing Enter instead of Esc after an
F9formula-bar check, which permanently replaces the selected part of the formula with a hard-coded number. - Trying Evaluate Formula on an array formula or spilled range, where the dialog often cannot walk through every element the way it does for a single-cell calculation.
- Assuming Evaluate Formula changes anything in the cell — it does not; it is read-only and closing the dialog leaves the formula exactly as it was.
- Using
F9on the whole formula instead of a highlighted fragment, which just recalculates everything rather than isolating the one piece in question.
Frequently asked questions
How do I evaluate part of a formula in Excel?
Click into the formula bar, select just that part of the formula, and press F9 to see its value inline. Press Esc afterward so the selection is not permanently replaced.
Where is Evaluate Formula in Excel?
Formulas ▸ Formula Auditing ▸ Evaluate Formula. It only appears for the currently selected cell that contains a formula.
Can I evaluate part of a formula in Google Sheets the same way?
No — Sheets has no F9-in-the-formula-bar equivalent and no Evaluate Formula dialog. To see an intermediate value, restructure the formula with LET() to name the sub-expression, then temporarily change the final output to return that name instead of the full result, or copy the sub-expression into a helper cell.
Other ways people ask this
This is also commonly searched as “evaluate formula excel mac” and “mac excel evaluate formula”. They describe the identical operation, so you are in the right place no matter how you phrased it.
Platform & version notes
- If you are on a Mac, nothing here changes except the modifier key: swap Ctrl for ⌘ in every shortcut, and use the Windows/Mac toggle at the top of the page so the keystrokes shown match the keyboard in front of you.
How is it different on a Mac?
Only the keys. Press ⌘ where Windows uses Ctrl; the menus, formulas and result for "excel evaluate formula" are the same on macOS as on Windows.
Why do people search for this in so many different ways?
Because the same task has many names. “evaluate formula excel mac”, “mac excel evaluate formula” all point at the one operation explained on this page, which is why they all lead here.