OPERATOR PRECEDENCE IN EXCEL FORMULAS : Operators « Formula « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Formula
  3. Operators
SymbolOperator
Colon (:), comma (,), space( )Reference operators
-Negation
%Percent
* and /Multiplication and division
+ and -Addition and subtraction
&Text concatenation
=, <, >, <=, >=, and <>Comparison










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