Formulas & functions
How a function works, with worked examples you can paste.
- Truck Mileage Log Spreadsheet: Setup and FormulasA truck mileage log spreadsheet is a simple way to record each trip’s date, vehicle, odometer readings, miles, and business purpose. In…
- Excel Power Query Custom Column IF: M Formula GuideIn Excel Power Query, create an if/then/else condition in a custom column with an M expression such as if [Quantity] > 0…
- Wedding Budget Spreadsheet: Sample, Formulas & SetupA useful wedding budget spreadsheet lists each expense, the amount set aside, the latest estimate, the contracted or final cost, and payments…
- Project Budget Tracker Spreadsheet: Setup and FormulasA project budget tracker spreadsheet compares the approved budget with actual spending and outstanding commitments, so you can see whether the project…
- Monthly Expense Tracker Spreadsheet: Setup and FormulasA monthly expense tracker spreadsheet records what you spend, groups transactions into categories, and totals them for a selected month. In Excel…
- Jersey Inventory Counting Spreadsheet: Setup and FormulasTo make a jersey inventory counting spreadsheet in Excel, give each distinct jersey variant its own row and record its expected quantity…
- Inventory Tracking Spreadsheet: Setup, Formulas, and TipsAn inventory tracking spreadsheet is a worksheet that records what items you have, where they are, and when stock needs attention. In…
- Inventory Spreadsheet Tracker: Setup, Formulas and ExamplesAn inventory spreadsheet tracker is a structured workbook for recording what items you have, where they are, and when stock needs replenishing.…
- Inventory Invoice Spreadsheet: Fields, Formulas, and UseAn inventory invoice spreadsheet is a workbook for recording supplier invoice lines and checking them against the goods received. Set it up…
- Free Snowball Debt Spreadsheet: Formulas and SetupYes. You can build a free snowball debt spreadsheet in Excel with a blank workbook and the formulas below: enter each balance,…
- Excel Merge Text From Two Cells: Formulas and TipsTo merge text from two cells in Excel, join their references with the ampersand operator: if the text is in A2 and…
- Excel Data Table Analysis: Compare What-If ScenariosExcel data table analysis is a What-If Analysis tool that recalculates a formula across a range of one or two changing inputs.…
- Caleb Hammer Budget Spreadsheet: How to Find the Right OneIf you’re looking for a Caleb Hammer budget spreadsheet, verify any download through Caleb Hammer’s official website or the description of the…
- Excel Compare Two Columns on Two Sheets: Formula GuideTo compare values in the same row on two worksheets, enter =IF(A2='Sheet 2'!A2,"Match","Different") in a helper column on the first sheet and…
- Budget Spreadsheet Sample: Monthly Template and FormulasA useful budget spreadsheet sample has columns for each category’s planned amount, actual amount, and difference, plus totals for income, spending, and…
- Excel Conditional Formatting With IF FormulasYes—Excel conditional formatting can use an IF statement, but it usually does not need one. Create a formula-based rule that evaluates to…
- XLOOKUP With Multiple Criteria: Formulas and ExamplesTo look up a row that meets multiple criteria in Excel, multiply the criteria tests inside XLOOKUP: =XLOOKUP(1,(A2:A100=H2)*(B2:B100=H3),C2:C100,"Not found"). This returns the…
- VLOOKUP With Multiple Criteria: Excel FormulasIf your table has Product in column B, Region in C, Sales in D, and a combined lookup key in A, use…
- IFERROR with XLOOKUP: Formula, Examples, and FixesWith the lookup value in E2, keys in A2:A5, and return values in B2:B5, use =IFERROR(XLOOKUP(E2,A2:A5,B2:B5),"Not found"). It returns the matching value,…
- How to Use XLOOKUP in Excel: A Step-by-Step Formula GuideTo retrieve a value with XLOOKUP, identify the value to search for, the range where it appears, and the range containing the…
- Merge the Contents of Two Cells in Excel with a FormulaTo combine the contents of two Excel cells without losing either value, enter a formula in a third cell. For example, if…
- COUNTIFS Formula for Date Range in Excel With ExamplesTo count dates within a range in Excel, use COUNTIFS with a start-date criterion and an end-date criterion. For a range that…
- Inventory Tracking Spreadsheet Template: Setup and FormulasAn inventory tracking spreadsheet template is a workbook for recording what you stock, where it is, and when to reorder it. In…
- COUNTIF Formula for Duplicates in Excel: Find and FlagTo flag every value that appears more than once in Excel, enter =COUNTIF($A$2:$A$100,A2)>1 in a helper column beside your data, then fill…
- Inventory Spreadsheet Software: How to Choose the Right ToolInventory spreadsheet software is a spreadsheet app—such as Microsoft Excel or Google Sheets—used to record stock, movements, locations, and reorder needs. It…
- VLOOKUP Between Two Sheets in Excel: How It WorksTo use VLOOKUP between two sheets in Excel, put the lookup value in one sheet and refer to the data range on…
- Index Match Across Two Sheets in Excel: A Practical GuideYes. In Excel, INDEX and MATCH can look up a value on one worksheet and return a related value from another. If…
- COUNTIF for X in a Cell: Exact or Partial MatchTo count cells whose entire value is x, use =COUNTIF(A2:A8,"x"); to count cells that contain x anywhere, use =COUNTIF(A2:A8,"*x*"). If you mean…
- Abby Lawson Budget Spreadsheet: Find the Right FileIf you’re looking for an Abby Lawson budget spreadsheet, the name alone does not identify a confirmed official download. Before using a…
- How to Paste a Formula in Excel and Keep It WorkingTo paste a formula in Excel, select the cell that contains it, press Ctrl+C, select the destination cell, and press Ctrl+V. Excel…