Formulas & functions
How a function works, with worked examples you can paste.
- Excel Formula for Counting Calendar Days: The Easy WayThe simplest Excel formula for counting calendar days between two dates is =B2-A2 (where B2 is the later date and A2 is…
- Excel Formula for Checking if Cell Is BlankThe simplest Excel formula for checking if a cell is blank is =ISBLANK(A1), which returns TRUE if A1 is empty and FALSE…
- Excel Formula for Checking Account RegisterThe core formula for a checking account register in Excel is a running balance: =SUM($C$2:C2) (or =C2 for the first row) placed…
- Excel Formula for Checking Duplicates? (2025 Guide)The quickest Excel formula to check for duplicates is =COUNTIF(A:A, A2)>1 in a helper column, which returns TRUE for any value that…
- Excel Formula for Checking If a Cell Is EmptyThe simplest Excel formula for checking if a cell is empty is =ISBLANK(A1), which returns TRUE if A1 is empty and FALSE…
- Excel Formula for Checkbox: How to Use ItThe simplest Excel formula for a checkbox is =IF(A1=TRUE,"Checked","Unchecked"), assuming the checkbox is linked to cell A1. To make a checkbox that…
- Excel Formula for Checkbook Register: Setup GuideThe core formula for a checkbook register in Excel is a running balance formula: =SUM($D$2:D2) entered in the Balance column, assuming deposits…
- Excel Formula for Checking Account? Track BalancesThe quickest formula to track a checking account in Excel is a running balance: with your starting balance in C2, deposits in…
- Excel Formula for Checkbook: Setup & ExamplesThe core Excel formula for a checkbook register is a running balance: =SUM($C$2:C2) for a deposit column and =SUM($D$2:D2) for a withdrawal…
- Excel Formula for Checkbook Balance? Simple StepsThe simplest Excel formula for a checkbook balance is =SUM(B2:B100) for deposits and =SUM(C2:C100) for withdrawals, then subtract the two: =SUM(B2:B100)-SUM(C2:C100). For…
- Excel Formula for Checkbook Ledger: Setup & ExamplesThe core Excel formula for a checkbook ledger is a running balance: =SUM($C$2:C2) entered in the balance column, where C contains deposits…
- Excel Formula for Calendar Days in a MonthThe simplest Excel formula for calendar days in a month is =DAY(EOMONTH(A1,0)), where A1 contains any date within that month. This returns…
- Excel Formula for Calculating TenureThe simplest Excel formula for calculating tenure in years is =YEARFRAC(start_date, end_date), which returns a decimal like 3.5 for three and a…
- Excel Formula for Calculating a Loan PaymentThe core Excel formula for calculating a loan payment is =PMT(rate, nper, pv), where rate is the periodic interest rate, nper is…
- Excel Formula for Calculating PercentileThe Excel formula for calculating a percentile is =PERCENTILE.INC(array, k) for inclusive percentiles (0 to 1 inclusive) or =PERCENTILE.EXC(array, k) for exclusive…
- Excel Formula for Calculating QuarterThe simplest Excel formula for calculating the quarter from a date in cell A1 is =ROUNDUP(MONTH(A1)/3,0), which returns 1, 2, 3, or…
- Excel Formula for Budget Tracking: Simple SetupThe core Excel formula for budget tracking is =SUM(income range)-SUM(expense range) for a net total, or =SUMIF(range,"category",sum_range) to track spending by category.…
- Excel Formula for Adding Calendar Days: Simple StepsThe simplest Excel formula for adding calendar days to a date is =A2+7 (to add 7 days) or =A2+30 (to add 30…
- Excel Formula for BMI Calculation (Step-by-Step)The Excel formula for BMI (Body Mass Index) is =weight_kg/(height_m^2) when your data is in kilograms and meters. If your weight is…
- Excel COUNTIF Not Equal to Text: Formula & ExamplesThe direct answer: use =COUNTIF(range,"text") to count cells in a range that do not equal a specific text value. For example, =COUNTIF(A2:A20,"Pending")…
- Excel Formula Due Date Calculator: How to Set One UpThe quickest way to calculate a due date in Excel is to add days to a start date with a simple formula…
- Excel COUNTIF Contains Partial Text: Formula GuideThe formula to count cells containing partial text in Excel is =COUNTIF(range,"*text*"). Replace range with your cell range and text with the…
- Excel Conditional Formatting IF False: Formula & FixesThe direct answer: Excel’s conditional formatting does not have a built-in “IF false” rule, but you create one by writing a formula…
- Excel COUNTIF: Count Cells That Contain TextThe fastest way to count cells that contain any text in Excel is =COUNTIF(range,"*"), which counts every cell in the range that…
- Excel Formula to Capitalize Text: UPPER, PROPER, LOWERThe quickest way to capitalize text in Excel is with the UPPER function (all caps), the PROPER function (first letter of each…
- Excel Formula Checklist v6 AK16: Full GuideThe Excel formula checklist v6 AK16 refers to a specific version (v6) of a community-maintained formula auditing checklist, where “AK16” is the…
- Excel Formula Conditional Formatting by RowTo apply conditional formatting by row in Excel, use a formula that references the row’s first cell with a mixed reference (e.g.,…
- Excel Formula Budget Calculator: How to Build OneTo turn Excel into a budget calculator, use a simple formula like =SUM(B2:B13) to total your income and expenses, and =B14-B15 to…
- Excel Formula Budget Tracker: Setup & UseThe core of an Excel budget tracker is a simple formula: =SUM for totals and =B2-C2 for the difference between income and…
- Excel Fiscal Year Formula October: How to CalculateTo calculate the fiscal year in Excel when your fiscal year starts in October, use the formula =YEAR(A2)+(MONTH(A2)>=10) for a date in…