Formulas & functions
How a function works, with worked examples you can paste.
- Excel Formula for MID: Extract Text Like a ProThe Excel formula for extracting text from the middle of a string is =MID(text, start_num, num_chars). For example, =MID("Excel is powerful", 7,…
- Excel Formula for Mileage Calculation: How ToThe core Excel formula for mileage calculation is simple: =EndOdometer - StartOdometer for distance, or =MilesDriven * RatePerMile for reimbursement. For a…
- Excel Formula to List Items in a ColumnThe simplest Excel formula to list items in a column is =A1 entered in the first cell of the target column, then…
- Excel Formula for Loan Payment Calculation: PMT ExplainedThe Excel formula for loan payment calculation is =PMT(rate, nper, pv), where rate is the periodic interest rate, nper is the total…
- Excel Formula for Listing Items: 5 Real MethodsThe fastest way to list items in Excel is to use the =UNIQUE(range) formula to extract distinct values, or simply type your…
- Excel Formula for Last Name: Extract SurnameThe simplest Excel formula to extract a last name from a full name is =TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",99)),99)), assuming the name is in…
- Excel Formula for Left of CharacterThe simplest Excel formula to extract text to the left of a specific character is =LEFT(A1, FIND("char", A1) - 1). For example,…
- Excel Formula for Letter Grade: IF, IFS, VLOOKUPThe most direct Excel formula for a letter grade is a nested IF statement, for example =IF(A1>=90,"A",IF(A1>=80,"B",IF(A1>=70,"C",IF(A1>=60,"D","F")))) when the numeric score is…
- Excel Formula for Inventory Tracking: Top MethodsThe core Excel formula for inventory tracking is a running balance using =SUMIF for totals or a simple =C2-D2+E2 for item-level stock…
- Excel ISBLANK Function: Formula & How to Use ItThe Excel formula for checking if a cell is blank is =ISBLANK(cell). For example, =ISBLANK(A1) returns TRUE if A1 is empty and…
- Excel Running Total Formula: How to Keep a Running TotalThe simplest Excel formula for a running total is =SUM($B$2:B2) entered in cell C2 and copied down, assuming your values are in…
- Excel Formula for Grade Scale: A Complete GuideThe simplest Excel formula for a grade scale uses IFS to map a numeric score to a letter grade. For example, with…
- Excel Formula for Grade Range: Nested IF & IFSThe fastest way to assign a letter grade to a numeric score in Excel is a nested IF formula, for example =IF(A2>=90,"A",IF(A2>=80,"B",IF(A2>=70,"C",IF(A2>=60,"D","F")))).…
- Excel Formula for Grades: A Complete GuideThe most direct Excel formula for grades is =IF(A2>=90,"A",IF(A2>=80,"B",IF(A2>=70,"C",IF(A2>=60,"D","F")))), which converts a numeric score in cell A2 into a letter grade. For…
- Excel Formula for Grade Average: A Complete GuideThe simplest Excel formula for a grade average is =AVERAGE(range), for example =AVERAGE(B2:B10) when grades are in cells B2 through B10. This…
- Excel Formula for Grade Calculation: A Complete GuideThe most direct Excel formula for calculating a final grade from weighted components is =SUMPRODUCT(weights_range, scores_range), where weights are percentages that sum…
- Excel Formula for Financial Quarter (Easy Steps)The simplest Excel formula to return the financial quarter from a date in A1 is =ROUNDUP(MONTH(A1)/3,0), which gives 1–4 based on a…
- Excel Formula for Fiscal Year: Step-by-Step GuideThe simplest Excel formula for determining a fiscal year is =YEAR(A2)+(MONTH(A2)>=FiscalStartMonth), where A2 contains the date and FiscalStartMonth is the month number…
- Excel Formula for Expense Report? Simple & Pro TipsThe core Excel formula for an expense report is =SUM(range) to total a column of amounts, but a truly useful report combines…
- Excel Formula for Days Left Till DateThe simplest Excel formula for days left until a date is =DATE(2025,12,31)-TODAY(), which returns the number of days between today and the…
- Excel Formula for Depreciation CalculationThe core Excel formula for straight-line depreciation is =(cost - salvage) / life, where cost is the asset’s purchase price, salvage is…
- Excel Formula for Date Sequence: 4 Easy WaysThe simplest Excel formula for a date sequence is =A2+1 entered in cell A3, assuming A2 holds your starting date, then dragging…
- Excel Formula for Days Left in MonthThe simplest Excel formula for days left in the current month is =EOMONTH(TODAY(),0)-TODAY(). This returns the number of days from today until…
- Excel Formula for Counting Unique Text ValuesThe fastest way to count unique text values in Excel is =SUMPRODUCT((COUNTIF(range,range)>0)/COUNTIF(range,range)) for Excel 2019 and earlier, or =COUNTA(UNIQUE(range)) if you have…
- Excel Formula for Creating a CalendarThe simplest Excel formula for creating a calendar is =SEQUENCE(6,7) combined with date arithmetic, but the most practical approach uses =LET(d, DATE(year,…
- Excel Formula for Date Minus Date: Days BetweenThe core Excel formula for subtracting one date from another is simply =B2-A2, where B2 holds the later date and A2 holds…
- Excel Formula for Counting Unique CellsThe simplest Excel formula for counting unique cells is =SUMPRODUCT(1/COUNTIF(range, range)), which works in all versions of Excel. For Microsoft 365 or…
- Excel Formula for Counting Unique Text ValuesThe fastest formula for counting unique text values in Excel is =SUMPRODUCT(--(COUNTIF(range,range>"">0))) for a single column, but the modern and clearest method…
- Excel Formula for Checking if Cells Match? (Guide)The simplest Excel formula for checking if two cells match is =A1=B1, which returns TRUE if the values are identical and FALSE…
- 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…