Formulas & functions
How a function works, with worked examples you can paste.
- VLOOKUP Excel Grading: Match Scores to Letter GradesTo assign a letter grade from a numeric score in Excel, put the grade cutoffs in ascending order and use an approximate-match…
- VLOOKUP in Excel: How to Apply It and Avoid ErrorsTo apply VLOOKUP in Excel, enter =VLOOKUP(E2,A2:C6,3,FALSE) in a blank cell when the value to find is in E2, the lookup table…
- VLOOKUP Excel Extended Range: How to Expand ItTo extend a VLOOKUP range, enlarge its table_array so it includes the added rows, or convert the source data to an Excel…
- VLOOKUP col_index_num: How to Choose the Right NumberIn Excel’s VLOOKUP function, col_index_num is the number of the column to return from the selected table range, counting from that range’s…
- VLOOKUP Exact Match in Excel: How to Use ItTo make VLOOKUP find an exact match in Excel, set its fourth argument to FALSE (or 0). For example, with the lookup…
- VLOOKUP Excel Example: Look Up Data Across Two SheetsTo look up a value from one Excel sheet in another, use VLOOKUP with the source sheet in the table-range argument. For…
- VLOOKUP Between Two Sheets in Excel: A Practical GuideTo look up a value from one Excel sheet on another, enter a VLOOKUP formula such as =VLOOKUP(A2,Products!$A$2:$C$100,3,FALSE). This example searches for…
- VLOOKUP Between Two Excel Workbooks: A Simple GuideYes. In Excel for Microsoft 365 on Windows, VLOOKUP can search a table in another workbook by using an external workbook reference;…
- VLOOKUP Across Sheets in Excel: Formulas and FixesTo use VLOOKUP across sheets in Excel, enter a formula such as =VLOOKUP(A2,Products!$A$2:$D$100,3,FALSE) on the sheet where you want the answer. It…
- How to Use CONCAT in Excel to Join TextTo join text in Excel, enter a formula such as =CONCAT(A2," ",B2) in an empty cell, replacing A2 and B2 with the…
- How to Use the NOT Function in Excel: A Practical GuideTo reverse a logical value in Excel, use the NOT function: with TRUE in A2, enter =NOT(A2) in another cell to return…
- Excel LEFT Function: How to Extract Text from the StartTo return characters from the beginning of text in Excel, enter =LEFT(A2,3) in a cell, replacing A2 with the source cell and…
- Excel Formula for Tomorrow’s Date: TODAY()+1 ExplainedIn Excel, use =TODAY()+1 to return tomorrow’s date. Enter it in a cell and format that cell as a date if Excel…
- Excel Formula for Variance Between Two CellsTo calculate the difference between two cells in Excel, subtract one from the other: with the earlier or starting value in A2…
- Excel LEN Function: Count Characters in Cells EasilyTo count the characters in a cell, put the text in A2, select another cell, and enter =LEN(A2). Excel returns the number…
- Excel Formula for Time Duration: Calculate Hours EasilyIf the start time is in A2 and the end time is in B2, subtract the start from the end: =B2-A2. Format…
- Excel Standard Deviation Formula: Which Function to UseIn Excel for Microsoft 365, use STDEV.S to calculate standard deviation from a sample, or STDEV.P when your data includes the entire…
- Excel Formula for Start of Month: Dates, Examples & TipsTo return the first day of the month for a date in cell A2, use =DATE(YEAR(A2),MONTH(A2),1). If A2 contains November 18, 2026,…
- Excel Formula for Splitting Text in a Cell by DelimiterIn Microsoft 365 or Excel 2024, use TEXTSPLIT to divide text from one cell into separate cells. If A2 contains Mira Chen,…
- Excel Sentence Case Formula: One Sentence or Many?For a cell in A2, use =UPPER(LEFT(A2,1))&LOWER(MID(A2,2,LEN(A2))) to capitalize the first character and make the rest lowercase. This handles one sentence—or the…
- Excel Formula for Rounding Numbers: ROUND and MoreUse Excel’s ROUND function to round a number to a chosen number of decimal places: with the value in A2, enter =ROUND(A2,2)…
- How to Use the Search Function in Excel: Find Data FastTo find something in an Excel worksheet, press Ctrl+F on Windows (Command+F on Mac), type the text or value, and choose Find…
- Excel MONTH Function: Extract the Month from a DateTo get the month number from a date in Excel, enter =MONTH(A2) in another cell, assuming A2 contains a valid Excel date;…
- Excel WORKDAY Function: Calculate Business-Day DatesUse Excel’s WORKDAY function to calculate a date a set number of working days before or after another date, while skipping weekends…
- Excel MAX Function: Find the Highest Value in a RangeTo find the largest number in Excel, enter a formula such as =MAX(B2:B10) in an empty cell, replacing the range with the…
- Excel INDIRECT Function: How to Use It with Cell ReferencesTo make Excel interpret text as a cell reference, use INDIRECT. With “B3” in A1 and 42 in B3, enter =INDIRECT(A1) in…
- Excel LAMBDA Function: Create and Reuse Custom FormulasTo use Excel’s LAMBDA function, define a calculation with named inputs, save it as a workbook name, and call that name like…
- Excel LET Function: How to Name and Reuse CalculationsUse Excel’s LET function to give a name to a value or calculation, then use that name elsewhere in the same formula.…
- Gross Margin Percentage Formula in Excel: A Clear GuideTo calculate gross margin percentage in Excel, subtract cost of goods sold (COGS) from revenue, then divide the result by revenue. If…
- Excel CLEAN Function: Remove Nonprinting CharactersTo remove nonprinting characters from text in Excel, enter =CLEAN(A2) in a helper cell when the source text is in A2. CLEAN…