Formulas & functions
How a function works, with worked examples you can paste.
- VLOOKUP Examples for Practice: Learn Excel Lookup SkillsFor a first VLOOKUP practice problem, put product IDs in A2:A6, prices in B2:B6, and the lookup ID P104 in E2; enter…
- VLOOKUP and XLOOKUP Examples: Formulas and Tips in ExcelFor an exact match, use VLOOKUP when the value you are searching for is in the first column of the lookup range;…
- SUMIF Criteria Examples: Text, Dates, Numbers, and MoreIn Excel, SUMIF adds values that match one condition; for example, with categories in A2:A7 and amounts in B2:B7, =SUMIF(A2:A7,"Office",B2:B7) totals the…
- SUMIF in Excel: Step-by-Step Formula, Examples, and TipsTo total values that match one condition in Excel, use SUMIF. If categories are in A2:A7 and amounts are in B2:B7, enter…
- SUMIF and SUMIFS Examples in ExcelIn Excel, use SUMIF to add values that meet one condition and SUMIFS to add values that meet multiple conditions. With categories…
- Revit IF Formula Examples for Family ParametersIn a Revit family, an IF formula tests a condition and returns one value when it is true and another when it…
- Power Query IF Examples: Conditional Logic in ExcelIn Power Query, write an IF test in M as if condition then value_if_true else value_if_false. For example, if [Sales] >= 1000…
- Outlook Address Examples and How to Choose the Right OneCommon Outlook address examples include first.last@outlook.com, initials.number@outlook.com, and a work address such as first.last@company.com. The first two show personal Outlook.com formats; the…
- Nested XLOOKUP Examples for ExcelA nested XLOOKUP places one XLOOKUP inside another, so one search can supply the lookup value, return array, or fallback for the…
- Excel VLOOKUP Name Errors: Causes, Fixes, and Real Examples#NAME? in an Excel VLOOKUP means Excel cannot recognize a name or text token in the formula; common causes include a misspelled…
- Excel Null Values: Blanks, Formulas, and Power QueryMicrosoft Excel does not have a special worksheet value called NULL in the way a database does. What people call a “null…
- Microsoft 365 XLOOKUP Examples for Everyday Excel TasksIn Microsoft 365, XLOOKUP finds a value in one range and returns the corresponding value from another: use =XLOOKUP(lookup_value,lookup_array,return_array,"Not found"). For example,…
- INDEX MATCH With Multiple Criteria: Excel ExamplesIn Excel for Microsoft 365, use INDEX with MATCH and multiply the criteria tests to find a row that meets several conditions.…
- INDEX MATCH Examples: Exact, Two-Way, and Flexible LookupsWith product names in A2:A6, prices in B2:B6, and the product to find in E2, use =INDEX($B$2:$B$6,MATCH(E2,$A$2:$A$6,0)). If E2 contains Desk lamp…
- Excel IF Formula Examples for Everyday Spreadsheet TasksExcel’s IF formula checks whether a condition is true and returns one result if it is, and another if it is not.…
- What-If Analysis in Excel: Scenarios, Goal Seek & MoreIn Excel for Microsoft 365 on Windows, what-if analysis helps you see how changing input values affects a formula’s result. Open Data…
- How IFERROR Works in Excel: Examples and Common UsesIn Excel, IFERROR evaluates a formula and returns your chosen fallback if that formula produces an error; otherwise, it returns the formula’s…
- HLOOKUP With Multiple Criteria: Formulas and ExamplesHLOOKUP does not accept separate criteria arguments, but you can search by multiple criteria by joining the criteria into one key and…
- HLOOKUP Examples for Practice: Formulas and Fixes in ExcelFor an exact-match HLOOKUP practice example, put product codes in A1:D1, prices in A2:D2, and stock counts in A3:D3; enter =HLOOKUP("P103",$A$1:$D$3,2,FALSE) to…
- HLOOKUP Examples for Beginners in ExcelHLOOKUP searches across the top row of a table and returns a value from a specified row beneath the match. For an…
- Find in Excel: Search Cells, Data, and FormulasTo find text, numbers, or other content in Microsoft Excel for Microsoft 365 on Windows, press Ctrl+F, enter what you want to…
- How to Fill A to Z in Excel With Formulas or AutofillTo fill A to Z in Excel, enter =CHAR(ROWS($A$1:A1)+64) in the first cell, then fill it down 26 rows; to create the…
- Excel IF Formula Examples: Tests, Logic, and ErrorsExcel’s IF formula checks whether a condition is true or false and returns one result for each outcome. With a score in…
- Excel DATEDIF Formula Examples for Age and Date GapsExcel’s DATEDIF function calculates the number of complete years, months, or days between two dates: use =DATEDIF(A2,B2,"Y") for complete years, =DATEDIF(A2,B2,"M") for…
- XLOOKUP Examples: Formulas for Everyday Excel TasksTo return a value for a matching ID, use XLOOKUP with the value to find, the lookup range, and the range containing…
- INDEX MATCH With Two MATCH Functions: Practical ExamplesYes: the standard two-way lookup uses INDEX with one MATCH to find a row and a second MATCH to find a column.…
- COUNTIF Examples: Formulas for Common Spreadsheet TasksUse Excel’s COUNTIF function to count cells in one range that meet one condition: =COUNTIF(range,criteria). For example, it can count a particular…
- IF Function in Excel: Examples and Practical Uses ExplainedThe Excel IF function checks whether a condition is true and returns one result if it is, and another result if it…
- Excel IF Statements: Examples and How to Use ThemExcel IF statements let you test a condition and return one value when it is true and another when it is false.…
- IFERROR vs ISERROR: Which Excel Function Should You Use?IFERROR catches an error produced by a calculation and returns a replacement value; ISERROR checks whether a value or calculation produces an…