Welcome! Register Now to Unlock Exclusive Excel TutorialsGet Started
- Exclusive Playlists
- Downloadable Videos
- No Ads!
- Exclusive Templates
Description: Comparison Operators in Excel - How to Use Them to Make the Most of Your Data
Comparison operators are a set of logical functions that allow you to compare and evaluate the results of formulas. They can be used to compare two values, or determine which value is larger.
The most common comparison operators are:
- "=" (equal)
- "<>" (not equal)
- "<" (less than)
- ">" (greater than)
- "≤" (less than or equal to)
- "≥" (greater than or equal to)
Table Of Content:
01:27 Equal to in Excel
03:32 Greater than in Excel
06:38 Less than in Excel
08:42 Greater than Equal to in Excel
10:04 Less than Equal to in Excel
11:56 Not Equal to in Excel
The Order of Comparison Operators * Order of Operations **
Order of operations is an order in which mathematical operations are performed.
The order of comparison operators are used to compare two values. They are used to determine the relative position of each value on a scale or hierarchy. The order is determined by the symbols that are used for these operators.
How To Use The Equal Sign (=) Operator In Excel To Compare 2 Numbers Or Formulas
The equal sign operator is a comparison operator that returns TRUE if the two operands are equal and FALSE if they are not.
In Excel, you can use the equal sign operator to compare two numbers or formulas. If the operands are not equal, the result will be FALSE and vice versa.
The syntax for using this operator is:
= = (equal sign) (operand 1) (operand 2)
How To Find The Position Of One Number In Another Number With The And (&) Or Or (| |) Operator
The And (&) Or Or (| |) Operator can be used to find the position of one number in another number.
The And (&) Operator is used to find the position of a digit in a string of digits.
The Or (| |) Operator is used to find the position of a digit in a string of digits.
The Xor (^ ^) Is an Exclusive or Operator which can be used to find the position of one number in another number.
The = operator is used to show an equation where both sides of the equation are the same.
The<> operator is used to show an equation where both sides of the equation are different.