Formulas & functions
How a function works, with worked examples you can paste.
- Excel Count Unique Values: 6 Ways to Ignore DuplicatesTo count unique values in Excel while ignoring duplicates, use =SUMPRODUCT(1/COUNTIF(range, range)) for a single column, or =COUNTA(UNIQUE(range)) in Excel 365/2021. The…
- Excel COUNTIF Contains Partial Text: 3 WaysTo count cells that contain part of text in Excel, use =COUNTIF(range,"*text*") — the asterisks are wildcards that match any characters before…
- Excel Conditional Formatting If No Formula?Yes, Excel conditional formatting can work without a formula; you can use built-in rules like Highlight Cells Rules, Top/Bottom Rules, Data Bars,…
- Excel Conditional Formatting If Not a Formula?Excel conditional formatting does not require a formula; you can apply formatting based on cell values, text, dates, or even blanks using…
- Excel Conditional Formatting Icon Sets: Formula GuideYou cannot directly type a formula into the icon set rule dialog box. Instead, you use a formula to create a new…
- Excel Conditional Formatting Formula if Zero?To highlight cells that equal zero in Excel, use the formula =A1=0 in a conditional formatting rule. Select the range, go to…
- Excel Conditional Formatting Formula If TextThe core formula for conditional formatting based on text in Excel is =ISNUMBER(SEARCH("text", A1)) for partial matches, or =A1="exact text" for exact…
- Excel Conditional Formatting Formula: If Then RulesThe direct answer: in Excel conditional formatting, an “if then” rule is a formula that returns TRUE to apply formatting and FALSE…
- Excel Conditional Formatting Formula if BlankThe formula to highlight blank cells in Excel conditional formatting is =ISBLANK(A1) (or =A1=""), applied to the range you want to check.…
- Excel Conditional Formatting Formula If Date: Full GuideThe core formula for conditional formatting based on a date in Excel is =A2=TODAY() (assuming your date is in cell A2), which…
- Excel Conditional Formatting Due Date FormulaThe core formula for highlighting overdue dates in Excel is =A2<TODAY() applied to a range starting at A2, which flags any date…
- Excel Concatenate with Date: Formatting & FormulasTo concatenate a date in Excel while keeping it readable, use the TEXT function inside your concatenation formula, like =A2&" "&TEXT(B2,"mm/dd/yyyy"). Without…
- Excel Conditional Formatting Countif FormulaThe direct answer: you cannot use COUNTIF as a standalone conditional formatting rule, but you can apply a formula based on COUNTIF…
- Excel Combine Unique Lists: 3 WaysTo combine two or more lists in Excel and keep only unique values, use the UNIQUE function with the VSTACK function: =UNIQUE(VSTACK(range1,…
- Excel Combine XLOOKUP with SUM: 2 WaysYes, you can combine XLOOKUP with SUM in Excel by nesting XLOOKUP inside SUM to sum a returned array, or by using…
- Excel Concatenate Strings: The 4 Best WaysThe simplest way to concatenate (join) strings in Excel is to use the ampersand operator (&), like =A1&" "&B1. You can also…
- Excel Calendar Week Formula: How to Use WEEKNUMThe core Excel formula for a calendar week number is =WEEKNUM(date), which returns the week number (1–53) for a given date based…
- Excel Calendar with One Formula? Yes, Here’s HowYes, you can create a dynamic calendar in Excel with a single formula using the SEQUENCE function combined with date and formatting…
- Excel Calendar Template Sequence: How to Build OneTo create a sequence of dates for an Excel calendar template, use the SEQUENCE function (Excel 365/2021) or a simple fill handle…
- Excel Calendar Quarter Formula: How to Extract Q1-Q4The simplest Excel formula to get the calendar quarter from a date in cell A1 is =ROUNDUP(MONTH(A1)/3,0). This returns 1 for Jan–Mar,…
- Excel Loan Payment Formula: PMT & How to Use ItThe quickest way to calculate a loan payment in Excel is the PMT function. In its simplest form, =PMT(rate, nper, pv) returns…
- String Functions in JavaScript: The Essential GuideString functions in JavaScript are built-in methods that let you manipulate and inspect text values, from finding and replacing substrings to changing…
- BETWEEN Function in Snowflake: Syntax & ExamplesThe BETWEEN operator in Snowflake is a conditional operator used to filter rows where a value falls within a specified inclusive range.…
- Snowflake CREATE OR REPLACE FUNCTION ExplainedYes, Snowflake supports CREATE OR REPLACE FUNCTION for both SQL and JavaScript UDFs (user-defined functions), and it atomically replaces an existing function…
- Excel Budget Variance Formula: How to Calculate ItThe core Excel budget variance formula is =Actual - Budget, which returns the difference in dollars, or =(Actual - Budget) / Budget,…
- Function in Snowflake: Definition, Use & ExamplesIn Snowflake, a function is a reusable piece of SQL logic that takes input parameters, performs a defined operation, and returns a…
- Excel Book of Formulas: What It Is and How to Use ItAn “Excel book of formulas” is not a single official Microsoft product; it is a general term for any reference guide, printed…
- OVER() in Snowflake: Window Function Syntax & ExamplesIn Snowflake, OVER() is the clause that turns a regular aggregate function (like SUM, COUNT, or AVG) into a window function, letting…
- C++ Function Syntax: A Complete GuideThe basic syntax for a function in C++ is return_type function_name(parameter_list) { body }. For example, int add(int a, int b) {…
- How to Call a Function in Snowflake (Step-by-Step)Calling a function in Snowflake means executing a built-in or user-defined function (UDF) to return a value, transform data, or perform an…