Formulas & functions
How a function works, with worked examples you can paste.
- Excel IF NOT ISBLANK: How to Test for Nonblank CellsTo run an IF test when a cell is not blank, use =IF(NOT(ISBLANK(A2)),"Present","Blank"). This example assumes the cell to check is A2;…
- Excel Not Null Formula: Check for Nonblank Cell ValuesExcel has no built-in ISNOTNULL or NOTNULL function. To test whether A2 is not empty, use =A2<>""; it returns TRUE for a…
- DATEDIF in Excel: Examples for Years, Months, and DaysTo calculate the time between two dates in Excel, use DATEDIF. With a start date in A2 and an end date in…
- ABC-XYZ Analysis in Excel: Steps and FormulasABC-XYZ analysis in Excel combines two ways to classify inventory: ABC ranks items by their annual usage value, while XYZ groups them…
- Excel Formula Enum: How to Create Enum-Like Lists in ExcelExcel has no built-in ENUM worksheet function or enum data type, so there is no single “Excel formula enum.” To get enum-like…
- Enum Formula in Excel: Syntax, Examples, and AlternativesExcel has no built-in ENUM formula or worksheet keyword. To enumerate values, use a function such as SEQUENCE or a fill-down formula;…
- What-If Analysis in Excel: Definition and ExamplesIn Excel, what-if analysis means changing input values in a spreadsheet model to see how those changes affect its results. The built-in…
- Use VLOOKUP in Excel to Compare Two SheetsIf Sheet1 has matching IDs in column A and values to compare in column B, and Sheet2 uses the same layout, enter…
- TVM Solver in Excel: Functions and Goal SeekIf you mean a TVM (time value of money) solver, yes: Excel can calculate present value, future value, payments, interest rates, and…
- Split Cell Content in Excel: Formulas and ExamplesTo split text from one cell into separate cells in Microsoft 365, use TEXTSPLIT. If A2 contains Maya Chen,Seattle,WA, enter =TEXTSPLIT(A2,",") in…
- Slicers for Excel Columns: Filter a Table or PivotTableYes. In Excel for Microsoft 365 on Windows, you can add a slicer for a column in an Excel table or PivotTable:…
- SharePoint Excel Formula Not Calculating? Fixes That WorkIf an Excel formula in a SharePoint workbook is not calculating, first confirm that the cell contains a formula rather than text,…
- Sigma Code in Excel Solver: Build the Formula and SolveIf by “sigma code” you mean the Greek capital sigma, Σ, used to show a sum, Excel Solver does not accept sigma…
- Scenario Management in Excel: Compare What-If CasesIn Excel for Microsoft 365 on Windows, use Data > What-If Analysis > Scenario Manager to save different sets of input values…
- Remove Duplicates in Excel: Keep the Right RecordsTo remove duplicates in Excel for Microsoft 365 on Windows, select your data, go to Data > Remove Duplicates, choose the columns…
- Excel Split Text in a Cell: Methods and Formulas GuideYes. In Microsoft Excel for Microsoft 365 on Windows, you can split text in a cell using Data > Text to Columns…
- Excel Remove Duplicates: How to Keep the Right RowsTo remove duplicates in Microsoft Excel for Microsoft 365 on Windows, select your data, then choose Data > Remove Duplicates. In the…
- Excel Goal Seek Formula: How to Loop ItExcel does not have a worksheet function called LOOP or GOALSEEK: Goal Seek is a built-in What-If Analysis command, and it solves…
- Link Excel Data Validation to a Table the Right WayYes. In Excel for Microsoft 365 on Windows, the reliable way to link a dropdown list to a table is to create…
- Join Text in 3 Columns in Excel With Simple FormulasTo join text from three columns in Excel, enter =A2&" "&B2&" "&C2 in a new column, replacing the spaces between quotation marks…
- Import CSV Into Excel as Rows, Not Columns the Right WayTo import a CSV into Excel with each record on its own row, open Excel and choose Data > From Text/CSV, select…
- How to Check If an Excel File Is CorruptedTo check whether an Excel file is corrupted, first make a copy, then try opening the copy in Excel for Microsoft 365…
- How to Merge Two Columns in Excel With Text Using a FormulaTo combine text from two Excel columns, enter a formula such as =A2&" "&B2 in a new column, then fill it down.…
- How to Know If an Excel File Is Corrupted and What to CheckTo check whether an Excel file is corrupted, first make a copy, then try opening that copy in desktop Excel. If Excel…
- How to Compare Records in Two Excel Sheets with FormulasTo compare records in two Excel sheets, match each row by a shared, unique ID rather than by its position. First flag…
- How to Consolidate Duplicate Values in Excel with FormulasTo combine repeated labels and total their numbers in Excel, create a PivotTable: select your data, choose Insert > PivotTable, place the…
- Combine Two Columns in Excel: Formulas and StepsTo combine two text columns in Excel, enter a formula in a new column and fill it down. With the first text…
- Excel Formula Not Calculating? Causes and FixesAn Excel formula usually fails to calculate because the workbook is set to Manual calculation, the cell is storing the formula as…
- Generate Row Numbers by Group in Excel with FormulasTo generate a row number that restarts for each group in Excel, put group names in A2:A100 and enter =COUNTIF($A$2:A2,A2) in B2,…
- Formula to Merge Two Cells in Excel: Examples & TipsTo combine the contents of two cells in Excel, use a formula such as =A2&" "&B2. This assumes the first value is…