By Craig Hale

Copyright techradar

Skip to main content

Tech Radar Pro

Tech Radar Gaming

Close main menu

the business technology experts

België (Nederlands)

Deutschland

North America

US (English)

Australasia

New Zealand

View Profile

Search TechRadar

Expert Insights

Website builders

Web hosting

Best web hosting
Best office chairs
Best website builder
Best antivirus
Expert Insights

Don’t miss these

Gemini in Google Sheets can now explain and fix broken formulas

Gemini is coming to solve all your Google Meet meeting issues – whether you want it or not

Gemini Live can now coordinate your outfit and remind you – in a calm voice – when it’s time to leave

Google just announced 5 new Gemini features coming to Android, and it’s good news for fans of foldable smartphones

Gemini is coming to Chrome on desktop starting today for Pro and Ultra users in the U.S.

Gemini just got a new highly-requested feature that trumps ChatGPT

Google AI Mode is getting a bigger AI brain from Gemini

Google Drive might finally be able to understand your PDFs a little better

Google Gemini is set to become a significantly better phone assistant thanks to these two small upgrades

I used Google Gemini to analyze YouTube, and the results were seriously impressive – 4 ways you can use video integration to get the most from AI

Ever wanted to listen to your Google Docs? Well good news – you finally can, thanks to Gemini

Google Gemini’s new Guided Learning mode makes you smarter – one question at a time

Google Gemini and GitHub are teaming up for AI-powered coding

How to share your Gemini Gems custom AI experts with all your friends

Gemini is about to remember everything, unless you tell it not to

Forget Microsoft Excel pain – Google Sheets can now tell you exactly why your formulas failed

Craig Hale

26 September 2025

Gemini will finally offer proper advice

When you purchase through links on our site, we may earn an affiliate commission. Here’s how it works.

(Image credit: Google)

Google is finally making Gemini help you with your formulas in Sheets
It’ll understand what went wrong and take action to fix it
Gemini will also explain formulas to help you adapt them

Google is finally using AI to help solve your biggest headache when using Google Sheets by infusing Gemini to tell you exactly why your formulas aren’t working.

After the launch of other aids in its spreadsheet software, Google says Gemini will finally be used to suggest formulas, explain how they work, and why they fail, providing step-by-step explanations to make formulas easier to understand.
“We’ve upgraded Gemini to include detailed natural language formula explanations, provide formula error explanation and self-correction, and to output multiple formula options,” Google explained in a blog post.

You may like

Gemini in Google Sheets can now explain and fix broken formulas

Gemini is coming to solve all your Google Meet meeting issues – whether you want it or not

Gemini Live can now coordinate your outfit and remind you – in a calm voice – when it’s time to leave

Gemini will now help you with formulas
Gemini’s formula understanding revolves around three key principles: natural language formula explanations; error explanation and self-correction; and multiple formula options.

Firstly, detailed explanations of how formulas work makes it easier to learn and adapt them for future use, which Google says improves understanding and builds trust.
Then, Gemini can explain why a formula may have failed, such as “the date in A1 is formatted as text,” before taking action to correct the underlying issue.
Finally, Google promises to generate multiple formula options for more complex tasks or when there are several ways to achieve a result.

Are you a pro? Subscribe to our newsletter
Sign up to the TechRadar Pro newsletter to get all the top news, opinion, features and guidance your business needs to succeed!
Contact me with news and offers from other Future brandsReceive email from us on behalf of our trusted partners or sponsorsBy submitting your information you agree to the Terms & Conditions and Privacy Policy and are aged 16 or over.
The much-needed inclusion of formula assistance is coming to Google Workspace Business Standard and Plus accounts, Enterprise Standard and Plus, and Google AI Pro for Education.
Consumers will also have access to the tools via their Google AI Pro and Ultra subscriptions.
Smart features and personalization need to be turned on from the admin console for business workers to get access. The main interface within the ‘Ask Gemini’ side panel is where users will then be able to tap into Gemini’s formula understanding.
You might also like

We’ve listed the best productivity tools from Google and its alternatives
Gemini is coming to Google TV – now your big screen can actually talk back
Check out the best AI tools and best AI writers

Google Sheets

With several years’ experience freelancing in tech and automotive circles, Craig’s specific interests lie in technology that is designed to better our lives, including AI and ML, productivity aids, and smart fitness. He is also passionate about cars and the decarbonisation of personal transportation. As an avid bargain-hunter, you can be sure that any deal Craig finds is top value!

You must confirm your public display name before commenting

Please logout and then login again, you will then be prompted to enter your display name.

Gemini in Google Sheets can now explain and fix broken formulas

Gemini is coming to solve all your Google Meet meeting issues – whether you want it or not

Gemini Live can now coordinate your outfit and remind you – in a calm voice – when it’s time to leave

Google just announced 5 new Gemini features coming to Android, and it’s good news for fans of foldable smartphones

Gemini is coming to Chrome on desktop starting today for Pro and Ultra users in the U.S.

Gemini just got a new highly-requested feature that trumps ChatGPT

Latest in Pro

Is the cultural integration of AI possible?

Dell is launching its own earbuds specifically designed for video calls – but will they even come close to Apple AirPods?

Vernal Standing Desk review

Google reminds regulators it complained about Microsoft’s cloud practices a year ago – but says nothing has been done

Intel reportedly approached Apple, TSMC for investment before Nvidia deal

Timeless inclusive design techniques for a world of agentic AI

Latest in News

How to watch Power Book IV: Force season 3 online — when is it coming out?

Hands-on video leak reveals Samsung Galaxy One UI 8.5 – and it’s borrowing a handy iPhone trick

This viral app paid users to sell their private phone calls to AI firms – now it’s offline after a shocking data breach

Peacemaker season 2 episode 6’s big cameo is the perfect set up for Man of Tomorrow

Bowser (no, not that one) will retire from Nintendo at the end of the year

Forget Microsoft Excel pain – Google Sheets can now tell you exactly why your formulas failed

LATEST ARTICLES

Apple says iPhone 17 Pro ‘scratchgate’ debate is overblown – and explains why in-store phones are scuff magnets

This viral app paid users to sell their private phone calls to AI firms – now it’s offline after a shocking data breach

Gemini in Google Sheets can now explain and fix broken formulas

The four-star Ring Video Doorbell Pro tumbles to a record-low price

Dell is launching its own earbuds specifically designed for video calls – but will they even come close to Apple AirPods?

TechRadar is part of Future US Inc, an international media group and leading digital publisher. Visit our corporate site.

Contact Future’s experts

Terms and conditions

Privacy policy

Cookies policy

Advertise with us

Web notifications

Accessibility Statement

Future US, Inc. Full 7th Floor, 130 West 42nd Street,

Please login or signup to comment

Please wait…