Formulas & functions
How a function works, with worked examples you can paste.
- Capitalize the Whole Word in Excel: Formulas and TipsTo capitalize every letter in a word or cell in Excel, use the UPPER function: if the original text is in A2,…
- Excel Formula to Check Yes or No in Another ListYes. To show whether a value in one cell appears anywhere in another list, use COUNTIF inside IF. With the value to…
- Excel IFS Formula with Dates: Examples, Rules, and TipsTo use IFS with dates in Excel, compare a date cell with date boundaries created by DATE. For example, with dates in…
- IF Statements for Dates in Excel: Examples and RulesTo write an IF statement for dates in Excel, compare a cell containing a real date with a date or date-based rule.…
- IF Then for Dates in Excel: Formulas and ExamplesTo use IF with dates in Excel, compare a cell containing a real date with another date or a date created by…
- IF Then Formula for Dates in Excel: Examples and FixesUse Excel’s IF function to test a date and return one result when the condition is true and another when it is…
- Excel IF Greater Than: Formulas, Examples, and RulesIn Excel, use the greater-than operator > to test whether one number exceeds another; wrap the test in IF when you want…
- Excel Greater Than Formula: Compare Numbers and ValuesTo test whether a number is greater than another value in Excel, use the greater-than operator >. For example, with numbers in…
- Show Errors as Blank in Excel: Formula and OptionsYes. In Excel for Microsoft 365, wrap a formula in IFERROR and return an empty text string when it fails. For example,…
- Excel Errors: Make a Cell Blank When a Formula FailsYes. In Excel for Microsoft 365, wrap a formula in IFERROR and use an empty text value as the fallback; Excel then…
- IFERROR Leave Blank in Excel: Formula and ExamplesTo leave a cell blank when a formula returns an error in Excel, wrap the formula in IFERROR and use an empty…
- IFERROR Function in Excel: Syntax, Examples, and TipsIn Excel, use IFERROR to return a chosen result when a formula produces an error: the syntax is =IFERROR(value, value_if_error). For example,…
- IFERROR Formula in Excel: Syntax, Examples, and FixesIn Excel, use IFERROR to return a chosen result when a formula produces an error: it has the form =IFERROR(value, value_if_error). For…
- Excel IFERROR for Multiple Cells: Formulas and TipsTo handle errors across multiple cells in Excel, use IFERROR in the first output cell and fill the formula down or across;…
- IF Cell Color in Excel: Formulas and WorkaroundsNo—Excel’s IF function cannot test a cell’s fill color directly. Use the value or status that causes the color instead; if color…
- How VLOOKUP Works Between Two Excel SheetsTo look up a value from one Excel sheet in a table on another, use VLOOKUP with the lookup cell, a range…
- Excel IF Statement for Dates: Compare Dates and Set RulesWith due dates in A2:A20, enter a formula in B2 to label each date as overdue or not: =IF(A2<TODAY(),"Overdue","Not overdue"). Excel compares…
- LEFT Function in Excel for Dates: How to Extract PartsTo use LEFT with a date in Excel, first turn the date into text in the format you want, then take characters…
- Excel IF Formula for Dates: Examples and StepsTo use IF with dates in Excel, test a cell containing a real date and return the label you want for each…
- FIND Function in Excel: Search Text and Return Its PositionUse Excel’s FIND function to locate a piece of text inside another cell and return the character position where it starts. For…
- Excel Custom Text Filter: Find Matching Text in a ListTo use a custom text filter in Excel, open the filter arrow in a text column, choose Text Filters, select a condition…
- DATEDIF in Excel: Calculate Age in Years, Months, and DaysTo calculate someone’s age in completed years in Excel, enter their date of birth in A2 and use =DATEDIF(A2,TODAY(),"Y") in another cell.…
- How to Use Dates in SUMIFS Formulas in Microsoft ExcelTo sum values for a date or date range in Excel, use SUMIFS with date criteria such as ">="&DATE(2026,3,1) and "<"&DATE(2026,4,1). The…
- Trim Numbers in Excel: Remove Spaces and Convert to ValuesTo remove extra spaces from a number stored as text and convert it to a real Excel number, enter =VALUE(TRIM(A2)) in a…
- Trim Number in Excel Formula: Remove Decimal PlacesTo remove decimal places without rounding, use TRUNC. With the original number in A2 and a target of two decimal places, enter…
- Transpose in Excel and Keep Formulas: A Practical GuideTo transpose a range in Excel and keep its formulas, copy the cells, select a blank destination, then choose Home > Paste…
- Transpose in Excel Using a Formula: Step-by-Step GuideTo transpose a range in Microsoft Excel for Microsoft 365, switch its rows and columns with the TRANSPOSE function. With source data…
- Transpose Data in Excel Using a Formula Step by StepTo transpose data in Excel with a formula, select a blank cell where the transposed result should begin and enter =TRANSPOSE(A1:C2), replacing…
- How to Sum in Excel If a Cell Contains a Specific WordTo add numbers when a related cell contains a particular word, use SUMIF with asterisks around the word. For example, if descriptions…
- How to Sum and Round in Excel in One FormulaTo add values and round the final total in one step, use =ROUND(SUM(B2:B5),2). This example assumes the numbers are in B2:B5; if…