Microsoft Office Tutorials and References
In Depth Information
Using Operators in Formulas
Using Operators in Formulas
As previously discussed, an operator is the basic element of a formula. An operator is a symbol
that represents an operation. Table 2-1 shows the Excel-supported operators.
Table 2-1: Excel-Supported Operators
Symbol Operator
+ Addition
– Subtraction
/ Division
* Multiplication
% Percent*
& Text concatenation
^ Exponentiation
= Logical comparison (equal to)
> Logical comparison (greater than)
< Logical comparison (less than)
>= Logical comparison (greater than or equal to)
<= Logical comparison (less than or equal to)
<> Logical comparison (not equal to)
*Percent isn’t really an operator, but it functions similarly to one in Excel. Entering a percent sign after a number divides the number
by 100. If the value is not part of a formula, Excel also formats the cell as percent.
Reference operators
Excel supports another class of operators known as reference operators; see Table 2-2. Reference
operators, described in the following list, work with cell references.
Table 2-2: Reference Operators
Symbol
Operator
: (colon)
Range. Produces one reference to all the cells between two references.
, (comma)
Union. Combines multiple cell or range references into one reference.
(single space)
Intersection. Produces one reference to cells common to two references.
 
Search JabSto ::




Custom Search