Credit: Edgar Cervantes / Android AuthorityTL;DRGemini in Google Sheets will now be able to diagnose and fix formula errors.The AI will explain the issue with the formula and provide the correct version.This functionality will be available for Google AI Pro and Ultra users.How many times have you entered a formula into a spreadsheet only to see an error message? Sometimes you can spot the error right away, other times you may have no idea what went wrong. Google is rolling out a new capability in Sheets that should solve this problem.In a blog post, Google announced that Gemini in Sheets will now be able to diagnose and fix formula errors. The next time you see an error, one click will get Gemini to generate an explanation of the core problem. It will also provide you with a corrected version of the formula.