# AI Formula Generator for Excel and Google Sheets

> Describe a formula in plain English and get it for Excel or Google Sheets, run on real data in the Spreadsheet Practice formula engine before you see it, with its result, an explanation and the other app's version.

Source: https://spreadsheetpractice.com/tools/formula-generator · Updated October 29, 2026

## How it works

1. Describe the task, and optionally paste your table (headers in row 1).
2. AI writes the formula for your table's cells, or makes a small sample table for the request.
3. The engine runs it in Excel mode and Google Sheets mode. A formula that doesn't parse, uses a function the engine can't calculate, or returns an error is sent back to be fixed.
4. You see the formula, its result on the table, an explanation and checks for common slips. Open it at [AI Formula Generator](https://spreadsheetpractice.com/tools/formula-generator).

## Things to ask for

- Total the Units for the East region
- Look up the Price of a product typed in H1, and show "Not found" if it isn't there
- Give each student a letter grade from their score using the Min score and Grade table
- Clean up the names: remove extra spaces and capitalize each word
- Count the working days between an order date and a ship date, skipping weekends
- List each department once, sorted A to Z

## Generators by function

- [IF formula generator](https://spreadsheetpractice.com/tools/formula-generator/if)
- [SUMPRODUCT formula generator](https://spreadsheetpractice.com/tools/formula-generator/sumproduct)
- [XLOOKUP formula generator](https://spreadsheetpractice.com/tools/formula-generator/xlookup)
- [INDEX formula generator](https://spreadsheetpractice.com/tools/formula-generator/index)
- [MATCH formula generator](https://spreadsheetpractice.com/tools/formula-generator/match)
- [FILTER formula generator](https://spreadsheetpractice.com/tools/formula-generator/filter)
- [ARRAYFORMULA formula generator](https://spreadsheetpractice.com/tools/formula-generator/arrayformula)
- [COUNTIF formula generator](https://spreadsheetpractice.com/tools/formula-generator/countif)
- [SUM formula generator](https://spreadsheetpractice.com/tools/formula-generator/sum)
- [LEN formula generator](https://spreadsheetpractice.com/tools/formula-generator/len)
- [VLOOKUP formula generator](https://spreadsheetpractice.com/tools/formula-generator/vlookup)
- [SUBSTITUTE formula generator](https://spreadsheetpractice.com/tools/formula-generator/substitute)
- [TRIM formula generator](https://spreadsheetpractice.com/tools/formula-generator/trim)
- [LEFT formula generator](https://spreadsheetpractice.com/tools/formula-generator/left)
- [TEXT formula generator](https://spreadsheetpractice.com/tools/formula-generator/text)
- [SUMIF formula generator](https://spreadsheetpractice.com/tools/formula-generator/sumif)
- [ISNUMBER formula generator](https://spreadsheetpractice.com/tools/formula-generator/isnumber)
- [MID formula generator](https://spreadsheetpractice.com/tools/formula-generator/mid)
- [MOD formula generator](https://spreadsheetpractice.com/tools/formula-generator/mod)
- [MAX formula generator](https://spreadsheetpractice.com/tools/formula-generator/max)
- [COUNTIFS formula generator](https://spreadsheetpractice.com/tools/formula-generator/countifs)
- [IFERROR formula generator](https://spreadsheetpractice.com/tools/formula-generator/iferror)
- [SUMIFS formula generator](https://spreadsheetpractice.com/tools/formula-generator/sumifs)
- [SORT formula generator](https://spreadsheetpractice.com/tools/formula-generator/sort)
- [EOMONTH formula generator](https://spreadsheetpractice.com/tools/formula-generator/eomonth)
- [FIND formula generator](https://spreadsheetpractice.com/tools/formula-generator/find)
- [ROUND formula generator](https://spreadsheetpractice.com/tools/formula-generator/round)
- [SEQUENCE formula generator](https://spreadsheetpractice.com/tools/formula-generator/sequence)
- [INT formula generator](https://spreadsheetpractice.com/tools/formula-generator/int)
- [AVERAGE formula generator](https://spreadsheetpractice.com/tools/formula-generator/average)
- [DATE formula generator](https://spreadsheetpractice.com/tools/formula-generator/date)
- [LET formula generator](https://spreadsheetpractice.com/tools/formula-generator/let)
- [MIN formula generator](https://spreadsheetpractice.com/tools/formula-generator/min)
- [RIGHT formula generator](https://spreadsheetpractice.com/tools/formula-generator/right)
- [UNIQUE formula generator](https://spreadsheetpractice.com/tools/formula-generator/unique)
- [REGEXEXTRACT formula generator](https://spreadsheetpractice.com/tools/formula-generator/regexextract)
- [SEARCH formula generator](https://spreadsheetpractice.com/tools/formula-generator/search)
- [TEXTJOIN formula generator](https://spreadsheetpractice.com/tools/formula-generator/textjoin)
- [ROW formula generator](https://spreadsheetpractice.com/tools/formula-generator/row)
- [COUNT formula generator](https://spreadsheetpractice.com/tools/formula-generator/count)
- [REGEXREPLACE formula generator](https://spreadsheetpractice.com/tools/formula-generator/regexreplace)
- [TEXTAFTER formula generator](https://spreadsheetpractice.com/tools/formula-generator/textafter)
- [TEXTBEFORE formula generator](https://spreadsheetpractice.com/tools/formula-generator/textbefore)
- [AND formula generator](https://spreadsheetpractice.com/tools/formula-generator/and)
- [COUNTA formula generator](https://spreadsheetpractice.com/tools/formula-generator/counta)
- [MONTH formula generator](https://spreadsheetpractice.com/tools/formula-generator/month)
- [WEEKDAY formula generator](https://spreadsheetpractice.com/tools/formula-generator/weekday)
- [ABS formula generator](https://spreadsheetpractice.com/tools/formula-generator/abs)
- [CHAR formula generator](https://spreadsheetpractice.com/tools/formula-generator/char)
- [REGEXMATCH formula generator](https://spreadsheetpractice.com/tools/formula-generator/regexmatch)
- [SPLIT formula generator](https://spreadsheetpractice.com/tools/formula-generator/split)
- [TEXTSPLIT formula generator](https://spreadsheetpractice.com/tools/formula-generator/textsplit)
- [VALUE formula generator](https://spreadsheetpractice.com/tools/formula-generator/value)
- [EDATE formula generator](https://spreadsheetpractice.com/tools/formula-generator/edate)
- [YEAR formula generator](https://spreadsheetpractice.com/tools/formula-generator/year)
- [IFNA formula generator](https://spreadsheetpractice.com/tools/formula-generator/ifna)
- [CONCAT formula generator](https://spreadsheetpractice.com/tools/formula-generator/concat)
- [DATEVALUE formula generator](https://spreadsheetpractice.com/tools/formula-generator/datevalue)
- [MAXIFS formula generator](https://spreadsheetpractice.com/tools/formula-generator/maxifs)
- [ROWS formula generator](https://spreadsheetpractice.com/tools/formula-generator/rows)
- [LARGE formula generator](https://spreadsheetpractice.com/tools/formula-generator/large)
- [ROUNDUP formula generator](https://spreadsheetpractice.com/tools/formula-generator/roundup)
- [EXACT formula generator](https://spreadsheetpractice.com/tools/formula-generator/exact)
- [HSTACK formula generator](https://spreadsheetpractice.com/tools/formula-generator/hstack)
- [LOWER formula generator](https://spreadsheetpractice.com/tools/formula-generator/lower)
- [MINIFS formula generator](https://spreadsheetpractice.com/tools/formula-generator/minifs)
- [REPT formula generator](https://spreadsheetpractice.com/tools/formula-generator/rept)
- [TAKE formula generator](https://spreadsheetpractice.com/tools/formula-generator/take)
- [OR formula generator](https://spreadsheetpractice.com/tools/formula-generator/or)
- [WORKDAY formula generator](https://spreadsheetpractice.com/tools/formula-generator/workday)
- [DATEDIF formula generator](https://spreadsheetpractice.com/tools/formula-generator/datedif)
- [DAY formula generator](https://spreadsheetpractice.com/tools/formula-generator/day)
- [IFS formula generator](https://spreadsheetpractice.com/tools/formula-generator/ifs)
- [REPLACE formula generator](https://spreadsheetpractice.com/tools/formula-generator/replace)
- [SMALL formula generator](https://spreadsheetpractice.com/tools/formula-generator/small)
- [SORTBY formula generator](https://spreadsheetpractice.com/tools/formula-generator/sortby)
- [TRANSPOSE formula generator](https://spreadsheetpractice.com/tools/formula-generator/transpose)
- [CHOOSECOLS formula generator](https://spreadsheetpractice.com/tools/formula-generator/choosecols)
- [CHOOSEROWS formula generator](https://spreadsheetpractice.com/tools/formula-generator/chooserows)
- [UPPER formula generator](https://spreadsheetpractice.com/tools/formula-generator/upper)
- [VSTACK formula generator](https://spreadsheetpractice.com/tools/formula-generator/vstack)
- [AVERAGEIF formula generator](https://spreadsheetpractice.com/tools/formula-generator/averageif)
- [CHOOSE formula generator](https://spreadsheetpractice.com/tools/formula-generator/choose)
- [COLUMN formula generator](https://spreadsheetpractice.com/tools/formula-generator/column)
- [JOIN formula generator](https://spreadsheetpractice.com/tools/formula-generator/join)
- [NETWORKDAYS formula generator](https://spreadsheetpractice.com/tools/formula-generator/networkdays)
- [REGEXTEST formula generator](https://spreadsheetpractice.com/tools/formula-generator/regextest)
- [STDEV formula generator](https://spreadsheetpractice.com/tools/formula-generator/stdev)
- [XMATCH formula generator](https://spreadsheetpractice.com/tools/formula-generator/xmatch)
- [PMT formula generator](https://spreadsheetpractice.com/tools/formula-generator/pmt)
- [POWER formula generator](https://spreadsheetpractice.com/tools/formula-generator/power)
- [SQRT formula generator](https://spreadsheetpractice.com/tools/formula-generator/sqrt)
- [TRUNC formula generator](https://spreadsheetpractice.com/tools/formula-generator/trunc)
- [AVERAGEIFS formula generator](https://spreadsheetpractice.com/tools/formula-generator/averageifs)
- [CEILING formula generator](https://spreadsheetpractice.com/tools/formula-generator/ceiling)
- [COUNTUNIQUE formula generator](https://spreadsheetpractice.com/tools/formula-generator/countunique)
- [FV formula generator](https://spreadsheetpractice.com/tools/formula-generator/fv)
- [ISERROR formula generator](https://spreadsheetpractice.com/tools/formula-generator/iserror)
- [MEDIAN formula generator](https://spreadsheetpractice.com/tools/formula-generator/median)
- [NPER formula generator](https://spreadsheetpractice.com/tools/formula-generator/nper)
- [PV formula generator](https://spreadsheetpractice.com/tools/formula-generator/pv)
- [SWITCH formula generator](https://spreadsheetpractice.com/tools/formula-generator/switch)
- [TOCOL formula generator](https://spreadsheetpractice.com/tools/formula-generator/tocol)
- [CLEAN formula generator](https://spreadsheetpractice.com/tools/formula-generator/clean)
- [COLUMNS formula generator](https://spreadsheetpractice.com/tools/formula-generator/columns)
- [EXP formula generator](https://spreadsheetpractice.com/tools/formula-generator/exp)
- [ISBLANK formula generator](https://spreadsheetpractice.com/tools/formula-generator/isblank)
- [ISTEXT formula generator](https://spreadsheetpractice.com/tools/formula-generator/istext)
- [MROUND formula generator](https://spreadsheetpractice.com/tools/formula-generator/mround)
- [PRODUCT formula generator](https://spreadsheetpractice.com/tools/formula-generator/product)
- [PROPER formula generator](https://spreadsheetpractice.com/tools/formula-generator/proper)
- [RANK.EQ formula generator](https://spreadsheetpractice.com/tools/formula-generator/rank-eq)
- [ROUNDDOWN formula generator](https://spreadsheetpractice.com/tools/formula-generator/rounddown)
- [STDEV.P formula generator](https://spreadsheetpractice.com/tools/formula-generator/stdev-p)
- [TIMEVALUE formula generator](https://spreadsheetpractice.com/tools/formula-generator/timevalue)

## Questions

### How is this different from asking a chatbot for a formula?

A chatbot writes a formula and stops. This generator then runs it in a real formula engine, on your table or on a sample table made for your request, in both Excel and Google Sheets mode. If it returns an error, the error goes back to be fixed before you see anything. You get the formula with its calculated result, so you can check it does what you asked.

### Is it free?

Yes. 3 formulas a day without an account, 10 a day with a free account, and 200 a day with Pro, which also unlocks every lesson.

### Can it use my own data?

Yes. Choose "Paste my own" and paste cells copied from Excel or Google Sheets, with headers in row 1. The formula is written for your columns and tested on your rows. Your table is used only to write and test that formula and isn't stored.

### What does "Tested" mean?

The formula parsed, used only functions our engine can calculate, and returned a result without an error on the table shown. It does not mean it is the only way to do it, or that it matches what you meant: check the result against the table. "Tested and fixed" means the first draft failed the test and was corrected.

### Does it write Google Sheets formulas?

Yes. Choose Google Sheets, and every answer also gives the Excel version where there is one. When the two apps need different formulas, such as ARRAYFORMULA or QUERY in Sheets, you get both, each tested in its own mode.

### What if I want to understand the formula?

Every result links to the Formula Explainer, which calculates each part of the formula step by step, and to the lessons and practice exercises for the functions it uses.

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
