Operators specify the type of calculation that you want to perform on elements in a formula—such as addition, subtraction, multiplication, or division. There are four different types of calculation operators: arithmetic, comparison, text concatenation, and reference.

How to use the IF function (combined with the AND, OR, and NOT functions) in Excel to make logical comparisons between given values.

Types of operators. There are four different types of calculation operators: arithmetic, comparison, text concatenation, and reference. Arithmetic operators. To perform basic mathematical operations, such as addition, subtraction, multiplication, or division; combine numbers; and produce numeric results, use the following arithmetic operators.

Learn about the implicit intersection operator (@), which returns a single value using logic known as implicit intersection. The implicit intersection operator (@) may return a value, single cell range, or an error.

Excel for the web does this by using formulas in cells. A formula performs calculations or other actions on the data in your worksheet. A formula always starts with an equal sign (=), which can be followed by numbers, math operators (such as a plus or minus sign), and functions, which can really expand the power of a formula.

Training: How do you know what part of your formula Excel acts on first, second, third, and so on? This video explains it.

Applies To Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2024 Excel 2024 for Mac Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2016 Use the OR function, one of the logical functions , to determine if any conditions in a test are TRUE.

Applies To Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2024 Excel 2024 for Mac Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2016 Use the AND function, one of the logical functions , to determine if all conditions in a test are TRUE.

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 ARM architecture. Learn more about the differences .

Applies To Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2024 Excel 2024 for Mac Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2016 Use the NOT function, one of the logical functions , when you want to make sure one value is not equal to another.