Menu
PDF Tools
Image Tools
Converters & Utilities
Seller & Print Tools
Accounting & Business
Calculators
Text & Writing Tools
Developer & Web Tools
Creator & Social Tools
Browser Utilities & Games
Document & Design Makers
Text & Developer Tools
Exam & Form Tools

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.

How to use Excel Formula Builder online

  1. Choose a task. Pick from the list.
  2. Fill in the boxes. Cells, conditions, values.
  3. Paste sample data. To see the result.
  4. 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?
No. The page works it out with its own formula engine for common functions, so the answer should match but check it in your sheet.
Why did I get an error message in the result?
A reference may point at the wrong cells. Row one is the first line you pasted, so a header counts as a row.
Which is better, VLOOKUP or XLOOKUP?
XLOOKUP is simpler and can look in any direction, but it needs a recent version. VLOOKUP works everywhere.
Can I use the formula in Google Sheets?
Yes. The functions on this page work the same there.
Does the pasted data leave my computer?
It is used in this tab only and goes nowhere else.
Is the text I paste into the Excel Formula Builder uploaded?
The Excel Formula Builder works locally, and clearing the site data removes anything the editor saved.
Can I save what the Excel Formula Builder gives me?
Press Use result as input and the Excel Formula Builder answer becomes the new input.

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.

More tools in Date & Time →

Search tools