How to use the Excel Formula Generator
- 1. Pick a taskChoose what you want: a lookup, a conditional sum, a grade, a date difference and more.
- 2. Point at your cellsType your own ranges and cells, or keep the example ones to try it.
- 3. Copy the formulaGet the formula, how it works, and an older-Excel alternative where one is needed.
What it can build
The generator covers the formulas people search for most. Lookups use XLOOKUP, two-way INDEX/MATCH, and an INDEX/MATCH fallback for older versions. Conditional maths uses SUMIFS, COUNTIFS and AVERAGEIFS with up to three conditions, including "contains" and "starts with". There are grade bands with IFS (or nested IF), percentage change, share of total, running totals, rank and duplicate flags. Text tasks cover TEXTJOIN, first and last names, and clean-up with TRIM, CLEAN and PROPER. Date tasks cover DATEDIF ages and working days with NETWORKDAYS (including a six-day week). It also does UNIQUE, SORT and FILTER spill formulas, and loan EMI with PMT.
Examples use a small sample sheet in A1:G11: Order ID, Date, Region, Product, Units, Revenue and Customer for 10 orders.
Worked example
With the default lookup task, cell H2 holding the order ID O-1005, the search column A2:A11 and the return column F2:F11, the tool writes =XLOOKUP(H2, A2:A11, F2:F11, "Not found"), which returns 1,59,000, that order's revenue. It also gives =IFERROR(INDEX(F2:F11, MATCH(H2, A2:A11, 0)), "Not found") for Excel 2016 and 2019. For North-region laptop revenue, the SUMIFS task writes =SUMIFS(F2:F11, C2:C11, "North", D2:D11, "Laptop"), which gives 1,04,000.
How we checked the formulas
- We built every task, with every option, on the sample sheet.
- LibreOffice recalculated 90 of them and gave the expected answer each time.
- The other 10 use Microsoft 365-only functions (XLOOKUP, TEXTBEFORE, TEXTAFTER, UNIQUE, SORT, FILTER), so we checked those with an independent Excel-formula engine instead.
- Formulas use commas between arguments, as in English (India) Excel; some European settings need semicolons.
Frequently asked questions
Which Excel version do I need?
Most formulas work in Excel 2010 and later. XLOOKUP, UNIQUE, SORT, FILTER, TEXTBEFORE and TEXTAFTER need Excel 2021 or Microsoft 365; the tool says so and gives an alternative where there is one.
Does it read my spreadsheet?
No. You type the cell references; nothing is uploaded.
Is the Excel formula generator free?
Yes. You can open the Excel formula generator and use it without signing up. When you generate a formula for the first time, we ask once for your name and WhatsApp number; after that it, and every other Uncodemy tool, opens straight away.