Using IF with AND, OR, and NOT functions in Excel
In Excel, the IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if that condition is True or False.
Use AND and OR to test a combination of conditions
When you need to find data that meets more than one condition, such as units sold between April and January, or units sold by Nancy, you can use the AND and OR functions together. Here's …
Look up values with VLOOKUP, INDEX, or MATCH - Microsoft …
Here's an example of how to use VLOOKUP. =VLOOKUP (B2,C2:E7,3,TRUE) In this example, B2 is the first argument —an element of data that the function needs to work. For VLOOKUP, …
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 …
AND function - Microsoft Support
Use the AND function, one of the logical functions, to determine if all conditions in a test are TRUE. The function returns TRUE if all its arguments evaluate to TRUE, and returns FALSE if …
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 …
Calculation operators and precedence in Excel - Microsoft Support
Operators specify the type of calculation that you want to perform on elements in a formula—such as addition, subtraction, multiplication, or division. In this article, you'll learn the default order in …
Handling data source errors (Power Query) - Microsoft Support
Some errors may be easy to fix, some may be transient, and some may be hard to diagnose. What follows is a set of strategies you can take to handle errors that come your way. There …
Learn to combine multiple data sources (Power Query) - Microsoft …
Power Query enables you to combine multiple queries, by merging or appending them. The Merge operation is performed on any Power Query query with a tabular shape, independent of …
Undo, redo, or repeat an action - Microsoft Support
To repeat something simple, such as a paste operation, press + Y, or select Repeat in the upper-left corner of the ribbon. In Word for the web, PowerPoint for the web, and Excel for the web, …
The order in which Excel performs operations in formulas
Excel calculates the formula from left to right, according to a specific order for each operator in the formula. If you combine several operators in a single formula, Excel performs the operations in …