Formulas & functions
How a function works, with worked examples you can paste.
- Excel Midpoint of Dates: Formula and ExamplesTo find the midpoint between two dates in Excel, put the earlier date in A2 and the later date in B2, then…
- Excel Filter Shortcut: How to Turn Filters On and OffIn Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to turn AutoFilter on or off for a data range or table. Once…
- Excel MAX Function for Dates: Find the Latest DateTo find the latest date in Excel, use =MAX(A2:A20), replacing the range with your date cells. Excel stores real dates as serial…
- Excel MATCH in Reverse Order: Find the Last MatchExcel’s MATCH function does not have a setting to search from bottom to top. To find the last matching item in a…
- Excel INDEX MATCH: How to Build Flexible Lookup FormulasIn Excel, combine INDEX and MATCH to find a value in one range and return the corresponding value from another: with product…
- Excel List Unique Entries with Formulas and Built-In ToolsTo list unique entries in Microsoft Excel for Microsoft 365, enter =UNIQUE(A2:A100) in an empty cell, replacing the range with your data;…
- Excel LEFT Function for Dates: What It ReturnsExcel’s LEFT function can take a date, but it does not read the date as it appears on the screen: it reads…
- Excel LEFT: How to Return Text Before a Specific WordTo return everything before a particular word in an Excel cell, use =TEXTBEFORE(A2,B2) in Microsoft 365, where A2 contains the text and…
- Excel LEFT Before a Character: Formula and ExamplesTo return the text to the left of a character in Excel, put the text in A2 and use =LEFT(A2,FIND(",",A2)-1) to extract…
- Excel LAMBDA vs LET: Differences, Uses, and ExamplesExcel’s LET function gives names to values inside one formula, while LAMBDA lets you define a reusable function with inputs and a…
- Excel Right-Click Shortcut: Open the Menu by KeyboardIn Excel for Microsoft 365 on Windows, press Shift+F10 to open the context menu—the menu you normally see after right-clicking. If your…
- Excel Keyboard Shortcut to Paste Values Without FormulasIn Excel for Microsoft 365 on Windows, copy the cells, select the destination, then press Ctrl+Alt+V, press V, and press Enter. This…
- Excel Filter Shortcut: Turn On Filters and Open MenusIn Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to turn AutoFilter on or off for a data range. To open a…
- Excel Align Left Shortcut: Windows and Mac GuideIn Excel for Microsoft 365 on Windows, select the cell or range and press Alt, then H, A, and L, one key…
- Excel Keep a Table Column Fixed in a Formula: GuideTo keep an Excel table column fixed when copying a formula, refer to the column by its table name, such as Orders[Amount],…
- Excel Formula List: Essential Functions and ExamplesAn Excel formula list is a reference to the calculations and functions you can use in a worksheet. Common examples include SUM…
- Excel Formulas: Function List, Categories & ExamplesThere is no single finite list of every Excel formula: a formula is any expression you build, while Excel’s built-in functions are…
- Excel FILTER Multiple Criteria: AND and ORTo filter rows by multiple criteria in Excel, use the FILTER function and multiply criteria for AND logic or add them for…
- Excel Insert Image from URL: Formula, Steps, and FixesTo insert an image from a URL in Microsoft Excel for Microsoft 365, put the direct image address in a cell and…
- Excel INDIRECT for a Different Sheet: Syntax and ExamplesYes. In Excel, INDIRECT can return a reference to a cell on another sheet when the sheet and cell reference are written…
- Excel INDEX MATCH With Multiple Criteria: A Practical GuideTo return a value in Excel by matching more than one condition, combine the tests inside MATCH and use the result as…
- Excel INDEX MATCH Tutorial: Exact and Flexible LookupsTo look up a value with INDEX MATCH in Excel, use MATCH to find the position of a key and INDEX to…
- Excel IFS Between Two Dates: Formulas and ExamplesTo check whether a date falls between two dates in Excel, put an AND test inside IFS: IFS(AND(date>=start,date<=end),result,TRUE,other_result). The two comparisons make…
- Excel IFS Function With Dates: Examples and Date RulesYes. Excel’s IFS function can test dates just like other values: compare a date cell with TODAY(), another date, or a date…
- Excel IF vs IFS: Examples and When to Use EachUse Excel’s IF function for a single test or a short decision; use IFS when you need to check several conditions in…
- Excel IFERROR Formula Examples: Uses and Common FixesIf the value is in A2 and the divisor is in B2, use =IFERROR(A2/B2,"Cannot divide") to show a helpful message instead of…
- Excel IF ISNUMBER: Check Whether a Cell Contains a NumberTo make Excel return one result when a cell contains a number and another when it does not, combine IF with ISNUMBER.…
- Excel: How to Substitute Multiple Text ValuesIn Excel, substitute multiple text strings by nesting SUBSTITUTE functions, one for each change. If A2 contains “The blue chair is blue,”…
- Excel IF Formula Returns 0? Show a Blank Cell InsteadIf an Excel formula returns 0 and you want the cell to look blank, wrap the calculation in an IF function that…
- Excel: How to Sort Dates in Order?To sort dates in Excel, select a cell in the date column, then choose Data > Sort Oldest to Newest for chronological…