Formulas & functions
How a function works, with worked examples you can paste.
- How IFs Work in Excel: Formulas and ExamplesIn Excel, an IF formula tests a condition and returns one result when it is true and another when it is false;…
- How to Sort Dates in Excel and Keep Every Row TogetherTo sort dates in Excel, select a cell in the date column and choose Data > Sort Oldest to Newest or Data…
- How to Filter Duplicates in ExcelTo filter duplicate rows in Excel for Microsoft 365 on Windows, add a helper column with a formula such as =COUNTIF($A$2:$A$100,A2)>1, fill…
- Filter by Text Color in Excel: A Step-by-Step GuideTo filter by text color in Excel for Microsoft 365 on Windows, select a cell in your data, choose Data > Filter,…
- Change Capital to Lowercase in Excel: Formulas and TipsTo change capital letters to lowercase in Excel, use the LOWER function in a blank column: with the text in A2, enter…
- Compare Dates in Excel IFS: Formulas and ExamplesTo compare a date in Excel with today, put the date in A2 and enter =IFS(A2<TODAY(),"Overdue",A2=TODAY(),"Due today",A2>TODAY(),"Upcoming"). IFS tests conditions in order…
- How COUNTIF Works in Excel: Criteria, Examples & TipsExcel’s COUNTIF function counts cells in a range that meet one condition. Its basic pattern is =COUNTIF(range, criteria): specify where Excel should…
- COUNTIF in Excel: How It Works and How to Use ItExcel’s COUNTIF function counts cells in a range that meet one condition. Give it a range to inspect and a criterion to…
- Excel Transpose Shortcut: The Fastest Key SequenceIn Excel for Microsoft 365 on Windows, copy the range, select the destination cell, then press Ctrl+Alt+V, E, and Enter to paste…
- Half Day Attendance Formula in Excel: Examples and SetupFor a row of attendance codes in B2:F2, where P means present and H means half day, use =COUNTIF(B2:F2,"P")+COUNTIF(B2:F2,"H")*0.5. It returns attendance…
- Grading in Excel Using IF: Formulas and ExamplesTo assign letter grades in Excel, put each numeric score in column B and enter a nested IF formula in C2: =IF(B2>=90,"A",IF(B2>=80,"B",IF(B2>=70,"C",IF(B2>=60,"D","F")))).…
- Excel Grade Formula Using COUNTIF: Setup and ExamplesTo assign a letter grade with COUNTIF, put the score in B2, the grade cutoffs 60, 70, 80, and 90 in F2:F5,…
- Google Translate Formula in Excel: Why It Fails and FixesIf a Google Translate formula is not working in Excel, the main issue is that Excel does not include a built-in GOOGLETRANSLATE…
- Generate Invoice Numbers in Excel With a Simple FormulaTo generate invoice numbers in Excel, enter ="INV-"&TEXT(ROW()-1,"0000") in cell A2 when row 1 is a header and your first invoice is…
- FV Excel Formula: Syntax, Examples, and TipsExcel’s FV function calculates the future value of savings or a loan-related cash flow using a constant interest rate and regular payment…
- Excel Formula to Capitalize Names: What PROPER Gets RightTo capitalize names in Excel, enter =PROPER(A2) in a helper column when the name is in A2. PROPER changes text to title-style…
- Excel Formula to Concatenate Names: Examples and TipsTo concatenate first and last names in Excel, use =A2&" "&B2 when the first name is in A2 and the last name…
- Excel Timesheet Hours Formula: Calculate Time WorkedTo calculate a shift in decimal hours in Excel, put the start time in B2 and end time in C2, then enter…
- Formula for Over or Under Budget in Excel: ExamplesTo calculate whether spending is over or under budget in Excel, subtract the budget from the actual amount: with actual spending in…
- Formula for Overtime Hours in Excel: Simple ExamplesFor a daily overtime calculation in Excel, use =MAX(0,(MOD(C2-B2,1)-D2)*24-E2). With a start time in B2, end time in C2, an unpaid break…
- Excel Time Card Formula: Track Hours and OvertimeFor a basic Excel time card, enter a start time in B2, an end time in C2, and unpaid break minutes in…
- Excel Due Date Formula: Examples and Workday OptionsFor a basic due date in Excel, enter a start date in A2 and the number of calendar days to add in…
- Excel TEXT Function for Dates: Format Dates as TextUse Excel’s TEXT function to display a date in a chosen written format: if A2 contains the date June 7, 2026, enter…
- Formula to Capitalize Each Word in ExcelIn Excel, use the PROPER function to capitalize the first letter of each word: with the text to change in A2, enter…
- Finding Names in Excel: Search, Filter, and Match QuicklyTo find a name in Excel, press Ctrl+F, type the name, and choose Find Next or Find All; use the Find dialog’s…
- Find a Name in Excel: Search, Match, and TroubleshootTo find a name in an Excel spreadsheet, press Ctrl+F on Windows, type the name, and select Find Next or Find All.…
- Find Duplicates in Excel with VLOOKUPTo find values in one Excel list that also appear in another, use VLOOKUP with an exact match: with values in A2:A100…
- Find a Name in Excel with a FormulaTo check whether a name appears in an Excel list, use COUNTIF; to return information associated with a name, use XLOOKUP. For…
- Find a Name in Excel: Search and Match MethodsTo find a name in an Excel sheet, press Ctrl+F on Windows, type the name, and press Enter or choose Find Next;…
- Find the Max Date in Excel: Formula, Filters, and FixesTo find the latest date in Excel, put your dates in a range such as B2:B20, then enter =MAX(B2:B20) in an empty…