Formulas & functions
How a function works, with worked examples you can paste.
- WORKDAY Formula in Excel: How It Calculates Business DatesExcel’s WORKDAY function returns a date a specified number of working days before or after a starting date, skipping Saturdays, Sundays, and…
- Excel OFFSET Function: How It Works and When to Use ItExcel’s OFFSET function returns a reference to a cell or range a chosen number of rows and columns away from a starting…
- Excel OFFSET Function: How It Works and When to Use ItExcel’s OFFSET function returns a reference to a cell or range that lies a specified number of rows and columns from a…
- Excel LAMBDA: How It Works and How to Create FunctionsExcel’s LAMBDA function lets you turn a calculation into a reusable custom function, using named inputs and a formula you define. Write…
- DATEDIF in Excel: Calculate the Time Between DatesIn Excel, DATEDIF calculates the time between two dates in completed years, months, or days. Use the syntax =DATEDIF(start_date,end_date,unit); for example, it…
- How Excel SUMPRODUCT Works: Examples and Practical UsesExcel’s SUMPRODUCT function multiplies corresponding values in one or more arrays, then adds the resulting products. For example, it can calculate a…
- SUMIF in Excel: How It Works and How to Use ItIn Excel, SUMIF adds values that meet one condition: it checks a range against a criterion, then adds the corresponding values from…
- AVERAGEIF in Excel: How It Works and When to Use ItAVERAGEIF in Excel calculates the average of numbers that meet one condition. Give it a range to check, a criterion to apply,…
- How to Sort and Filter a Table in Excel Step by StepTo sort and filter an Excel table, select a cell in it and use the arrow in a column header: choose a…
- How to Round in Excel to 2 Decimal Places CorrectlyTo round a number to two decimal places in Excel, use the ROUND function: if the value is in A2, enter =ROUND(A2,2)…
- 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…