Formulas & functions
How a function works, with worked examples you can paste.
- SEQUENCE in Excel: Build Number Series AutomaticallyIn Excel for Microsoft 365, use the SEQUENCE function to create a series of numbers that spills into neighboring cells automatically. For…
- Using ROUNDUP in Excel: 10 Practical Formula ExamplesTo round a number up in Excel, use ROUNDUP with the number and the number of digits to keep. With a value…
- Using OFFSET in Excel: Syntax, Examples, AlternativesIn Microsoft Excel for Microsoft 365, OFFSET returns a reference to a cell or range at a specified distance from a starting…
- PMT in Excel: Calculate Loan Payments Step by StepTo calculate a fixed loan payment in Excel, use the PMT function: enter the interest rate per payment period, the total number…
- Using the PV Formula in Excel: Syntax, Examples, and TipsTo calculate present value in Excel, enter the PV function as =PV(rate,nper,pmt,[fv],[type]), replacing each argument with the rate per period, number of…
- Using NPV in Excel: Formula, Examples, and Timing GuideTo calculate net present value in Excel, use the NPV function for future cash flows, then add the initial investment separately. With…
- Using MID and FIND in Excel to Extract TextYes. In Excel, combine FIND with MID to locate a delimiter in a text value and return characters beside it. With a…
- Using MID in Excel: Extract Text by Position and LengthUse Excel’s MID function to return a chosen number of characters from a text value, starting at a position you specify. If…
- LEN Function in Excel: Count Characters in CellsIn Excel, use the LEN function to count the characters in a cell: with text in A2, enter =LEN(A2). LEN counts letters,…
- Using LAMBDA in Excel: Build Reusable Custom FunctionsIn Excel for Microsoft 365 or Excel 2024, use LAMBDA to turn a calculation into a reusable custom function: write the parameters…
- LEFT in Excel: Extract Text from the StartIn Excel, use the LEFT function to return characters from the beginning of a text value: with text in A2 and a…
- Excel INDIRECT for Multiple Tabs: Examples and LimitsYes. In Excel, use INDIRECT to turn text containing a worksheet name and cell reference into a working reference—for example, =INDIRECT("'"&A2&"'!B2") when…
- Using IFS Formula in Excel: Syntax and ExamplesIn Excel, use the IFS function to test conditions in order and return a value for the first condition that is true.…
- Using IF in Excel for Text: Compare, Match, and Return ResultsYes. In Excel, IF can test whether a cell contains particular text and return one result when it does and another when…
- IFERROR with VLOOKUP in Excel: Formulas and FixesTo use IFERROR with VLOOKUP in Excel, wrap the lookup formula inside IFERROR and provide the value to show if the lookup…
- Using IFERROR in Excel: Examples and Common FixesUse Excel’s IFERROR function to return a value you choose when a formula produces an error: wrap the calculation as =IFERROR(B2/C2,0). For…
- Using IF in Excel for Dates: Rules, Formulas, and ExamplesYes. In Excel, use IF to test a date against another date, a fixed cutoff, or a date range, then return a…
- How to Use the FV Function in Excel: Examples and TipsIn Excel, use the FV function to calculate the future value of an investment or a series of regular payments: enter a…
- Alphabetize Names in Excel: Sort a List Step by StepTo alphabetize names in Excel, select the names and choose Data > Sort A to Z. If each name belongs with other…
- Using EDATE in Excel to Add or Subtract MonthsUse Excel’s EDATE function to move a date forward or backward by a chosen number of months: enter =EDATE(start_date, months), replacing the…
- Excel INDEX MATCH: How It Works and When to Use ItIn Excel, INDEX MATCH combines INDEX and MATCH to look up a value and return a related value from another range. For…
- DATEDIF in Excel: Calculate Years, Months, and DaysIn Excel for Microsoft 365, DATEDIF calculates the number of complete years, months, or days between two dates. If the earlier date…
- COUNTIF in Excel for Text: Practical Examples and TipsYes. In Excel, use COUNTIF to count cells that match text: with status values in A2:A20, count cells equal to Paid with…
- How to Use CONCATENATE in ExcelTo combine text from cells in Excel, use =CONCATENATE(A2," ",B2); if A2 contains Grace and B2 contains Hopper, the result is Grace…
- Using COUNTIF in Excel With Dates: Formulas and ExamplesTo count cells that match a date in Excel, use COUNTIF with a real date value—for example, with dates in A2:A9, =COUNTIF(A2:A9,DATE(2026,3,3))…
- Updating Data Validation Lists in Excel the Right WayTo update an Excel drop-down list, select a cell that uses it, choose Data > Data Validation, and change the entry in…
- Excel UNIQUE Formula: Return a List Without DuplicatesYes. In Microsoft 365 or Excel 2021 and later, use =UNIQUE(A2:A8) to return the distinct values from A2:A8 without repeating duplicates. Enter…
- Unique List From Excel Column: Formulas and OptionsTo create a unique list from an Excel column in Microsoft 365, enter =UNIQUE(A2:A100) in an empty cell, replacing the range with…
- Excel UNIQUE, SORT, and FILTER Spill Errors ExplainedIf a formula using UNIQUE, SORT, and FILTER returns #SPILL!, Excel cannot place its results in the cells the formula needs—usually because…
- UNIQUE and FILTER in Excel Tables: A Practical GuideTo return a sorted list of distinct items from an Excel Table that match a condition, enter =SORT(UNIQUE(FILTER(Sales[Item],(Sales[Region]=G2)*(Sales[Item]<>"")))) in a blank cell…