Gemini in Google Sheets is now a formula-writing genius that explains its own work

For many of us, writing complex spreadsheet formulas can feel like learning a new language. It can be an intimidating and frustrating process of trial and error. In a fantastic new update, Google is making that process a whole lot easier by rolling out a significant upgrade to formula generation in Gemini for Sheets. This new version isn’t just smarter at writing formulas; it can now explain how they work and even fix them when they break.

Your personal AI formula tutor

The first part of this upgrade turns Gemini into your personal formula tutor. Now, when you ask Gemini to generate a complex formula, it can also return a detailed, step-by-step explanation of how the formula works. This is a huge learning tool that helps you understand the logic behind the calculation, making it easier for you to trust the result and adapt the formula for future use.

An AI that can explain and fix formula errors

This next part is a game-changer for anyone who has ever stared at a #REF! or #VALUE! error in frustration. Gemini can now explain why a formula failed in plain, natural language (e.g., “the date in A1 is formatted as text”).

Even better, in a follow-up turn, it can use that error message to generate a corrected formula that solves the underlying issue. This interactive troubleshooting will save users a massive amount of time and headaches.

More than one way to solve a problem

Finally, for more complex tasks where there might be several ways to get the same result, Gemini can now provide you with multiple different formula options. This gives you more flexibility and control over how your spreadsheet works.

This is a fantastic set of upgrades that makes Gemini in Sheets an even more powerful and accessible tool. The focus on not just generating formulas but also helping users understand and troubleshoot them is a brilliant move. The best part is this update is already available for all eligible users, which includes most paid Workspace subscribers, Google AI Pro for Education users, and Google AI Pro and Ultra subscribers.