Formulas & functions
How a function works, with worked examples you can paste.
- Rank in Excel: Formula Examples, Ties, and Sort OrderTo rank values in Excel, use RANK.EQ: with scores in B2:B6, enter =RANK.EQ(B2,$B$2:$B$6,0) in C2 and fill down. The formula ranks the…
- ISERROR in Excel: Check for Errors in Your FormulasIn Excel, use ISERROR to check whether a value or calculation produces an error: enter a formula such as =ISERROR(A2/B2) and Excel…
- Excel ISBLANK Function Example: Formulas and TipsIn Excel, use =ISBLANK(A2) to test whether cell A2 is genuinely empty; it returns TRUE if the cell has no content and…
- LARGE and SMALL Excel Formulas: Find Ranked ValuesUse Excel’s LARGE and SMALL functions to return the value at a chosen rank in a set of numbers: =LARGE(B2:B9,1) returns the…
- LEFT, RIGHT and MID Formulas in Excel: How to Use ThemUse LEFT to return characters from the start of a text value, RIGHT to return them from the end, and MID to…
- Excel TRIM LEN Formula: Count Characters After CleanupTo count the characters in text after removing extra spaces, put the text in A2 and enter =LEN(TRIM(A2)) in another cell. TRIM…
- Excel AGGREGATE Formula: Two Practical Examples ExplainedUse Excel’s AGGREGATE function to calculate a result while choosing whether to ignore errors, hidden rows, or both. For example, =AGGREGATE(9,6,A2:A8) adds…
- Excel RIGHT, LEFT, and MID Formulas: Syntax and ExamplesIn Excel, RIGHT extracts characters from the end of text, LEFT extracts them from the beginning, and MID extracts characters from a…
- Excel Subtotal Filtered Rows: Formula, Steps, and FixesYes. In Excel for Microsoft 365 on Windows, use the SUBTOTAL function to calculate from rows that remain visible after filtering. With…
- Add a Subtotal Row to an Excel Table the Right WayTo add a total row to an Excel table in Microsoft 365 for Windows, click anywhere in the table, open Table Design,…
- Show Formulas in Excel Print: Steps and FixesTo show formulas in an Excel printout, turn on Show Formulas for the worksheet, then print it as usual. In Excel for…
- Show Formulas in Excel: Steps for Windows, Mac, and WebTo show formulas instead of calculated results in Excel, open the Formulas tab and select Show Formulas in the Formula Auditing group,…
- How to Show Formulas in Excel for MacTo show formulas in Excel for Mac, open the worksheet and choose Formulas > Show Formulas. You can also press Control+grave accent…
- How to Add Single Quotes in an Excel Formula CorrectlyIf A2 contains North and you want the result to display as ‘North’, enter this formula in B2: ="'"&A2&"'". Excel uses double…
- How to Add Parentheses in Excel Formulas CorrectlyTo add parentheses in an Excel formula, edit the cell, type an opening parenthesis where you want a calculation grouped, then type…
- Excel SUM: How to Add Numbers with a FormulaTo add numbers in Excel, select the cell where you want the total, type a SUM formula, and press Enter. For example,…
- Add a Formula in Excel to Calculate DatesTo calculate a date in Excel, enter a starting date in one cell and use a formula such as =A2+7 to return…
- How to Add a Formula to an Entire Row in ExcelTo add a formula across a row in Excel, enter it in the first cell where you want a result, select that…
- How to Add a Formula in Excel for Addition: Simple StepsTo add numbers in Excel, select the cell where you want the answer, type a formula that starts with an equals sign,…
- Excel QuickBooks: How to Add Formulas to Your DataTo add a formula to QuickBooks data in Excel, open the exported spreadsheet, select an empty cell, type a formula beginning with…
- How to Add Double Quotes in an Excel Formula for TextTo show double quotation marks in text produced by an Excel formula, type each quote mark twice inside the formula’s text string.…
- How to Add a Formula in an Excel ColumnTo add a formula to an Excel column, enter it in the first row that needs a result, press Enter, then copy…
- Excel Absolute Reference: How to Lock a Cell in a FormulaTo make a cell reference absolute in Excel, put a dollar sign before both its column letter and row number, such as…
- What-If Analysis in Excel: A Step-by-Step GuideTo add what-if analysis in Excel, open the Data tab and choose Forecast > What-If Analysis, then select Goal Seek, Scenario Manager,…
- NPV Analysis in Excel: Formula, Steps, and ExampleTo calculate net present value in Excel, enter the discount rate in one cell, put the initial investment and later cash flows…
- Excel Growth Analysis: Formulas, Trends, and ExamplesExcel growth analysis measures how a value changes over time. For two consecutive values in B2 and B3, with B2 as the…
- Extract Middle Text in Excel: Formulas and ExamplesTo extract text from the middle of a cell in Excel, use MID: with the source text in A2, =MID(A2,4,5) returns five…
- Extract Part of Text in Excel: Formulas and StepsTo extract part of text in Excel, use LEFT, RIGHT, or MID for characters in known positions, and TEXTBEFORE or TEXTAFTER for…
- Excel Extract Text Between Quotes with FormulasIf the text is in A2, use =IFERROR(TEXTBEFORE(TEXTAFTER(A2,""""),""""),"") in Microsoft 365 or Excel 2024 to return the text between the first pair…
- Remove Spaces at the End of Text in Excel with TRIMTo remove ordinary spaces at the end of text in Excel, put =TRIM(A2) in a helper column if the text is in…