Formulas & functions
How a function works, with worked examples you can paste.
- Excel IF Statement for Dates: Compare DatesIf A2 contains a due date and B2 contains the date you want to check, enter =IF(A2<B2,"Overdue","Not overdue") to label dates before…
- Excel Paste Special: Copy Values, Formulas, and MoreTo use Paste Special in Excel for Microsoft 365 on Windows, copy the source cells, select the destination, then choose Home >…
- Divide in Excel Without a Function: Use the / OperatorTo divide in Excel without a function, enter a formula that starts with an equals sign and uses the slash operator: for…
- How to Divide in Excel: Formulas and ExamplesTo divide in Excel, enter a formula with a forward slash, such as =A2/B2, and press Enter. Replace A2 and B2 with…
- How to Divide in Excel: Formulas and the QUOTIENT FunctionTo divide values in Excel, enter a formula with the forward slash operator, such as =A2/B2. Excel does not have a general…
- Divide by Half in Excel: Formulas and StepsTo divide a value by one half in Excel, use a formula such as =A2/0.5; this doubles the value because dividing by…
- Divide a Cell by a Number in Excel: Formula GuideTo divide a cell by a number in Excel, enter a formula such as =A2/5 in an empty cell, replacing A2 with…
- How to Divide a Number in Excel Using Simple FormulasTo divide a number in Excel, enter a formula with a forward slash: for example, if A2 contains 24 and B2 contains…
- How to Delete Cells in Excel Without Losing FormulasTo remove entries without removing formulas in Excel, select only the cells containing the entries and choose Home > Clear > Clear…
- How to Delete a Formula in Excel but Keep Its ValueTo delete a formula but keep its calculated result in Excel, select the formula cells, copy them, then paste values back over…
- How to Delete a Whole Column in Excel the Right WayTo delete a whole column in Excel, select its lettered header, then choose Home > Delete > Delete Sheet Columns. You can…
- How to Create a Filter in Excel: Step-by-Step GuideTo create a filter in Excel for Microsoft 365 on Windows, click a cell in your data range, then choose Data >…
- Count Same Values in Excel with COUNTIFTo count how many times a value appears in Excel, use COUNTIF: if the values are in A2:A20 and the value to…
- How to Count Yes in an Excel Column with COUNTIF FormulaTo count cells that contain the answer Yes, enter a COUNTIF formula in an empty cell. If your answers are in A2:A10,…
- How to Count Rows in Excel: Formulas and Quick MethodsTo count records in Excel, use =COUNTA(A2:A20) when each record has a filled-in value in column A; it counts nonempty cells in…
- How to Count Names in Excel: Formulas and ExamplesTo count how often a particular name appears in Excel, use COUNTIF: with names in A2:A100 and the name to look for…
- Count Days in Excel: Formulas for Dates and WorkdaysTo count calendar days between two dates in Excel, put the start date in A2 and the end date in B2, then…
- Count Cells With Text in Excel Using the COUNTIF FormulaIf your text is in A2:A100, enter =COUNTIF(A2:A100,"*") to count cells containing text. This works in Microsoft Excel for Microsoft 365 on…
- Count a Specific Word in Excel: Formulas That WorkTo count cells that exactly match a word, use =COUNTIF(A2:A100,D1); to count cells that contain it anywhere, use =COUNTIF(A2:A100,"*"&D1&"*"). Put the word…
- How to Count Individual Names in Excel with a FormulaTo count how often each individual name appears, list the names in one column, create a unique-name list, and count each name…
- Count Words in Excel: Formulas for Exact and Partial MatchesTo count every occurrence of a word across text in Excel, put the word to find in D1 and use =SUMPRODUCT((LEN(LOWER(A2:A100))-LEN(SUBSTITUTE(LOWER(A2:A100),LOWER(D1),"")))/LEN(D1)). This…
- How to Count Hours in Excel With a FormulaTo calculate hours between a start time and an end time, put the start in A2 and end in B2, then enter…
- Copy Values Without Formulas in Excel: Step-by-StepTo copy formula results without copying the formulas in Excel for Microsoft 365 on Windows, select the cells, press Ctrl+C, choose the…
- Count a Particular Word in Excel: Formulas That WorkTo count every occurrence of a term across a range in Excel, put the term in D1 and use =SUMPRODUCT((LEN(A2:A100)-LEN(SUBSTITUTE(LOWER(A2:A100),LOWER(D1),"")))/LEN(D1)), replacing A2:A100…
- Copy Unique Values in Excel: A Step-by-Step GuideTo copy distinct values from a list in Excel for Microsoft 365, enter =UNIQUE(A2:A100) in an empty cell, then copy the results…
- How to Copy Unique Values in Excel Without DuplicatesTo copy a deduplicated list in Microsoft Excel, enter the UNIQUE formula in an empty cell, then copy the complete result and…
- Copy the Exact Same Formula in Excel Without Changing ItTo copy the exact same formula text in Excel, select the formula in the formula bar, copy it, then paste it into…
- How to Copy a Formula Down All Rows in ExcelTo copy a formula down a column in Excel, enter it in the first cell, select the cells below that need it,…
- Copy Values Only in Excel: Keep Results, Not FormulasTo copy results without copying their formulas in Excel for Microsoft 365 on Windows, select the cells, press Ctrl+C, choose the destination,…
- How to Copy Text Only in Excel Without Copying FormulasTo copy a formula’s result without copying the formula in Excel, select the cell or range, press Ctrl+C, choose the destination, then…