Formulas & functions
How a function works, with worked examples you can paste.
- Excel Interpolate Function: How to Calculate ValuesMicrosoft Excel does not have a built-in function named INTERPOLATE. To estimate a value between two known points, use a linear interpolation…
- Excel INDEX MATCH Lookup: Formula, Examples, and TipsIn Microsoft Excel for Microsoft 365, INDEX and MATCH work together to look up a value: MATCH finds the position of a…
- Excel IFERROR Function: Syntax, Examples, and TipsMicrosoft Excel’s IFERROR function returns a value you choose when a formula produces an error; otherwise, it returns the formula’s result. For…
- Excel INDEX MATCH Formula: How to Use It in Microsoft ExcelIn Microsoft Excel, combine INDEX and MATCH to find a value in one range and return the value from the same position…
- Excel INDEX and MATCH: Find Values in Large WorksheetsIn Excel, INDEX and MATCH work together to find a value in one range and return the corresponding value from another. With…
- Microsoft Excel: How to Sort Dates in a Table EasilyTo sort dates in Microsoft Excel for Microsoft 365 on Windows, select a cell in your date column and choose Data >…
- Excel COUNTIF: How to Count Matching CellsIn Excel, use COUNTIF to count cells in a range that meet one condition: enter =COUNTIF(range, criteria). For example, if A2:A8 contains…
- Microsoft Excel Grade Formula for Scores and LettersIn Microsoft Excel, calculate a percentage grade by dividing points earned by points possible: with points earned in B2 and points possible…
- Microsoft Excel Formula List: Functions and ExamplesA Microsoft Excel formula list is a reference to formulas and built-in functions used to calculate, compare, search, and reshape worksheet data.…
- Microsoft Excel Filter Table: How to Filter Your DataTo filter a table in Microsoft Excel for Microsoft 365 on Windows, click a cell in the table and use the dropdown…
- Microsoft Excel Filter Duplicates: Find or Remove ThemExcel does not have a dedicated “filter duplicates” command in a column’s filter menu. To show repeated records, add a helper column…
- Microsoft Excel Date Today: TODAY Formula and Useful TipsTo show today’s date in Microsoft Excel for Microsoft 365 on Windows, enter =TODAY() in a cell and press Enter. Excel returns…
- Excel DATEDIF Function: Calculate Years, Months, and DaysMicrosoft Excel’s DATEDIF function calculates the difference between two dates in complete years, months, or days, or in combinations such as years…
- Excel COUNTIF for Text: Examples and Common FixesTo count cells that match text in Microsoft Excel, use =COUNTIF(A2:A20,"Apple"), replacing the range and word with your own. COUNTIF can also…
- Excel COUNTIF for Text That Contains a WordTo count cells that contain a particular word or phrase anywhere in their text, use Excel’s COUNTIF function with an asterisk on…
- Microsoft Excel COUNTIF Formula: Syntax and ExamplesIf product names are in A2:A100, count cells containing Apples with =COUNTIF(A2:A100,"Apples"). COUNTIF counts cells in a range that meet one condition,…
- Microsoft Excel Concatenate Text: Formulas and ExamplesTo concatenate text in Microsoft Excel, join cell contents with the ampersand operator (&), or use CONCAT or TEXTJOIN. For example, with…
- Microsoft Excel Calendar Formula: Build a Monthly ViewIn Microsoft Excel for Microsoft 365, enter a year in B1 and a month number in C1, then put this formula in…
- Excel AVERAGEIF: Syntax, Examples, and Common FixesIn Microsoft Excel, use =AVERAGEIF(range,criteria,average_range) to average values that meet one condition. For example, if categories are in A2:A7 and amounts are…
- How to Merge Two Sheets in Excel with VLOOKUP FormulasTo merge information from two Excel sheets by a shared ID, add a column to the sheet you want to keep and…
- Max Value Between Two Dates in Excel: Formula GuideTo find the largest value recorded between two dates in Excel, use =MAXIFS(C2:C100,A2:A100,">="&E2,A2:A100,"<="&F2). This assumes dates are in A2:A100, the values to…
- Excel PMT Function for Mortgage Payments ExplainedExcel’s PMT function calculates the regular payment on a fixed-rate mortgage when you give it the interest rate per payment period, the…
- Match in Excel Without Duplicates: Formulas That WorkTo return values that appear in both Excel lists without repeating them, use =UNIQUE(FILTER(A2:A100,(A2:A100<>"")*ISNUMBER(XMATCH(A2:A100,B2:B100)),"")). With the first list in A2:A100 and the…
- Match Names on Two Excel Sheets with VLOOKUPYes. VLOOKUP can find a name on one Excel sheet in a second sheet and return a related value from that row.…
- Mac Excel Filter Shortcut: Turn Filters On and Use ThemIn Excel for Mac, press Command+Shift+F to turn AutoFilter on or off for a data range. Select a cell in the range…
- List Excel Sheet Tabs with a Formula: Methods That WorkIf you mean worksheet tabs, Excel has no built-in worksheet formula that directly lists their names. A legacy Excel 4 macro function,…
- Lowercase in Excel: Shortcut, Formula, and Fast FixesExcel has no built-in keyboard shortcut that directly changes selected text to lowercase. The dependable option is the LOWER function: with the…
- LEN SUBSTITUTE Excel Formula: Count Characters or TextTo count how many times a character appears in a cell, subtract the length of the text after removing that character from…
- VLOOKUP in Excel: Step-by-Step GuideTo use VLOOKUP in Excel, put the value you want to find in the first column of a lookup table, then enter…
- Excel Filter Shortcut: Turn AutoFilter On or OffIn Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to turn the filter buttons on or off. The shortcut adds or removes…