Formulas & functions
How a function works, with worked examples you can paste.
- Excel IF Text Contains a Word: Formulas and ExamplesTo check whether a cell contains a word or phrase in Excel, use =IF(ISNUMBER(SEARCH("apple",A2)),"Yes","No"). It returns Yes when A2 contains “apple” anywhere…
- IFERROR in Excel: Leave Blank When a Formula ErrorsTo make an Excel formula show a blank instead of an error, wrap it in IFERROR and use an empty string as…
- Conditional Formatting Only If a Cell Has DataYes. In Excel for Microsoft 365, select the cells to format, choose Home > Conditional Formatting > New Rule > Use a…
- SUMIF Example Formula: Syntax, Uses, and Common FixesWith product names in A2:A7 and sales amounts in B2:B7, use =SUMIF(A2:A7,"Apples",B2:B7) to add the sales for Apples; if those rows contain…
- Excel EDATE Function: Add or Subtract Months from a DateUse Excel’s EDATE function to move a date forward or backward by a specified number of whole months: enter =EDATE(start_date, months), replacing…
- Aggregate and Non-Aggregate Functions in SQL ExplainedAggregate functions in SQL calculate a result from multiple rows, such as a sum or count; non-aggregate functions return a value for…
- Aggregate Functions in UPDATE: What SQL AllowsUsually, no: SQL does not allow an aggregate such as AVG() or SUM() directly as a row-level value in an UPDATE assignment.…
- XLOOKUP Example Sheet: Formula, Setup, and TipsAn XLOOKUP example sheet can find a value in one column and return the matching value from another. With product IDs in…
- XLOOKUP Between Two Sheets: Examples and Common FixesTo find a value on one worksheet and return its matching value on another, use XLOOKUP with the first sheet’s lookup cell…
- Excel PMT Function: Calculate Loan PaymentsTo calculate a fixed loan payment in Excel, divide the annual interest rate by the number of payments per year and use…
- How to Multiply Hours in Excel: Formulas and FormattingTo multiply a duration by a factor in Excel, enter the duration in A2 and the factor in B2, then use =A2*B2.…
- Multiply Time by a Number in Excel: Formula and TipsTo multiply a time value by a number in Excel, enter a formula such as =A2*B2, where A2 contains the time and…
- How to Multiply Different Cells in Excel With a FormulaTo multiply different cells in Excel, select an empty cell, type a formula that starts with an equals sign and uses an…
- How to Merge Names in Excel: Formulas and Flash FillTo combine first and last names in Excel, put the first names in column A and last names in column B, then…
- Capitalize Each Word in Excel with the PROPER FormulaTo capitalize the first letter of each word in Excel, enter =PROPER(A2) in an empty column beside the text in A2, then…
- Lowercase Names in Excel: Formula, Fill Down, and ReplaceTo lowercase names in Excel, use the LOWER function in a helper column, then fill the formula down. If the names are…
- Lock a Number in Excel: Keep It Fixed in FormulasTo keep a number fixed when you copy a formula, make its cell reference absolute by adding dollar signs, such as $A$1.…
- How to Lock a Filter in Excel Without Losing ControlTo keep an Excel filter in place while protecting the worksheet, set up the filter first, then choose Review > Protect Sheet…
- Link Different Sheets in Excel with FormulasTo link a cell on one Excel sheet to a cell on another, enter a reference such as =Sheet2!A1 in the destination…
- How to Find Duplicate Entries in Excel with FormulasTo find duplicate entries in Excel, select the cells you want to check and choose Home > Conditional Formatting > Highlight Cells…
- Copy Values in Excel: Keep Results, Not FormulasTo copy only the displayed results of cells in Excel, copy the source range, select the destination’s top-left cell, then choose Home…
- How to Install XLOOKUP in Excel and Check CompatibilityYou do not install XLOOKUP as a separate Excel feature or add-in: it is already built into supported versions. To use it,…
- How to Insert a Filter in Excel: Quick StepsTo insert a filter in Excel, click a cell in your data, then select Data > Filter. Excel adds a drop-down arrow…
- Identify Offsetting Entries in Excel With Formulas and ChecksTo flag entries with an equal and opposite amount, put the date in column A, account in B, reference in C, and…
- Ignore Divide by Zero Errors in Excel with IFERRORTo hide a divide-by-zero result in Excel, wrap the division in IFERROR, such as =IFERROR(B2/C2,""). This displays a blank instead of an…
- Highlight Upcoming Dates in Excel with a Formula RuleTo highlight dates coming up in the next 30 days, select the date cells and create a formula-based conditional formatting rule. If…
- How to Hide Filter Arrows in Excel and Keep Table FiltersTo hide filter arrows in Excel without removing a table’s AutoFilter setup, click inside the table, open Table Design, and clear Filter…
- How to Hide the Formula Bar in Excel on Windows and MacTo hide the formula bar in Excel for Microsoft 365, open the View tab, then in the Show group clear the Formula…
- Number Sequence in Excel: Fill Series or Use a FormulaTo create a number sequence in Excel, enter the first two numbers, select both cells, and drag the fill handle to extend…
- How to Group the Same Numbers in Excel: Sort and CountTo group identical numbers in Excel, sort the entire data range by the column containing those numbers: select a cell in the…