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.