Excel Formula Builder
Choose what you want to do, such as add up, count if, look up or join text, and fill in the cells. The page writes the formula, explains it and works out the result on the data you paste.
- Free, no sign-up
- Nothing is sent to a server
- Worldwide
How to use Excel Formula Builder online
- Choose a task. Pick from the list.
- Fill in the boxes. Cells, conditions, values.
- Paste sample data. To see the result.
- Copy the formula. Paste it into your sheet.
Why use this free Excel Formula Builder
- Twenty common tasks
- Plain-words explanation
- Live result on your data
- Works in Excel, Sheets and LibreOffice
- Correct quotes and brackets
Build it instead of remembering it
Most people know what they want from a sheet but not the exact formula. Pick a task from the list, for example add numbers that match a condition, and fill three boxes with the cells to test, the condition and the cells to add. The page writes the formula with the correct order of arguments and the right brackets and quotation marks.
See the result before you copy
Paste a few rows from your sheet, or a small CSV, and the page works out the formula on them with its own formula engine and shows the answer. If the result looks wrong, your cell references are probably off by a row, and you can fix them here before touching the real file. The first line you paste is row one.
The tasks
There are twenty tasks: SUM, AVERAGE, COUNT and COUNTA, MAX and MIN, SUMIF, COUNTIF and AVERAGEIF, VLOOKUP, XLOOKUP and INDEX with MATCH, IF and IFERROR, TEXTJOIN, percentage, ROUND, LEFT, TRIM and DATEDIF. Each task says what the three boxes mean and what the formula does in plain words.
Excel, Sheets and LibreOffice
The formulas use the same names and arguments in Microsoft Excel, Google Sheets and LibreOffice Calc. XLOOKUP needs a recent Excel or Google Sheets, so the page also offers INDEX with MATCH, which works in every version.
Limits
The formula engine of this page covers about sixty common functions, so the live result is only for those. It is a helper for writing formulas, not a full spreadsheet. Your data stays in your browser.
Using the tool
As you type in the Excel Formula Builder, the result appears at once. Use result as input to pass the answer to the next step.
Excel Formula Builder: frequently asked questions
Does the result use real Excel?
Why did I get an error message in the result?
Which is better, VLOOKUP or XLOOKUP?
Can I use the formula in Google Sheets?
Does the pasted data leave my computer?
Is the text I paste into the Excel Formula Builder uploaded?
Can I save what the Excel Formula Builder gives me?
Related searches for Excel Formula Builder
- Excel Formula Builder online
- free Excel Formula Builder
- Excel Formula Builder online free
- Excel Formula Builder for mobile
- Excel Formula Builder without sign up
- Excel Formula Builder – Date & Time
Excel Formula Builder is a free online tool on MAITBOX, in the Date & Time group. It runs in your browser, so what you type is not sent to a server. It works on Android and iPhone, and on Windows, Mac and Linux, with no download and no account.