Free tool
Describe what you want in plain English — "sum column B where the month in A is January" — and get a working Excel formula with a short explanation. It's free, powered by AI, and needs no signup.
Free · no signup · a few free generations per day.
Type what the formula should do in plain English — the columns involved, the condition, and the result you want back. No syntax to remember.
The generator picks the right function — SUMIFS, XLOOKUP, IFERROR, TEXTBEFORE and friends — and returns a ready-to-paste formula with a short plain-English explanation.
Hit Copy formula, paste it into Excel or Google Sheets, and adjust the cell references to match your ranges. Done in seconds.
Eight common asks and the real Excel formulas that answer them. Swap the cell references for your own ranges.
=SUMIFS(B:B, A:A, "January", C:C, "UAE")
SUMIFS totals a range against one or more conditions — add more criteria pairs as needed.
=XLOOKUP(A2, Products!A:A, Products!C:C, "Not found")
Classic alternative: =VLOOKUP(A2, Products!A:C, 3, FALSE) — XLOOKUP is safer because it needs no column index.
=IFERROR(B2/C2, "")
IFERROR wraps any formula and replaces errors with the value you choose.
=TEXTBEFORE(A2, "-") | =TEXTAFTER(A2, "-")
Available in Microsoft 365 / Excel 2021+. Older versions: use LEFT/FIND and MID/FIND.
=COUNTA(UNIQUE(A2:A1000))
UNIQUE spills the distinct values; COUNTA tallies them. Requires dynamic arrays (365 / 2021+).
=DATEDIF(A2, B2, "m")
Use "y" for whole years or "d" for days. DATEDIF is undocumented but works in every modern Excel.
=RANK.EQ(B2, $B$2:$B$100, 0)
The 0 ranks largest-first; use 1 for smallest-first. RANK.EQ gives ties the same rank.
=(B2-A2)/A2
Format the cell as a percentage. Guard against a zero prior value with =IFERROR((B2-A2)/A2, "").
This free page hands you a formula to copy. HISAB 360 goes further: the Excel add-in writes formulas directly into your sheet, aware of your headers and ranges, so there's nothing to paste or re-reference. Ask in plain English and the answer lands in the cell you're standing on — then keep going with offline Python automation for the heavy lifting, ERP connectors that pull live data in, and VBA generation that turns repeated work into one-click commands.
Because HISAB lets you bring your own AI — plug in your existing Claude or ChatGPT subscription or API key — there's no per-generation markup or hidden cost on top of what you already pay the AI provider. See the full feature set, run real Python in Excel locally, or follow the step-by-step tutorials. Need a whole macro instead of a single formula? Try the VBA macro generator.
Yes. Generating formulas on this page is completely free. There's a small daily limit to keep the service available for everyone, but there is no charge and no card required.
No. You can type a request and get a formula without creating an account or logging in. Signup is only needed if you want the full HISAB 360 add-in inside Excel.
Core functions like SUMIFS, VLOOKUP, IFERROR, DATEDIF and RANK.EQ work in Excel 2016 and later, and in Google Sheets. Newer functions such as XLOOKUP, UNIQUE, TEXTBEFORE and TEXTAFTER need Microsoft 365 or Excel 2021+ — the tool will note when that applies.
No spreadsheet data is involved — you only type a plain-English description of the formula you need, and we don't store your prompts to build a profile. Nothing from your workbook is uploaded here.
The free generator allows a handful of formula generations per day per visitor. If you hit the limit you'll see a message and can come back tomorrow — or install HISAB 360 and use your own AI key for unlimited formulas written straight into your sheet.
Install HISAB 360 and let AI build formulas, run Python and reconcile your ERP — right inside Excel. 15-day free trial, no credit card.
Download HISAB 360