{"id":3329466,"date":"2025-09-26T08:24:00","date_gmt":"2025-09-26T06:24:00","guid":{"rendered":"http:\/\/nhub.news\/?p=3329466"},"modified":"2025-09-26T15:06:07","modified_gmt":"2025-09-26T13:06:07","slug":"forget-microsoft-excel-pain-google-sheets-can-now-tell-you-exactly-why-your-formulas-failed","status":"publish","type":"post","link":"http:\/\/nhub.news\/fr\/2025\/09\/forget-microsoft-excel-pain-google-sheets-can-now-tell-you-exactly-why-your-formulas-failed\/","title":{"rendered":"Forget Microsoft Excel pain &#8211; Google Sheets can now tell you exactly why your formulas failed"},"content":{"rendered":"<p style=\"text-align: justify;\"><b>Gemini will finally offer proper advice<\/b><br \/>\nGoogle is finally making Gemini help you with your formulas in Sheets<br \/>It\u2019ll understand what went wrong and take action to fix it<br \/>Gemini will also explain formulas to help you adapt them<br \/>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\u2019t working.<br \/>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.<br \/>\u201cWe&rsquo;ve upgraded Gemini to include detailed natural language formula explanations, provide formula error explanation and self-correction, and to output multiple formula options,\u201d Google explained in a blog post.Gemini will now help you with formulas<br \/>Gemini\u2019s formula understanding revolves around three key principles: natural language formula explanations; error explanation and self-correction; and multiple formula options.<br \/>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.<br \/>Then, Gemini can explain why a formula may have failed, such as \u201cthe date in A1 is formatted as text,\u201d before taking action to correct the underlying issue.<br \/>Finally, Google promises to generate multiple formula options for more complex tasks or when there are several ways to achieve a result.<br \/>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.<br \/>Consumers will also have access to the tools via their Google AI Pro and Ultra subscriptions.<br \/>Smart features and personalization need to be turned on from the admin console for business workers to get access. The main interface within the \u2018Ask Gemini\u2019 side panel is where users will then be able to tap into Gemini\u2019s formula understanding.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Gemini will finally offer proper advice Google is finally making Gemini help you with your formulas in SheetsIt\u2019ll understand what went wrong and take action to fix itGemini will also explain formulas to help you adapt themGoogle is finally using AI to help solve your biggest headache when using Google Sheets by infusing Gemini to [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":3329465,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[93],"tags":[],"_links":{"self":[{"href":"http:\/\/nhub.news\/fr\/wp-json\/wp\/v2\/posts\/3329466"}],"collection":[{"href":"http:\/\/nhub.news\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/nhub.news\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/nhub.news\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/nhub.news\/fr\/wp-json\/wp\/v2\/comments?post=3329466"}],"version-history":[{"count":0,"href":"http:\/\/nhub.news\/fr\/wp-json\/wp\/v2\/posts\/3329466\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/nhub.news\/fr\/wp-json\/wp\/v2\/media\/3329465"}],"wp:attachment":[{"href":"http:\/\/nhub.news\/fr\/wp-json\/wp\/v2\/media?parent=3329466"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/nhub.news\/fr\/wp-json\/wp\/v2\/categories?post=3329466"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/nhub.news\/fr\/wp-json\/wp\/v2\/tags?post=3329466"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}