Question: Is there a tool that can help me create complex Excel formulas from simple text prompts?

For turning natural language text prompts into more elaborate Excel formulas, FormulaGenerator is a powerful AI-based tool. It can generate formulas, spot and fix errors, and even create VBA code and SQL queries. A free tier with 10 requests per month is available, and a Premium Membership costs $4.99 per month. The site also offers a Google Sheets Add-on for in-spreadsheet formula generation and explanation.

Another good option is Formula Bot, which converts text prompts into a variety of outputs, including Excel formulas, SQL queries and VBA programming scripts. It includes tools like an Excel Formula Generator and Data Analyzer that let you ask natural language questions and generate results without having to write any code. Formula Bot has a variety of pricing options, including a free plan, so it can help you get more out of data analysis and automation.

ManyExcel also can help with a lot of tasks with its ability to generate formulas, regex patterns and scripts in a few seconds. Its AI Formula Generator can convert plain text into complex formulas with explanations, and it works with both Excel and Google Sheets. A free plan is available with limited use, and a Pro plan for $5 per month offers unlimited generations and other features.

If you want a Google Sheets add-on, SheetAI is a good option. It automates repetitive tasks and offers insights with AI-powered functions like SHEETAI_BRAIN for data storage and magic fills to quickly fill in data. SheetAI is available in three pricing plans, with the free plan offering 5 sheet formula generations and 50 function calls.