About Excel formula generator
Most people know what they want from a spreadsheet, such as one branch's sales last month, but forget the function name and the order of its arguments. Here you describe the task in plain English or Arabic and can list your columns, for example A = date, B = branch, C = sales. You get a formula ready to copy, the cell to put it in, and a short explanation of each part.
There are three modes. Formula writes for Excel or Google Sheets with the separator you pick (comma , or semicolon ;). Macro writes VBA for Excel or Apps Script for Google Sheets, with comments and setup steps. Explain walks through a formula you already have, step by step. Every run costs 1 credit, shown on the button before you press it. A new account gets 2 free credits once the email is confirmed, so you can try it on your own sheet before paying anything.
Why use it
- Ask in English or Arabic and get a formula with the standard function names Excel and Google Sheets understand.
- Choose the app and the argument separator, so the formula pastes into your file without fixing commas by hand.
- Three modes on one page: Formula, Macro (VBA or Apps Script) and Explain for formulas you already have.
- A fixed price of 1 credit per run shown on the button, and an automatic refund if a run fails.
- We do not store your description or the result; we log only the date, size, mode and credits used.
How to use
Sign in
Press “Sign in and try it free” and type your email to get a one-time sign-in link, or continue with Google. New accounts get 2 credits after confirming the email.
Pick a mode and an app
Choose Formula, Macro or Explain, then Excel or Google Sheets. In Formula mode, pick the separator your file uses: comma , or semicolon ;.
Describe the task clearly
Write up to 400 words. Name the columns, what they hold and where the data starts, for example “data in rows 2 to 500, A is the date, B is the branch”. In Explain mode, paste the formula itself.
Run it and test on a copy
Press the run button, wait a few seconds and copy the result. Try the formula or macro on a copy of the file first, and check it against rows whose answer you already know.
Examples
Branch sales between two dates
Request: “Sum sales in C for the branch in F3 between the dates in F1 and F2; dates are in A and branches in B.” Result: =SUMIFS(C2:C500, A2:A500, ">="&F1, A2:A500, "<="&F2, B2:B500, F3) with a note that each condition follows its range and that & joins the comparison to the cell.
Look up a price on another sheet
Request: “Find the product code in A2 on the Products sheet, return the price from column C, and show Not found if it is missing.” Result: =IFERROR(XLOOKUP(A2, Products!A:A, Products!C:C), "Not found") with a note that XLOOKUP needs Excel 2021 or Microsoft 365, plus a VLOOKUP version for older Excel.
Attendance days per employee
Request: “A has employee names and B has Present or Absent; count present days for the name in E2.” Result: =COUNTIFS(A2:A200, E2, B2:B200, "Present") to fill down beside your list of names, with a reminder that the word Present must be spelled the same way in the sheet.
A macro that splits a sheet by branch
In Macro mode you ask: “Create one sheet per branch in column B and copy its rows there.” You get commented VBA that loops through the branches and copies rows with AutoFilter, plus steps to paste it in the VBA editor and save the file as .xlsm. For Google Sheets you can ask for Apps Script that emails a summary of the sheet with MailApp.sendEmail.
| Task | Mode | What the tool usually uses |
|---|---|---|
| Sum or average with conditions such as branch and date | Formula | SUMIFS, AVERAGEIFS |
| Pull a value from another table | Formula | XLOOKUP, INDEX with MATCH, VLOOKUP with IFERROR |
| Count attendance and orders by condition | Formula | COUNTIFS, COUNTIF |
| Split sheets, email reports, repeat a daily task | Macro | VBA in Excel, Apps Script in Google Sheets |
| Understand a long formula from an old file | Explain | A step-by-step breakdown, likely errors and a simpler alternative |
Tips
- Name the columns, the data range and the sheet; a precise description gives a formula that works first time.
- Describe columns instead of pasting data: “B holds customer names” is enough, the tool does not need the names.
- If you see an error such as #NAME?, check the separator you chose and your Excel version, then ask for an alternative that fits it.
- Run any macro on a copy of the file first, and read the comments in the code to see what it will change.
- Use Explain mode before editing an old formula, so you know which part actually needs to change.
Your description or formula travels over an encrypted connection to our server and then to the AI model provider for processing, and the result comes straight back to you. We do not keep the text or the result in our database. We record only the time, the text size, the mode, the credits used and the processing cost, so we can show your usage history and keep our accounts.
Frequently asked questions
Is the tool free?
It runs on credits, because every run costs us AI processing. A new account gets 2 free credits after confirming the email, which is enough for two runs.
How much does one run cost?
Every run in any mode costs 1 credit, and one credit is $0.05. Pay as you go from $5 (100 credits), or pick a pack: $10 = 220 credits, $15 = 345 credits and $25 = 600 credits. You buy them once; there is no subscription.
What happens if a run fails?
Credits are taken when the run starts. If it fails for any reason on our side or at the AI provider, the credit goes back to your account automatically and the refund appears in your history. If the run works but the formula is not what you meant, adjust your description and run it again.
What are the limits?
A description or formula can be up to 400 words per run. The tool does not open your file or read your data; it relies on how you describe the columns, and it can make mistakes, so test the result on a copy of your data before you rely on it.
Can I ask in Arabic?
Yes. Write the request in English or Arabic; the formula uses the standard English function names and the explanation follows the page language. Arabic text inside the formula, such as a branch name, is fine.
Will the formula work in Excel with an Arabic interface?
In most Arabic-interface versions of Excel the function names stay in English, such as SUMIFS and COUNTIFS, so the formula works as it is. What usually differs is the argument separator, which is why you pick it before running.
When should I use a comma and when a semicolon?
It depends on the regional settings of your computer or file. If decimals are written with a comma where you are, the argument separator is usually a semicolon ;. The quickest check: type =SUM( in a cell and look at the hint that appears.
How do Excel and Google Sheets results differ?
Most common functions are the same, but Google Sheets has functions such as QUERY and ARRAYFORMULA, and some newer Excel functions do not work in older versions. That is why the tool writes for the app you choose. In Google Sheets the separator follows the spreadsheet locale under File, then Settings.
Is running a macro safe?
A macro is code that changes your file, so only run code you understand and that comes from a source you trust, and test it on a copy. In Excel, save the file as .xlsm and press Enable Content when you open it. In Google Sheets, Apps Script asks for permission on the first run; read the permissions before you accept.
Do you keep what I type? Should I paste my data?
We do not keep the description or the result; we log only the size, mode, credits and time of the run, and the text passes through the AI provider to be processed. Do not paste personal or confidential data such as salaries or ID numbers. Describe the columns instead; the tool does not need the data itself.
How do I buy credits?
On the My credits page, pick a pack and pay through our Gumroad store, PayPal, USDT on TRON (TRC20) or USDC on Solana. Refund details are on the refund policy page, and you can reach us at support@adwaty.net.
Do credits expire?
Purchased credits are valid for one year from the date of purchase, and free trial credits for 30 days. The My credits page shows when each batch expires, and the credits terms page has the details.
Last updated: