Create conditional formulas | Microsoft Support
Create a conditional formula that results in another calculation or in values other than TRUE or FALSE To do this task, use the IF, AND, and OR functions and operators as shown in the following example. …
Using IF with AND, OR, and NOT functions in Excel
Using AND, OR and NOT with Conditional Formatting in Excel In Excel, you can also use AND, OR and NOT to set Conditional Formatting criteria with the formula option. When you do this you can omit the …
Create conditional (Boolean) expressions | Microsoft Support
In this article Understand conditional expressions Create a conditional expression Examples of conditional expressions Understand conditional expressions A conditional expression is a type of …
IF function | Microsoft Support
The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect. So an IF statement can have two results. The …
IF...ELSE (Transact-SQL) - SQL Server | Microsoft Learn
Nov 18, 2025 · Any Transact-SQL statement or statement grouping as defined by using a statement block. Unless a statement block is used, the IF or ELSE condition can affect the performance of only …
Examples of common formulas in lists | Microsoft Support
Conditional formulas You can use the following formulas to test the condition of a statement and return a Yes or No value, to test an alternate value such as OK or Not OK, or to return a blank or dash to …
?: operator - the ternary conditional operator - C# reference
Jan 24, 2026 · Learn about the C# ternary conditional operator, (`?:`), that returns the result of one of the two expressions based on a Boolean expression's result.
Perform conditional calculations on ranges of cells
When you need to perform simple arithmetic calculations on several ranges of cells, sum the results, and use criteria to determine which cells to include in the calculations, consider using the …
Create a conditional column | Microsoft Support
A conditional column calculates a value from a formula. In Power Query, the term used is custom column. In this section, let’s create a 2.5% bonus calculation for all sales over $25,000. To do this, …
IF function – nested formulas and avoiding pitfalls
Multiple IF functions can be nested together to allow for multiple criteria. The Excel IF function statement allows you to make a logical comparison between a value and what you expect by testing for a …
Add a conditional column - Power Query | Microsoft Learn
Feb 29, 2024 · With Power Query, you can add a conditional column to your query by defining IF-THEN-ELSE conditions in your query. When the conditions are fulfilled, the conditional column …