Formulas & functions
How a function works, with worked examples you can paste.
- Excel Formula: Add Days to a DateIf A2 contains a real Excel date, add a number of days in B2 with =A2+B2; for a fixed number, use =A2+10.…
- Excel Date Format Formulas: TEXT, DATEVALUE, and MoreTo display a date as text with an Excel formula, use TEXT; with a date in A2, =TEXT(A2,"mmmm d, yyyy") returns a…
- Excel Formula to Combine Text From Two Cells with a SpaceWith text in A1 and B1, join the contents directly with =A1&B1; to put a space between them, use =A1&" "&B1. Enter…
- Excel Character Count: Use the LEN FormulaTo count characters in an Excel cell, use the LEN function: if the text is in A2, enter =LEN(A2) in another cell.…
- Excel Formula Bot Free? Free Plans, Limits, and Safe UseYes—many Excel formula bots offer free access, but it is usually limited by usage, features, or account requirements. There is no single…
- Excel Business Days: NETWORKDAYS and WORKDAY FormulasTo count weekdays between two dates in Excel, use =NETWORKDAYS(B2,B3); for example, with a Monday start date in B2 and Friday end…
- Excel Formula to Return a Blank When No ValueYes. In Excel for Microsoft 365 on Windows, use an IF formula that returns an empty text string when the source cell…
- Excel Formula Between Two Numbers: ExamplesTo check whether a value in A2 is between a lower limit in B2 and an upper limit in C2, use =AND(A2>=B2,A2<=C2).…
- Excel Formula for All Caps: UPPER, Examples, and TipsTo make text all caps in Excel, use the UPPER function: with the text to convert in A2, enter =UPPER(A2) in another…
- Excel Absolute Value Formula: How ABS Works With ExamplesIn Excel, use the ABS function to return a number’s absolute value: it removes the number’s negative sign while leaving a positive…
- Excel Data Validation INDIRECT for Dependent ListsYes. In Excel, INDIRECT can make a data-validation drop-down depend on another cell: name each child list after a parent-list choice, then…
- Power BI DAX Concatenate: Examples and UsageIn Power BI DAX, join two text values with the ampersand operator (&) or the CONCATENATE function; to combine values from multiple…
- Power Query Unique Values: Remove Duplicates or Keep One?To get unique values in Power Query in Excel for Microsoft 365, select the column or columns that define a value, then…
- Power Query Sort: How to Sort and Keep Rows in OrderTo sort data in Power Query in Excel for Microsoft 365 on Windows, open the query, select the dropdown on a column…
- Power Query Rounding: How to Round Numbers CorrectlyIn Power Query, select a numeric column and use Transform > Rounding > Round to round it in the interface; for a…
- XLOOKUP Example Table: Formulas, Results, and Tips in ExcelWith product IDs in A2:A6, prices in C2:C6, and the ID to find in E2, use =XLOOKUP(E2,A2:A6,C2:C6,"Not found"). In the example below,…
- Conditional Formatting If Statements in Excel: A GuideIn Excel, an “if statement” for conditional formatting is usually a formula-based rule that returns TRUE or FALSE; Excel formats cells when…
- Excel Conditional Formatting If: How Rules WorkIn Excel, conditional formatting applies a format when a cell or formula meets a condition—in effect, an “if this, then format it”…
- Power Query Nested If: Syntax and ExamplesIn Power Query, write a nested conditional as if condition1 then result1 else if condition2 then result2 else finalResult. Add it in…
- Power Query Lookup: How to Match Data Across TablesIn Excel, a Power Query lookup is usually a merge: open the Power Query Editor, choose Home > Merge Queries, select the…
- COUNTIF for Text: Exact Matches, Wildcards, and TipsTo count cells that exactly match text in Excel, use =COUNTIF(A2:A7,"East"). It counts matching entries in A2:A7 without distinguishing uppercase from lowercase;…
- PMT Function Negative in Excel? The Sign Rule ExplainedYour PMT function is usually negative because Excel treats the loan amount and its repayments as cash flows in opposite directions: money…
- Excel Named Range Formulas: Uses, Setup, and ExamplesIn Excel, a named range lets you use a meaningful name in a formula instead of a cell address: if the range…
- Excel Named Range Formula: Examples and SetupA named range formula example in Excel is =SUM(Sales), where the name Sales refers to a cell range such as B2:B10. To…
- Excel Data Validation INDIRECT Formula: Dependent ListsIn Excel for Microsoft 365 on Windows, use =INDIRECT($A2) as the Data Validation list source in B2 when A2 contains the name…
- ISERROR Function in Excel: What It Does and How to Use ItIn Excel, ISERROR checks whether a value or formula result is any error value, and returns TRUE if it is or FALSE…
- VLOOKUP Formula to Compare Two Sheets in Excel EasilyTo compare values on two Excel sheets by a shared ID, enter this formula on the first sheet, assuming IDs are in…
- PMT Function Syntax in Excel: Arguments and ExamplesIn Excel, the PMT function syntax is =PMT(rate, nper, pv, fv, type). The first three arguments are required; fv and type are…
- Excel Data Validation Formula: Rules, Examples & FixesAn Excel data validation formula is a custom rule that controls what users can enter in selected cells. In Microsoft 365 for…
- IsNumber Function in Java: Methods to Check Numeric TextJava does not have a built-in, general-purpose isNumber() function. To check numeric text, choose a method that matches what you mean by…