Formulas & functions
How a function works, with worked examples you can paste.
- Excel Formula to Find All Tab Names in Your WorkbookExcel has no built-in worksheet formula that directly returns every tab name. In Microsoft 365 for Windows, you can list them with…
- Excel Formula to Calculate Hours WorkedFor a shift that starts in B2, ends in C2, and has an unpaid break entered as a duration in D2, use…
- Excel Formula to Fill Blank Cells in a List AboveTo fill blank cells with the value from the row above in Excel for Microsoft 365, select the list, choose Home >…
- Excel Formula for Choosing a Random Name from a ListWith names in A2:A20, enter =INDEX($A$2:$A$20,RANDBETWEEN(1,ROWS($A$2:$A$20))) in an empty cell to choose one at random. Excel returns a name from that range;…
- Excel Formula to Check If a Value Is in a ListTo check whether a value in D2 appears anywhere in the list A2:A10, use =COUNTIF($A$2:$A$10,D2)>0. Excel returns TRUE if it finds the…
- Excel Percentage Change Formula: Examples and Common ErrorsTo calculate percentage change in Excel, subtract the old value from the new value, divide by the old value, and format the…
- Excel Formula to Calculate Percentage Change: ExamplesTo calculate percentage change in Excel, subtract the old value from the new value, then divide by the old value: =(B2-A2)/A2. If…
- Excel Formula to Calculate Total Hours WorkedTo calculate hours worked in Excel, subtract the start time from the end time and multiply by 24: =(B2-A2)*24. With a start…
- Excel Formula to Check Whether a Cell Matches a ListTo check whether a cell’s value appears in a list, use =COUNTIF($D$2:$D$10,A2)>0, assuming the value to check is in A2 and the…
- Excel Formula to Convert Minutes to HoursTo convert a number of minutes in cell A2 to decimal hours in Microsoft Excel, divide by 60: =A2/60. For example, if…
- Excel Formula to Add Dates in a Weekly Sequence AutomaticallyTo add dates in weekly sequence in Excel, enter a starting date in A2, then put =A2+7 in A3 and fill the…
- Excel Percent Change Formula and ExamplesTo calculate percent change in Excel, subtract the old value from the new value, then divide by the old value. If the…
- Excel Formula Returns FALSE Instead of a Value? Here’s WhyAn Excel formula often returns FALSE because an IF function has no value specified for the condition that fails. Add a third…
- Excel Formula to Add Dates in SequenceTo add dates in sequence in Excel, enter a starting date in A2, then enter =A2+1 in A3 and fill the formula…
- Excel SUMIFS Between Two Dates: Formula and ExamplesTo sum values in Excel between two dates, use SUMIFS with the date range as a criteria range and two criteria: one…
- Excel Formula to Return Yes If a Value Is in a ListWith the value to check in A2 and the allowed list in D2:D10, enter =IF(COUNTIF($D$2:$D$10,A2)>0,"Yes","No"). It returns Yes if A2 appears in…
- Excel Formula to Remove Duplicates From a List AutomaticallyWith values in A2:A20, enter =UNIQUE(A2:A20) in an empty cell to return one copy of each distinct value. Excel for Microsoft 365…
- Excel Formula for Percent Change CalculationWith the original value in B2 and the new value in C2, enter =(C2-B2)/B2 in D2 to calculate percent change; format D2…
- Excel Formula to Return Multiple Lookup ResultsTo return every row that matches a lookup value in Microsoft 365 Excel, use the FILTER function. For example, with lookup keys…
- Excel Formula List: Essential Functions With ExamplesAn Excel formula list is a practical reference for choosing the right calculation: use =SUM(B2:B6) to total a range, =AVERAGE(B2:B6) to find…
- Excel Formula List: Basic Functions, Uses, and ExamplesA basic Excel formula list includes SUM for totals, AVERAGE for means, COUNT and COUNTA for counting, MIN and MAX for extremes,…
- Excel Formula List in Hindi: Meanings, Uses and ExamplesAn Excel formula list in Hindi is a guide to common spreadsheet functions, their Hindi meanings, and examples of when to use…
- Excel Multiplication Formulas: Examples, Uses, and Common TipsTo multiply in Excel, use the asterisk (*) between values or cell references—for example, if A2 contains 6 and B2 contains 4,…
- Excel Formula List A to Z: Functions and Examples GuideAn Excel formula is an expression that begins with an equals sign; most formulas use functions such as SUM, IF, or XLOOKUP…
- Excel Formula to Return Text Left of a Character in a CellTo return the text to the left of a character in Excel, use =LEFT(A2,FIND("-",A2)-1), replacing A2 with the cell you want to…
- Excel SUMIF for Text: Match and Join Text Values EasilyExcel has no SUMIF function that adds text strings, but in Microsoft 365 you can use TEXTJOIN with FILTER to return the…
- Excel Formula: Check If a Value Is in a ListIf the value to check is in A2 and your list is in D2:D10, use =IF(COUNTIF($D$2:$D$10,A2)>0,"In list","Not in list"). It returns “In…
- Excel Formula for Workdays Between Dates: NETWORKDAYSUse Excel’s NETWORKDAYS function to count Monday-to-Friday workdays between two dates, optionally excluding holidays: =NETWORKDAYS(start_date,end_date,[holidays]). It counts both the start and end…
- Excel Formula Keyboard Shortcuts and How to Use ThemThe most useful Excel formula shortcuts on Windows are Alt+= to insert AutoSum, F2 to edit a cell, F4 to cycle a…
- Excel Formula for Tracking Hours in a Daily TimesheetFor a basic Excel timesheet, put a start time in B2 and an end time in C2, then enter =(C2-B2)*24 in D2…