Formulas & functions
How a function works, with worked examples you can paste.
- Excel ABS Function: How to Return a Positive ValueTo turn a negative number into a positive one in Excel, use the ABS function: it returns the number’s absolute value. For…
- Excel Functions to Extract Text From Strings: A GuideExcel has several functions for extracting text from a string. Use LEFT, RIGHT, or MID to return characters by position; in Microsoft…
- Excel Function to Check If a Cell Contains TextTo check whether a cell contains a particular word or phrase, use =ISNUMBER(SEARCH("text",A2)), replacing “text” with the text you want to find.…
- Excel Formula for Removing Spaces: TRIM and MoreIn Excel, use =TRIM(A2) to remove leading and trailing spaces and reduce repeated spaces between words to one. If you want to…
- Excel Formula for Range of Values: Find the SpreadTo calculate the numerical range of values in Excel, subtract the smallest value from the largest: =MAX(A2:A7)-MIN(A2:A7). If your data is in…
- Excel QR Code Formula: Create QR Codes from Cell DataExcel has no built-in QR-code function, but in Microsoft 365 for Windows you can display a QR code from cell data with…
- Excel Present Value Formula: PV Function and ExamplesIn Excel, use the PV function to calculate the present value of future cash flows: it discounts them using a rate and…
- Excel Formula for Percentage of Total: Clear ExamplesTo calculate a percentage of a total in Excel, divide the part by the total: if the value is in B2 and…
- Excel Formula for Percentage Between Two Cells ExplainedTo find what percentage one cell is of another in Excel, divide the first cell by the second: if the values are…
- Excel Formula for Numbering Rows: Static and DynamicTo number rows in Excel, enter =ROW()-1 in cell A2 when row 1 contains a header, then fill the formula down. For…
- Excel Formula for Overdue Days: Dates and ExamplesTo calculate overdue days in Excel, put the due date in A2 and use =IF(A2="","",MAX(0,TODAY()-A2)) in another cell. It returns 0 when…
- Excel Formula for Next Month: Dates, Month-End, and MoreTo move a date in cell A1 forward by one month, enter =EDATE(A1,1). Excel returns the corresponding date in the next month,…
- Excel Formula for Name Arrangement: Sort Names A to ZFor Microsoft 365, use =SORT(A2:A20) to arrange a list of names alphabetically; replace the range with your own. If you mean changing…
- Excel Formula for Month and YearIf the date is in A2, enter =TEXT(A2,"mmmm yyyy") in B2 to display its month and year, such as February 2025. This…
- Excel Formula for Minus Amounts: Examples and TipsTo subtract one amount from another in Excel, enter a formula with the minus sign: if the first amount is in A2…
- Excel Formula for Matching Values: Exact Match GuideFor an exact match in a list, use =MATCH(E2,A2:A100,0): it returns the matching item’s position within the range, or #N/A if no…
- Excel Formula for the Lowest Value: MIN ExplainedThe Excel formula for the lowest value in a range is =MIN(A1:A10). Replace A1:A10 with the cells you want to check; Excel…
- Excel Loan Payment Formula: How to Use PMTFor a fixed-rate loan with monthly payments, Excel’s PMT function calculates the regular payment. If B1 contains the loan amount, B2 the…
- Excel Formula for the Lesser of Two Values in a CellWith the two numeric values in cells A2 and B2, enter =MIN(A2,B2) in the cell where you want the answer. Excel returns…
- Excel Formula for Last Updated Date in a Specific CellFor a live current date in Excel, use =TODAY(); for the current date and time, use =NOW(). Neither formula records when a…
- Excel Formula for the Larger of Two NumbersTo return the larger of two numbers in Excel, use the MAX function. With the values in A1 and B1, enter =MAX(A1,B1);…
- Excel Formula for Last 4 Digits: RIGHT and FixesTo return the last four characters from a value in cell A2, use =RIGHT(A2,4). For example, if A2 contains 5551234567, the result…
- Excel Julian Date Formula: Day of Year and MoreFor a date in A2, use =INT(A2)-DATE(YEAR(A2),1,0) to return its day number within the year: January 1 is 1, and December 31…
- Excel Formula for the Higher of Two Values: MAX or IFTo return the higher of two values in Excel, use the MAX function. If the values are in cells A1 and B1,…
- Excel Formula for Grouping Data by CategoryIn Excel for Microsoft 365, use UNIQUE to list each category once and FILTER to return the records for a chosen category;…
- Excel FV Formula: How to Calculate Future Value and GrowthIn Excel for Microsoft 365, use the FV function to calculate the future value of regular payments or a starting balance. For…
- Excel Formula for the Greater of Two Values: MAX or IF?To return the greater of two numeric values in Excel, use =MAX(A2,B2), assuming the values are in cells A2 and B2. MAX…
- Excel Formula for a Future Date: Add Days or MonthsIf the starting date is in A2 and the number of days to add is in B2, enter =A2+B2 to return a…
- Excel Formula to Extract the First Five Digits from D2Assuming D2 contains the text or number you want to search, use =IFERROR(IF(D2="","",LEFT(TEXTJOIN("",TRUE,IFERROR(MID(D2,SEQUENCE(LEN(D2)),1)*1,"")),5)),"") to collect the first five digits found anywhere in…
- Excel Formula for the First 3 Digits: Text or Numbers?To return the first three characters from a value in cell A2, use =LEFT(A2,3). The result is text, even when the characters…