Formulas & functions
How a function works, with worked examples you can paste.
- Excel Protected Sheet Sort: Settings, Limits, and FixesTo sort a protected Excel worksheet, choose Review > Protect Sheet, allow users to sort, and protect the sheet. There is an…
- Excel Protect Sheet: What to Do If You Forgot the PasswordIf you forgot an Excel worksheet password, Microsoft Excel has no built-in way to reveal or reset it: ask the person who…
- Excel Protect Sheet: Let a Table Expand SafelyIn Excel for Microsoft 365 on Windows, there is no built-in Protect Sheet setting that reliably lets people add rows to an…
- Excel Print Area Formula: Set a Dynamic Print RangeExcel has no worksheet formula that sets a print area: print areas are page settings, not cell calculations. To make one expand…
- Excel Power Query VLOOKUP: Match Tables and RefreshExcel Power Query does not run the VLOOKUP function inside a query; instead, use Merge Queries to match rows in two tables…
- Excel Power Query IF Statements: Examples and RulesIn Excel Power Query, an IF expression uses M language syntax: if condition then value_if_true else value_if_false. Add it as a custom…
- Wedding Budget Spreadsheet for 50 Guests: Costs & FormulasA practical wedding budget spreadsheet for 50 guests should list each cost, its planned amount, the latest expected total, and what has…
- 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…