Type what you want to calculate and get the formula, explained.
Formula Generator for Excel & Sheets writes the formula for what you want to calculate, in Excel or Google Sheets, from a plain-English description, then explains what each part does, with a worked example if you want one. It handles lookups, conditional sums, date maths and text clean-up.
In “What should it calculate?”, name the columns and the condition, for example sum column C where column A is North and the date in column B is this month.
Under “App”, choose “Excel” or “Google Sheets”, since some functions differ between them.
Check the price above “Write the formula”, then press it or Ctrl+Enter (⌘+Enter on a Mac).
Press “Copy formula” and paste it into your sheet. The explanation under it says what each part does; results save to your history.
1 credit per use
New accounts get 10 free credits to try QikTools, valid for 7 days, with no card needed.
See plans and credit pricesEach formula has one price, shown above “Write the formula” before you run.
Every price is shown on the button before anything runs, and every plan pays the same number of credits for a run. If a run fails on our side, its credits go back automatically.
Yes. Choose “Google Sheets” under “App” and the formula uses its functions.
Every result comes with an explanation of what each part does, and a worked example when that option is on.
Pricing: 1 credit per use. The exact price is shown before anything runs, and new accounts get 10 free credits to try QikTools (valid for 7 days, no card needed). Plans and top-ups are on the pricing page.
They go back automatically. The one exception: if a request passes our safety checks but the AI provider's own safety system refuses it and charges us for the attempt, the credits for that run are kept (Terms).
You own your inputs and, as far as the law and our AI providers' terms allow, what you create, including for commercial use. QikTools doesn't sell your data or train AI models on your content; some AI providers' own terms let them use what they receive (Privacy Policy). Settings → Profile has Download my data and Delete account, which removes your account, projects and uploads.
One account, one credit balance, 59 AI tools and studios.
Start free — no card needed