Skip to search
The Formula Bar

Popular right now

one click to search

Browse & reference

open only what you need
Browse 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.