Generate, explain, debug, validate, and compare formulas for Excel and Google Sheets. Create SQL queries, regex patterns, VBA macros, Google Apps Script, and Airtable scripts. Use Formula Genius when you need spreadsheet logic or automation help with clear, reviewable results inside ChatGPT.
Screenshots
How to use
- 1Add it in ChatGPT
Open Formula Genius in ChatGPT's Plugin directory (button above), select + to add it and sign in if asked.
- 2Use it in a chat
Type @ in the composer and pick Formula Genius, or start your message with its name. ChatGPT may also suggest it when it fits what you ask.
Things to ask
- “Debug this formula: =VLOOKUP(A2,B:C,3,FALSE). It returns #REF!”
- “Find the value of A2 in table E:H and return column 3”
- “Generate a PostgreSQL query to show total revenue by customer for orders pl”