DeskPlainFormula reference
Excel formula finder
Match a task to a formula pattern, a worked example and the version you need.
Runs in this page. No DeskPlain upload, account or saved history.
Start with the task, then check the version.
These patterns use illustrative cells and English function names with commas. Replace the ranges with your own data; your Excel language or locale may use different names or separators. This reference does not execute formulas.
Use a formula on a small reviewed example first
Inspect blanks, errors and mixed data types. A formula that runs is not proof that the business rule or range is correct. Microsoft’s alphabetical function reference provides function-specific syntax and version notes.
Compare XLOOKUP and VLOOKUP ↗ · Work through COUNTIF and COUNTIFS ↗