Formulas & functions
How a function works, with worked examples you can paste.
- Construction Invoice Template in Excel: Setup and FormulasA construction invoice template in Excel can track the work performed, quantities, rates, approved changes, taxes or other contract charges, payments, and…
- Conditional Median in Excel: Formulas and ExamplesIn Excel for Microsoft 365, calculate a conditional median with MEDIAN and FILTER: filter the numeric values to the rows that meet…
- Excel Conditional Formatting Formula Rules ExplainedIn Excel, a conditional-formatting formula rule applies a format when a formula evaluates to TRUE. On Windows, select the cells, then choose…
- Conditional Formatting in Excel for Values That Don’t MatchTo format cells that do not match a value in Excel, select the range, then choose Home > Conditional Formatting > New…
- Excel Conditional Formatting Formula for DatesIn Excel for Microsoft 365 on Windows, use a formula-based conditional formatting rule to highlight dates that meet your criteria. Select the…
- Excel Conditional Formatting With a Custom FormulaTo use a custom formula in Excel conditional formatting, select the cells to format, then choose Home > Conditional Formatting > New…
- Concatenate Text Cells in Excel: Formulas and TipsTo concatenate text cells in Excel, join their references with the ampersand operator, such as =A2&" "&B2 to combine a first and…
- Conditional Formatting Formula in Excel: How to Use ItIn Excel, a conditional-formatting equation is a formula that returns TRUE or FALSE; Excel applies the chosen format when the result is…
- Concatenate in Excel With Quotes: Formulas and ExamplesTo concatenate text in Excel with quotation marks, join the parts with the ampersand operator (&) and use CHAR(34) to add a…
- Concatenate Text and Formula in Excel: ExamplesTo concatenate text and a formula in Excel, join them with the ampersand (&) operator. With the words Ada in A2 and…
- Concatenate First Letter and Last Name in ExcelIf first names are in A2 and last names are in B2, enter =LEFT(TRIM(A2),1)&" "&TRIM(B2) to combine the first letter of the…
- Concatenate Dates in Excel: Formulas and ExamplesTo concatenate a date in Excel, convert the date to the display format you want with the TEXT function, then join it…
- Concatenate Date Formula in Excel: Keep Dates ReadableTo concatenate a date with text in Excel, wrap the date cell in the TEXT function so Excel displays it in the…
- Excel CONCATENATE Formula: How to Join TextIf A2 contains Jane and B2 contains Doe, use =CONCATENATE(A2," ",B2) to join them with a space, producing Jane Doe. In Microsoft…
- Compare Formula in Excel: Check If Values Match or DifferTo compare two cells in Excel, use an equality test: with the values to compare in A2 and B2, enter =A2=B2. Excel…
- Concatenate in Excel: Formulas, Delimiters, and TipsTo concatenate in Excel means to join text or values into one text string. In Microsoft Excel for Microsoft 365 on Windows,…
- CONCATENATE in Excel: Formula, Examples, and TipsIn Excel, CONCATENATE joins text from multiple cells or typed values into one string. For example, with a first name in A2…
- Commission Format in Excel: Formulas and ExamplesIn Excel, calculate commission by multiplying the sale amount by the commission rate, then format the rate as a percentage and the…
- Excel Median Formula: How to Calculate the Middle ValueUse Excel’s MEDIAN function to find the middle number in a set: if your values are in A2:A10, enter =MEDIAN(A2:A10). Excel sorts…
- CLEAN TRIM Formula in Excel: Remove Extra SpacesIn Excel for Microsoft 365, use =TRIM(CLEAN(A2)) to remove many nonprinting control characters from a cell and trim extra ordinary spaces. This…
- CLEAN in Excel: Formula, Examples, and Common LimitsIn Excel, use =CLEAN(A2) to remove nonprinting ASCII control characters from the text in cell A2. CLEAN can remove things such as…
- Excel CLEAN and TRIM Functions: Remove Hidden SpacesIn Excel, CLEAN removes many nonprinting control characters, while TRIM removes leading and trailing ordinary spaces and reduces repeated spaces between words…
- Checklist in Excel: Meaning, Setup, and Useful FormulasIn Excel, a checklist is a list of tasks or items paired with a way to mark each one complete, usually with…
- Excel LAMBDA: Check Whether a Cell Contains TextTo check whether cell A2 contains the word “lambda,” use =ISNUMBER(SEARCH("lambda",A2)); the result is TRUE if a match is found and FALSE…
- Cash Flow Statement in Excel: Formulas and SetupYes. In Excel, record cash receipts and payments in a transaction log, use SUMIFS to total them by date and category, then…
- Cash Flow Formula Excel Template and SetupA basic cash flow Excel template tracks cash received and cash paid, then calculates net cash flow as cash in minus cash…
- Cash Flow Formula in Excel: Build and Read a SheetThe basic cash flow formula is cash received minus cash paid. In a sheet with cash inflows in C2 and cash outflows…
- Cash Flow Formula in Excel: Examples and How to Use ItThe basic cash flow formula in Excel is cash inflows minus cash outflows. If inflows are in B2 and outflows are in…
- Cash Flow Formula in Excel for Net Present Value (NPV)For regular, evenly spaced cash flows, Excel’s net present value formula is =NPV(rate, future_cash_flows)+initial_cash_flow. Put the initial investment outside NPV, because Excel…
- Cash Flow Format in Excel With Formulas and ExamplesA practical cash flow format in Excel lists opening cash, cash inflows, cash outflows, net cash flow, and closing cash for each…