Formulas & functions
How a function works, with worked examples you can paste.
- Excel CONCAT and Text: Formulas, Examples, and FixesTo join text and cell values in Excel, use CONCAT or the ampersand operator. For example, if A2 contains a first name…
- CONCAT in Excel: Add a Space Between Text ValuesTo add a space when joining text in Excel, include a space in quotation marks as an argument: with a first name…
- Excel Not Highlighting Cells in Formula? Try These FixesExcel highlights referenced cells only while you are editing a formula: select the formula cell and press F2, or click inside the…
- Excel Not Equal to Blank: Formulas, Examples, and FixesTo test whether a cell is not blank in Excel, use the not-equal operator with an empty string: with the value to…
- Excel Not Equal Symbol: How to Use <> in FormulasIn Microsoft Excel, the not-equal operator is <>—a less-than sign followed by a greater-than sign. Use it in a formula such as…
- Excel Not Blank Function: Check Whether a Cell Has DataExcel does not have a function named NOTBLANK. To test whether A2 is not truly empty, use =NOT(ISBLANK(A2)); it returns TRUE when…
- Excel Not Allowing Me to Drag a Formula? Try These FixesIf Excel will not let you drag a formula, turn on File > Options > Advanced, then under Editing options select Enable…
- Excel IFS Function: Syntax, Examples, and AlternativesIn Microsoft Excel, the IFS function checks multiple conditions in order and returns the result paired with the first condition that is…
- Excel IFS Function for Data Analysis: Rules and ExamplesExcel’s IFS function tests conditions in order and returns the result for the first condition that is TRUE. In data analysis, it…
- Excel IFS in Multiple Cells: Apply Logic Across RangesTo use IFS in multiple cells, write the formula for the first row, then copy or fill it down or across so…
- Excel IFS Function: What Happens If No Test Is TRUE?If every test in Excel’s IFS function is FALSE, the function returns #N/A; it does not have a separate built-in “value if…
- Excel IFS Greater Than and Less Than: ExamplesYes. In Excel, use greater-than and less-than operators directly inside an IFS logical test, such as A2>10 or A2<20. IFS checks its…
- Excel IFS in Conditional Formatting: How to Use ItYes. In Excel for Microsoft 365 on Windows, you can use the IFS function in a conditional-formatting formula, provided the formula ultimately…
- Excel IFS Default Value: Set a Reliable Fallback ResultExcel’s IFS function has no built-in default argument: if none of its tests is TRUE, it returns #N/A. Add a fallback by…
- Excel IFS Between Two Numbers: Formula and ExamplesTo check whether a value in A2 falls between 10 and 20, inclusive, use =IFS(AND(A2>=10,A2<=20),"In range",TRUE,"Out of range"). The AND function tests…
- Excel IFS Function: Syntax, Examples, and Common ErrorsExcel’s IFS function contains pairs of logical tests and the values to return when those tests are true. It checks the tests…
- Excel IFS vs COUNTIF: When to Use EachIn Excel, IFS tests conditions in order and returns a corresponding result, while COUNTIF counts cells that meet one condition. They are…
- Excel IF SUM: How to Combine IF, SUMIF, and SUMIFS FormulasTo test a total and return one result or another, combine IF with SUM: for example, with amounts in B2:B5, =IF(SUM(B2:B5)>1000,"Target met","Below…
- Excel IFS Function: Formula, Examples, and TipsIn Excel, the IFS function checks conditions in order and returns the value paired with the first condition that is TRUE. A…
- Excel IF Blank: Formulas for Empty Cells and ResultsIf you want Excel to show one result when a cell is blank and another when it is not, use an IF…
- If Excel Contains Specific Text: Formulas That WorkTo check whether a cell contains specific text in Excel, use IF with SEARCH and ISNUMBER. With the text to check in…
- Excel Formulas With Text: How to Combine Words and ValuesTo use text in an Excel formula, put literal words inside straight double quotation marks, such as ="Ready". To combine text with…
- IFERROR in Excel: Syntax, Examples, and Common FixesIn Excel, IFERROR checks whether a calculation returns an error and displays a value you choose instead; its basic pattern is =IFERROR(value,…
- IFERROR with AVERAGE in Excel: Formulas and ExamplesTo use IFERROR with AVERAGE in Excel, wrap the average calculation in IFERROR: with the values to average in B2:B10, enter =IFERROR(AVERAGE(B2:B10),"No…
- IFERROR Excel SUM: How to Ignore Errors in a TotalTo add a range while treating error cells as zero, use =SUM(IFERROR(A2:A10,0)), assuming the values and any errors are in A2:A10. In…
- AVERAGEIF Excel Range: Syntax, Examples, and Common FixesIn Excel, the range in AVERAGEIF is the group of cells Excel checks against your condition; the optional average_range is the group…
- IFERROR with VLOOKUP in Excel: Hide Lookup ErrorsYes. With lookup IDs in A2:A100, return values in C2:C100, and the value to search for in E2, wrap VLOOKUP in IFERROR…
- AVERAGEIF in Excel: Average Numbers by Text CriteriaYes. In Excel, AVERAGEIF can use a text criterion—such as a department name or status—to select which rows to average. It averages…
- AVERAGEIF Excel Between Values: Formula and ExamplesTo average numbers that fall between two limits in Excel, use AVERAGEIFS, not AVERAGEIF, because the range needs two criteria: a lower…
- AVERAGEIF Across Multiple Excel Sheets: Formulas & TipsYes, you can average values that meet a condition across multiple Excel sheets, but a single ordinary AVERAGEIF formula cannot take a…