Comparison Operator : Operators « Formula « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Formula
  3. Operators

= (equal sign) Equal to

> (greater than sign) Greater than

< (less than sign) Less than

>= (greater than or equal to sign) Greater than or equal to

<= (less than or equal to sign) Less than or equal to

<> (not equal to sign) Not equal to









6.11.Operators
6.11.1.Arithmetic Operator
6.11.2.Comparison Operator
6.11.3.Text concatenation OperatorText concatenation Operator
6.11.4.OPERATOR PRECEDENCE IN EXCEL FORMULAS
6.11.5.Determining Whether Two Strings Are IdenticalDetermining Whether Two Strings Are Identical
6.11.6.To add a space between the two entries when joining Two or More Cells:To add a space between the two entries when joining Two or More Cells:
6.11.7.Use a comma and a space between the two entries when joining Two or More CellsUse a comma and a space between the two entries when joining Two or More Cells