The AND function returns TRUE if all its arguments evaluate to TRUE, and returns FALSE if one or more arguments evaluate to FALSE. One common use for the AND function is to expand the …

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 …

Use AND and OR together or with the IF function. For example, calculate who earns a commission or find data that meets multiple conditions.

When you're comfortable with VLOOKUP, the HLOOKUP function is equally easy to use. You enter the same arguments, but it searches in rows instead of columns. Using INDEX and MATCH …

Important: The calculated results of formulas and some Excel worksheet functions may differ slightly between a Windows PC using x86 or x86-64 architecture and a Windows RT PC using …

Learn these top skills to create your own formulas and functions.

Lists all Excel functions by their category, such as Logical functions or Text functions.

Functions are predefined formulas that perform calculations by using specific values, called arguments, in a particular order, or structure. Functions can be used to perform simple or …

Try using the new XLOOKUP function, an improved version of VLOOKUP that works in any direction and returns exact matches by default, making it easier and more convenient to use …

Type a brief description of what you want a function to do and then choose Go. A list of functions likely to fit your needs and based on your description will display in the Select a function box.

Lists all logical functions, such as the AND, OR, and IF functions.