Spreadsheet Formula Explainer
Paste a formula and generate a structured review of what to inspect.
Understand a spreadsheet formula
A nested spreadsheet formula can be inscrutable — layers of IF, VLOOKUP, and arithmetic that are hard to unpick when something goes wrong. This tool takes a formula and generates a structured review of what to inspect, so you can debug it methodically.
Breaking a formula into what each part does, and where the common failure points are, turns debugging from guesswork into a checklist. Paste the formula, work through the review, and find the piece that is misbehaving.
Unpicking formulas
It breaks a nested formula into its layered steps so you can see what each IF or lookup contributes. The explanation runs in your browser and never uploads your data.
Frequently asked questions
What does it pull out of the formula?
The function names it uses (such as IF or VLOOKUP) and every cell or range it references (such as A2 or B2:B50), listed above a six-step review checklist.
What goes in the second field?
The spreadsheet app, such as Google Sheets or Excel, since some functions and error behaviors differ between them.
Why check what happens with blank cells?
Blanks are treated as zero in math but as empty text in comparisons, so a formula like =IF(A2>100, …) can return an unexpected result when A2 is empty.
Related tools
Free private browser tools for practical work.