Using IF with AND, OR, and NOT functions in Excel
How to use the IF function (combined with the AND, OR, and NOT functions) in Excel to make logical comparisons between given values.
Create conditional formulas - Microsoft Support
Testing whether conditions are true or false and making logical comparisons between expressions are common to many tasks. You can use the AND, OR, NOT, and IF functions to create conditional …
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 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 …
Use conditional formatting to highlight information in Excel
How to use conditional formatting in Excel to visually explore, analyze, and identify patterns and trends.
Use AND and OR to test a combination of conditions
Use AND and OR together or with the IF function. For example, calculate who earns a commission or find data that meets multiple conditions.
SUMIF function - Microsoft Support
How to use the SUMIF function in Excel to add the values in a range that meet criteria that you specify.
Add a conditional column (Power Query) - Microsoft Support
With Power Query, you can add a conditional column to your query. You can define IF-THEN-ELSE conditions in your query. When the conditions are fulfilled, the conditional column will automatically …
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, …
IIf Function - Microsoft Support
In Access, if you need to calculate or display a value based on a condition, use the IIf function. The IIf (Immediate If) function is similar to the If function in Excel.