Excel Formulas
Lookup, round, count, text — the formulas that come up, with examples that work.
Sixty that cover most work
Lookup, count, sum with conditions, text handling and rounding account for the bulk of what a spreadsheet is asked to do. The list is deliberately short: a thousand functions is a reference manual, not a help page.
Arguments and separators
The examples use commas, which is the US convention. A European Excel expects semicolons, and a file moved between the two will refuse to calculate until the separators are fixed.
Modern functions
XLOOKUP, FILTER, SORT and UNIQUE only exist in newer versions and in Excel 365. They are included because they replace formulas that used to be three lines long, but an older file will show #NAME? instead.
Good to know
Function names are not case sensitive, and Excel will add the closing brackets if you forget them. What it will not fix is a comma where a semicolon belongs, which is the most common reason a pasted formula fails.
How Excel Formulas works
Sixty of the formulas people actually need, with an example and a one-line explanation, searchable. The method behind Excel Formulas is the single-purpose logic inside wave55.js, and this page shows the result with its assumptions in the open.
- Open Excel Formulas and provide excel formulas — the page accepts it in the field it shows.
- For Excel Formulas, grades and dates are computed with the standard formulas and the working is shown.
- The Excel Formulas output appears on the page and can be copied or downloaded in the format it offers; nothing is kept afterwards.
A worked example for Excel Formulas
A typical run of Excel Formulas starts with excel formulas and ends with the result shown above; the page reports what it did in plain words so the output can be checked against a known-good case before it matters.
Check one term you already know the grade for — if the cumulative figure matches, the weighting is being applied the way your institution does it. That check applies directly to Excel Formulas with excel formulas.
When to use Excel Formulas — and when not to
Reasonable uses: Checking a GPA before an application; Planning a study week; Printing a practice sheet. Excel Formulas is deliberately narrow: it does one job and states its assumptions instead of hiding them.
Student portals show official grades but rarely let you model a what-if. That modelling is the whole point here. The honest ceiling for Excel Formulas: for Excel Formulas, institutions publish their own conversion tables — theirs wins.
- Best case for Excel Formulas: Checking a GPA before an application
- Also fine with Excel Formulas: Planning a study week
- Not what Excel Formulas is for: for Excel Formulas, institutions publish their own conversion tables — theirs wins.
Reading the Excel Formulas result
The output of Excel Formulas is a function of the inputs alone — no hidden state and no server.
Accuracy and limits of Excel Formulas
The method is the single-purpose logic inside wave55.js. Excel Formulas prints results at the precision its inputs justify, and the limits below are the honest ones:
- Excel Formulas: For Excel Formulas, institutions publish their own conversion tables — theirs wins.
- For Excel Formulas, estimates for page counts and reading time are stated as estimates.
Privacy and speed on the Excel Formulas page
The Excel Formulas page is a static file plus wave55.js; there is no upload endpoint behind it, so your input cannot be stored or logged. Closing the tab discards the work.
Speed follows the build: Excel Formulas loads one stylesheet and one script, with no framework, no web font and no tracker. That is why the tool responds as you type instead of waiting on a round trip.
What you get from Excel Formulas
The output of Excel Formulas appears on this page and can be copied or downloaded in the format the page offers. Nothing is queued, nothing is emailed, and there is no usage counter — the education work finishes the moment the numbers are in.
Because Excel Formulas is built from wave55.js rather than a server call, the practical ceiling is your device: memory for large inputs, and CPU for anything that loops over pixels or pages. On a normal laptop that ceiling sits far above everyday use; on an old phone it arrives sooner, and the page tells you when a job is too big instead of failing silently.
Questions
What does Excel Formulas do?
Sixty of the formulas people actually need, with an example and a one-line explanation, searchable. Everything runs in your browser; nothing is uploaded.
How accurate is Excel Formulas?
The method is the single-purpose logic inside wave55.js. For Excel Formulas, institutions publish their own conversion tables — theirs wins.
What are the limits of Excel Formulas?
For Excel Formulas, estimates for page counts and reading time are stated as estimates.
Is anything uploaded when I use Excel Formulas?
No. Excel Formulas runs entirely in the browser tab; nothing is uploaded, stored or logged.
Can I use Excel Formulas offline?
Yes — Excel Formulas keeps working offline once the page has loaded; the whole tool is a local script.
Keep going
More education tools
Word Finder
Find English words from letters you have, with blanks, starts-with, contains and ends-with filters. Dictionary runs in your browser.
Open toolCrossword Solver
Stuck on a crossword? Enter known letters with ? for blanks and the length; matching English words appear instantly.
Open toolScrabble Word Finder
Enter your tiles and get every dictionary word they can form, sorted by Scrabble score — plus the score of each word.
Open toolCGPA Calculator
Calculate CGPA from every semester's credit hours and GPA: weighted correctly, with totals and room for eight terms.
Open toolGPA to Percentage
Convert GPA to percentage on the 4.0, 5.0 or 10-point scale — with each scale's standard formula shown and its limits stated.
Open toolAttendance Calculator
Enter classes held and attended plus your required percentage: see current attendance, safe skips left and classes needed.
Open tool