Gemini in Google Sheets can now explain and fix broken formulas (www.techradar.com)

Google has upgraded Gemini in Google Sheets to not only generate formulas but also explain and repair them: the assistant can provide plain‑English, step‑by‑step breakdowns of complex formulas, diagnose common errors (think #REF! or #VALUE!), point out issues like range mismatches or wrong data types (text vs. dates), and automatically propose corrected formulas or multiple alternative approaches. You can describe a goal in natural language — e.g., “count orders over $50 last month” — and Gemini will build the filter logic, time math and offer different formula options while explaining why each works. This improves productivity and reliability for both novice and experienced spreadsheet users by turning Sheets into a dynamic learning/debugging environment that reduces silent miscalculations and speeds troubleshooting. Technically, Gemini performs error analysis on cell references, ranges and types, suggests syntactically corrected expressions, and surfaces multiple valid implementations instead of a single black‑box output. The feature is live for Workspace users on Business Standard/Plus, Enterprise, and Google’s AI Pro/Ultra plans (look for the “Ask Gemini” spark icon). Limitations remain — it can struggle with poorly labeled or ambiguously structured sheets — but the update tightens Google’s competition with Excel Copilot and pushes AI-assisted, explainable tooling deeper into everyday workflows.