Formula Generator Online
Describe it and get the Excel/Sheets formula. Works in your browser, no install needed.
Included in CeevTech Pro. Every new account gets a 30-day Pro trial, no credit card required.
How to use Formula Generator
Describe the calculation in plain English, naming columns like "column B".
Choose Excel or Google Sheets as the target.
Click Build Formula, then Copy to paste it into your sheet.
Why use CeevTech Formula Generator?
Know what you want your spreadsheet to calculate but not the exact formula? CeevTech Formula Generator turns a plain-English description like "sum column B where column A equals Paris" into a ready Excel or Google Sheets formula. It recognizes common patterns including SUM, SUMIF, COUNTIF, AVERAGE, VLOOKUP, IF, MAX, MIN, ROUND, percentages, joining text and today's date, and explains what each formula does.
- Fast: processes your text or prompt in seconds.
- Private: runs in your browser, so nothing is uploaded.
- Works everywhere: desktop, tablet and phone, in any modern browser.
- One account, 79+ tools: PDF, image, office, AI, developer and business tools in one place.
Frequently asked questions
How should I phrase my request?
Mention column letters (for example "column A" and "column B") and put any value to match in quotes, such as: sum column B where column A equals "Paris". The tool uses rows 2 to 1000 as the default range, which you can adjust.
What if it does not understand my description?
It recognizes a set of common patterns. If none match, it returns a starting SUM formula and suggests clearer phrasing.
Is Formula Generator free?
Included in CeevTech Pro. Every new account gets a 30-day Pro trial, no credit card required.
Do I need to install anything?
No. Formula Generator runs online in your browser on Windows, Mac, Linux, Android and iPhone.
Is my data private?
Yes. Formula Generator runs entirely in your browser, so your data never leaves your device.