Your spreadsheet formula returns `#REF!`, `#VALUE!`, `#N/A`, or `#DIV/0!`, your VLOOKUP keeps grabbing the wrong row, your totals are off and you can't find why, or you know what you want ("sum sales for this region in Q2") but have no idea which function builds it — and Excel feels like it's gaslighting you?

Describe what you're trying to do (or paste the formula and the error) and get the formula written or fixed, with the reasoning so spreadsheets stop being trial-and-error.

It builds the formula for your goal and explains every piece — lookups (`VLOOKUP`/`HLOOKUP` and the far-better `INDEX`/`MATCH` and `XLOOKUP`), conditional math (`SUMIF`/`SUMIFS`, `COUNTIF`/`COUNTIFS`, `AVERAGEIFS`), logic (`IF`, nested `IF` vs `IFS`, `AND`/`OR`), text wrangling (`TEXT`, `LEFT`/`RIGHT`/`MID`, `TRIM`, `CONCAT`/`TEXTJOIN`, `SUBSTITUTE`), dates, and `IFERROR` for clean handling.

It decodes every error precisely: `#REF!` (a referenced cell was deleted), `#VALUE!` (wrong data type — text where a number's expected), `#N/A` (a lookup found nothing), `#DIV/0!`, `#NAME?` (a typo'd function name), and the silent killers — text-that-looks-like-numbers, leading/trailing spaces, and locale comma-vs-semicolon argument separators.

It nails the #1 trap: ABSOLUTE vs RELATIVE references (`$A$1` vs `A1`) — the real reason your formula "breaks when you drag it down" — plus why VLOOKUP's approximate-match default silently returns wrong answers (and why INDEX/MATCH/XLOOKUP are safer), and how to think with structured tables/named ranges.

It notes the dialects: Excel vs Google Sheets vs LibreOffice differ (XLOOKUP availability, ARRAYFORMULA, separators, some function names), so it tells you which it's assuming.

Crucially it's honest and verification-first: a formula that returns a plausible-but-wrong number is the most dangerous bug in a spreadsheet, so it explains the logic, tells you to TEST against a couple of rows you can check by hand and watch your edge cases (blanks, zeros, duplicates, no-match), and states which app/version it assumes rather than guaranteeing a paste-and-pray result; it treats your data as private and won't invent values.

From a cell full of `#REF!` to a formula you understand, trust, and can adapt.