# Free AI Formula Generator for Excel and Google Sheets URL: https://formula.dog/tools/ai-formula-generator Type: tool Locale: en Published: 2026-10-18 Updated: 2026-10-19 --- > Describe a spreadsheet job in plain English and get a working Excel or Google Sheets formula, with version notes and an older-Excel fallback. Free, no sign-up. *Free spreadsheet tool* ## Free AI Formula Generator for Excel and Sheets Describe the job in plain English. Biscuit fetches a working Excel or Google Sheets formula, with your own ranges filled in. ## Fetch a formula Type what you need, or pick a formula type. Change the ranges and the formula updates live. Copy it with one click. *[Interactive widget — see the live page for the full experience]* ## What happens when you type a sentence ### It reads your keywords Words like sum, how many, look up or percent point to a formula pattern. If it guesses wrong, the dropdown overrides it in one click. ### It fills in your ranges Each pattern has labelled fields for ranges, cells and conditions. Text goes in quotes, numbers stay bare, and cell references are left alone. ### It tells you where it works Every result lists the Excel and Sheets versions that support it, plus an older-Excel alternative when a modern function has one. *What it covers* ## Twelve everyday jobs, no guessing These are the formulas people search for most. Each one is a standard pattern, so the answer is the same one a spreadsheet expert would give you. Biscuit does not improvise here: a formula that looks right and returns the wrong number is worse than no formula. - SUMIF, SUMIFS, COUNTIF and AVERAGEIF - XLOOKUP with an INDEX and MATCH fallback - Percent change that avoids #DIV/0! - Days between two dates - TRIM and CLEAN for messy pasted data - Text before or after a dash, comma or any character - TEXTJOIN, UNIQUE and FILTER ## From sentence to cell in three steps 1. **Describe or pick** — Type something like count orders over 100, or choose the formula type from the list. 2. **Match your sheet** — Replace the example ranges with your own, for instance A2:A500 instead of A2:A100. Use cell references for conditions if you like. 3. **Copy and paste** — Press Copy formula, click a cell and paste. Check the result against a row you can verify by eye. That is how Biscuit double-checks too. ## Common questions about this formula generator ### Is this an AI formula generator or a template tool? Honest answer: it is a rule-based builder that reads your sentence for keywords like sum, count, look up or percent, then fills in a proven formula pattern with your ranges. There is no language model behind it, so it never invents a function. For jobs outside its list, Formula.dog is the AI version. ### Is it free, and do I need an account? Free, no sign-up, no limit. Everything runs in your browser, so your ranges and conditions never leave the page. ### Does the formula work in both Excel and Google Sheets? Each result has a Works in line. SUMIF, COUNTIF, AVERAGEIF, TRIM and the percent change formula work everywhere. XLOOKUP, UNIQUE and FILTER need Excel 365 or 2021, or Google Sheets. ### Why are there two formulas for some jobs? Many readers are still on Excel 2016 or 2019. Where a modern function has an older equivalent, such as INDEX and MATCH for XLOOKUP, the tool shows both so you can pick the one your version understands. ### Why does my formula show an error in my spreadsheet? Check three things: the ranges must match your real data, both ranges in a SUMIF need the same number of rows, and some locales use a semicolon instead of a comma between arguments. Swap the commas if your spreadsheet asks for it. ### Can it write nested IFs, array formulas or VBA? Not this one. It sticks to twelve common jobs so every answer is predictable. Formula.dog handles nested logic, LET, LAMBDA, ARRAYFORMULA and VBA from a plain-English description. ### Do I need to type exact keywords? No. Write it the way you would say it to a colleague. If the match is wrong, pick the formula type from the dropdown and the fields update straight away. ## Describe any spreadsheet problem and let Biscuit fetch it Formula.dog is the full AI version: nested logic, LET, LAMBDA, ARRAYFORMULA, VBA and regex from a plain-English description. The first five formulas a day are free. *Call to action: Try Formula.dog free* ## FAQ ### Is this an AI formula generator or a template tool? Honest answer: it is a rule-based builder that reads your sentence for keywords like sum, count, look up or percent, then fills in a proven formula pattern with your ranges. There is no language model behind it, so it never invents a function. For jobs outside its list, Formula.dog is the AI version. ### Is it free, and do I need an account? Free, no sign-up, no limit. Everything runs in your browser, so your ranges and conditions never leave the page. ### Does the formula work in both Excel and Google Sheets? Each result has a Works in line. SUMIF, COUNTIF, AVERAGEIF, TRIM and the percent change formula work everywhere. XLOOKUP, UNIQUE and FILTER need Excel 365 or 2021, or Google Sheets. ### Why are there two formulas for some jobs? Many readers are still on Excel 2016 or 2019. Where a modern function has an older equivalent, such as INDEX and MATCH for XLOOKUP, the tool shows both so you can pick the one your version understands. ### Why does my formula show an error in my spreadsheet? Check three things: the ranges must match your real data, both ranges in a SUMIF need the same number of rows, and some locales use a semicolon instead of a comma between arguments. Swap the commas if your spreadsheet asks for it. ### Can it write nested IFs, array formulas or VBA? Not this one. It sticks to twelve common jobs so every answer is predictable. Formula.dog handles nested logic, LET, LAMBDA, ARRAYFORMULA and VBA from a plain-English description. ### Do I need to type exact keywords? No. Write it the way you would say it to a colleague. If the match is wrong, pick the formula type from the dropdown and the fields update straight away.