What do you want to do in Excel?
Describe the job in plain English. You don't need to remember the function name.
250+ functions — ready-made task answers Excel 2021 & 365 checked
Popular right now
one click to searchBrowse & reference
open only what you needBrowse all functions
Twelve levels, beginner to expert. Search is faster — this is for when you want to read around a topic.
How to use this 1 min
Search by what you want, not what it's called
- Type the outcome — age, last name, quarter, working days, running total.
- Or the job — find duplicates, sum by region, count males, rank students.
- Or a business word — EMI, GST, margin, discount, CAGR.
- Function names work too, if you already know them.
Reading the formulas
- Square brackets mean optional. In
=SUM(number1, [number2], ...)only the first argument is required. You never type the brackets — they are notation. - Set your Excel version at the top. Results then never recommend a function your Excel cannot run.
- Separators. Formulas here use commas. If your Windows region uses a comma for decimals, Excel expects semicolons instead:
=SUM(A1;B1). Names and argument order never change. - This is Excel, not Google Sheets. Nothing here relies on Sheets-only functions.
Keyboard
- Ctrl/⌘ + K or / — jump to search
- ↓ ↑ — move through results · Enter — copy the highlighted formula
- Esc — clear the search
Excel version support what runs where
Functions people confuse 13 pairs
Fix an Excel error #N/A, #VALUE!, #SPILL!…
Learning roadmap beginner → expert
Quick-reference table every function
About what this is
The Formula Bar is a searchable Excel formula handbook. You describe the job; it gives you the formula, what each argument means, and whether it runs in your version of Excel.
It is one static HTML page — no accounts, no tracking, no backend. Everything runs in your browser, so it works offline once loaded.
Formulas were checked against Microsoft's documentation, and the financial examples were computed rather than estimated. Found something wrong? That's worth fixing — accuracy matters more than polish here.