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.
Combine text from two or more cells into one cell
You can combine data from multiple cells into a single cell using the Ampersand symbol (&) or the CONCAT function. Select the cell where you want to put the combined data. Type = and select …
Overview of formulas in Excel - Microsoft Support
Switch between relative, absolute and mixed references for functions. Using calculation operators in Excel formulas. The order in which Excel performs operations in formulas. Using functions …
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 …
Use cell references in a formula - Microsoft Support
When you create a simple formula or a formula by that uses a function, you can refer to data in worksheet cells by including cell references in the formula arguments. For example, when you …
Split text into different columns with functions - Microsoft Support
This article shows you how to extract various components from a variety of name formats using these handy functions. You can also split text into different columns with the Convert Text to …
Formula tips and tricks - Microsoft Support
To switch between relative, absolute, and mixed references:. Select the cell that contains the formula. In the formula bar , select the reference that you want to change. Press F4 to switch …
Lookup and reference functions (reference) - Microsoft Support
Excel comes with multiple Lookup and Reference functions that let you find matching values. Use this article to decide which function is best for your needs.
Implicit intersection operator: @ - Microsoft Support
When dynamic array enabled Excel detects the creation of a "mixed formula", it will propose a variation of the formula that implicit intersection throughout. For instance, if you enter …
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 …
Examples of commonly used formulas - Microsoft Support
The examples in the articles contain sample data to get you started and guidance to help you get the results you expect. Find links to examples of commonly-used formulas, including some …