Formulas & functions
How a function works, with worked examples you can paste.
- Excel Formulas with Table References: A Complete GuideExcel formulas with table references use structured references like =SUM(Table1[Sales]) instead of cell addresses like =SUM(B2:B100). These references automatically adjust when you…
- Excel Function for Unique Count: UNIQUE & COUNTAThe quickest way to count unique values in Excel is to combine the UNIQUE function with COUNTA: =COUNTA(UNIQUE(range)). For example, if your…
- Excel Function to Lowercase? Use LOWERThe Excel function to convert text to lowercase is LOWER. For example, =LOWER("HELLO") returns hello, and you can apply it to any…
- Excel Formulas to Compare Data: Top MethodsThe fastest way to compare data in Excel is to use the IF function for row-by-row checks (e.g., =IF(A2=B2,"Match","No Match")) or VLOOKUP/XLOOKUP…
- Excel Named Ranges: Formulas That WorkYes, you can use formulas inside named ranges in Excel, but with a key distinction: a named range can refer to a…
- Excel Formula Has Text? How to Check & Use ItYes, an Excel formula can return text, and you can check whether a cell contains text using the ISTEXT function. For example,…
- Excel Formulas for Budget Sheet: Top 10 to KnowThe fastest way to build a budget in Excel is to use =SUM for totals, =SUMIF to total by category, and =B2-C2…
- Excel Formulas Not Updating? Fixes That WorkIf your Excel formulas are not updating, the most common cause is that calculation mode is set to Manual instead of Automatic.…
- XLOOKUP Formula in Excel: How to Use ItThe XLOOKUP formula in Excel is =XLOOKUP(lookup_value, lookup_array, return_array). For example, =XLOOKUP("A-100", A2:A10, B2:B10) finds “A-100” in cells A2:A10 and returns the…
- Excel Formula Hard Return: How to Add Line BreaksThe direct answer: in Excel, a hard return inside a cell (a line break) is inserted with Alt+Enter on Windows or Control+Option+Return…
- Excel Formula for Weekday: Get Day of WeekThe core Excel formula for a weekday is =WEEKDAY(date), which returns a number from 1 (Sunday) to 7 (Saturday) by default. To…
- Excel Formula for Weekday Based on DateThe simplest Excel formula to get the weekday from a date is =WEEKDAY(date). For example, if cell A1 contains 15-Jul-2024, =WEEKDAY(A1) returns…
- Excel Formula for Workdays in a MonthThe simplest Excel formula for workdays in a month is =NETWORKDAYS(start_date, end_date). For example, =NETWORKDAYS(DATE(2025,1,1), DATE(2025,1,31)) returns 23 for January 2025, because…
- Excel Formula for Transpose: 3 Easy WaysThe simplest Excel formula for transposing data is =TRANSPOSE(array), entered as an array formula by pressing Ctrl+Shift+Enter (or just Enter in Excel…
- Excel Formula for Sales Tax CalculationThe simplest Excel formula for sales tax is =A2*B2 where A2 holds the pre-tax price and B2 holds the tax rate as…
- Excel Formula for Savings Growth: FV & MoreThe core Excel formula for savings growth is =FV(rate, nper, pmt, [pv], [type]), where you plug in the periodic interest rate, number…
- Excel Formula for Tax Calculation: The Complete GuideThe core Excel formula for tax calculation is =A2*B2, where A2 contains the taxable amount and B2 contains the tax rate as…
- Excel ROUNDUP Formula: 10 Ways to Use ItThis article lists 10 practical ways to use Excel’s ROUNDUP function, from basic rounding to combining it with other functions for real-world…
- Excel Running Balance Formula: Step-by-Step GuideThe simplest Excel formula for a running balance is =SUM($B$2:B2) for a cumulative total of deposits/withdrawals, or =C2+D2-E2 for a starting balance…
- Excel Running Total Formula: Step-by-StepThe simplest Excel formula for a running total in a column is =SUM($B$2:B2) entered in the first data row and copied down.…
- Excel Formula for Quarterly Payments: How to CalculateThe simplest Excel formula for a quarterly payment is =PMT(rate, nper, pv), where rate is the quarterly interest rate, nper is the…
- Excel Formula for Retirement Savings: How to CalculateThe core Excel formula for retirement savings is the future value (FV) function: =FV(rate, nper, pmt, [pv], [type]). For example, =FV(0.06/12, 30*12,…
- Excel Formula for Roman Numbers: A Complete GuideThe Excel formula to convert a number to a Roman numeral is =ROMAN(number), and to convert a Roman numeral back to a…
- Excel Formula for Over Budget? Simple IF CheckThe quickest Excel formula to flag an over-budget item is =IF(B2>C2,"Over","OK"), where B2 holds the actual spend and C2 holds the budget.…
- Excel Formula for Next Year Calendar?The simplest Excel formula for a next-year calendar is =DATE(YEAR(TODAY())+1,1,1), which returns the first day of next year as a real date.…
- Excel Formula for NPV: How to Use ItThe Excel formula for net present value (NPV) is =NPV(rate, value1, [value2], ...). For example, if your discount rate is in cell…
- Excel Formula for Mileage ReimbursementThe simplest Excel formula for mileage reimbursement is =B2*C2 when column B holds miles driven and column C holds the reimbursement rate…
- Excel Formula for Multiple IFs (Nested IF & IFS)The direct answer: use the IFS function for most multiple-condition logic, or nest IF functions when you need different results per condition.…
- Excel Formula for Mortgage Amortization?The core Excel formula for mortgage amortization is =PMT(rate, nper, pv), which calculates the fixed monthly payment. To build a full amortization…
- Excel Formula for Lookup and Match: Top MethodsThe core Excel formula for lookup and match is =INDEX(range, MATCH(lookup_value, lookup_array, 0)), which returns a value at the intersection of a…