Formulas & functions
How a function works, with worked examples you can paste.
- Excel XLOOKUP Examples for Common Spreadsheet TasksMicrosoft Excel’s XLOOKUP finds a value in one range and returns the corresponding value from another. For example, with product IDs in…
- Excel XLOOKUP Examples: Formulas and TipsMicrosoft Excel’s XLOOKUP finds a value in one range and returns the corresponding value from another; for example, =XLOOKUP(D2,A2:A6,B2:B6,"Not found") looks for…
- Minimum Sample Size Formula: How to Calculate ItThe minimum sample size depends on what you are estimating or testing. For a proportion in a large population, a common starting…
- Microsoft Excel Lookup Function Examples That WorkFor most exact-match lookups in Microsoft Excel for Microsoft 365, use XLOOKUP: with product codes in A2:A6, prices in C2:C6, and the…
- Microsoft Excel SUMIF Examples and How to Use ThemIn Microsoft Excel, SUMIF adds values that meet one condition. For example, with categories in A2:A6 and amounts in B2:B6, =SUMIF(A2:A6,"Rent",B2:B6) adds…
- Median Formula for Class 10: Examples and StepsThe median is the middle value after data has been arranged in order. For ungrouped data, use the middle observation (or average…
- Median Formula Examples in Excel and by HandThe median is the middle value after a set of numbers is arranged from smallest to largest; with an odd number of…
- Excel LAMBDA Formula Examples for Reusable FunctionsExcel LAMBDA lets you turn a calculation into a reusable function, so you can name it once and call it like a…
- SUMPRODUCT IF Function: How to Sum with ConditionsNo, Excel does not have a separate SUMPRODUCTIF or “SUMPRODUCT IF” function. To sum values that meet conditions, use SUMPRODUCT with logical…
- ISBLANK Formula Examples in ExcelIn Excel, ISBLANK checks whether a referenced cell is genuinely empty and returns TRUE or FALSE. For example, with a cell to…
- Excel INDEX MATCH Examples and How to Use ThemIn Excel, INDEX MATCH looks up a value by finding its position with MATCH and returning the value at that position with…
- INDIRECT Excel Function: Examples, Uses, and LimitsIn Excel, INDIRECT converts text into a live cell or range reference; if A2 contains B5, =INDIRECT(A2) returns the value in B5.…
- IFS Excel Formula Examples: Syntax, Rules, and TipsExcel’s IFS function checks conditions in order and returns the value linked to the first condition that is true. For example, with…
- IF Function in Excel: Examples and Practical UsesIn Excel, the IF function checks whether a condition is true and returns one result if it is, or another if it…
- COUNTIF in Excel: Examples and How to Use It Step by StepTo count cells that match one condition in Excel, use =COUNTIF(A2:A11,"Apple"). With fruit names in A2:A11, this returns the number of cells…
- EDATE in Excel: Add or Subtract Months from a DateIn Excel, EDATE returns a date that is a specified number of months before or after a starting date. Use the syntax…
- HLOOKUP Examples in Excel: Formulas and Common FixesIn Excel, HLOOKUP searches across the first row of a range and returns a value from a specified row beneath the matching…
- FV Examples in Excel: Formula and Worked ExamplesExcel’s FV function calculates the future value of money invested or saved at a steady interest rate. For example, with an annual…
- Gtt per Min Formula: Examples and Safe CalculationThe gtt per min formula is gtt/min = (mL × drop factor in gtt/mL) ÷ time in minutes. For example, 500 mL…
- Excel XLOOKUP Practice Examples: Formulas and TipsExcel XLOOKUP practice examples are easiest to learn by matching a lookup value to a column and returning a related result with…
- Excel XLOOKUP Formula Examples for Everyday LookupsExcel’s XLOOKUP function finds a value in one range and returns a related value from another. For example, with product IDs in…
- Excel XLOOKUP Function Examples for Everyday LookupsIn Excel for Microsoft 365, XLOOKUP finds a value in one range and returns the corresponding value from another. With IDs in…
- Excel WORKDAY Function Examples for Real DeadlinesExcel’s WORKDAY function calculates a date a specified number of working days before or after a starting date, skipping weekends and any…
- Excel XLOOKUP Between Two Worksheets: ExamplesIf your lookup value is on one worksheet and the data to search is on another, XLOOKUP can connect them directly. With…
- Excel Wildcard SUMIF Formula Examples That Match TextTo total values for text that contains a word, use SUMIF with asterisks around the word: with product names in A2:A8 and…
- Excel VLOOKUP Examples With a Drop-Down ListTo make a drop-down selection drive a lookup in Excel for Microsoft 365 on Windows, create a list with Data > Data…
- Excel SUMIF Criteria Examples for Text, Dates, and NumbersExcel’s SUMIF function adds values when one matching condition is true. With categories in A2:A7 and amounts in B2:B7, use =SUMIF(A2:A7,"Fruit",B2:B7) to…
- Excel SUMIF Formula Examples for Everyday TasksExcel’s SUMIF function adds values that meet one condition. With regions in A2:A7 and sales amounts in B2:B7, use =SUMIF(A2:A7,"North",B2:B7) to total…
- Excel SUBTOTAL Formula Examples for Filtering and TotalsWith sales values in B2:B6, use =SUBTOTAL(9,B2:B6) to add them; for the example values 120, 80, 150, 70, and 180, the result…
- Excel Sort Examples: Rows, Text, Dates, and Custom ListsTo sort a worksheet in Excel for Microsoft 365 on Windows, select a cell in the data, then choose Data > Sort…