Excel's logical operators are used in formulas to perform comparisons, and to build formula criteria. Logical operators can be used in formulas on their own, or combined with each other and/or other functions. The table below lists the logical operators available in Excel:
Not equal to
Greater than or equal to
Less than or equal to
Note: all Excel formulas must begin with an equal sign (=). This is a syntax requirement, not a logical comparison.
For writing formulas, Excel has a standard set of math operators for performing addition, subtraction, multiplication, and exponentiation (raising to the power of). In addition, Excel also provides operators for cell ranges, range intersects, and...
When evaluating a formula, Excel follows a standard math protocol called "order of operations". First any expressions in parentheses are evaluated. Next Excel will solve for any exponents. After exponents, Excel will perform multiplication and...