Microsoft Office Tutorials and References

In Depth Information

If you simply need to perform a calculation, you can use the Formula bar as a calculator. For example, enter the

following formula into any cell:

=(145*1.05)/12

Because this formula always returns the same result, you may prefer to store the formula's result rather than the

formula. To do so, press F2 to edit the cell. Then press F9, followed by Enter. Excel stores the formula's result

(12.6875) rather than the formula. This technique also works if the formula uses cell references.

This technique is most useful when you use worksheet functions. For example, to enter the square root of 221 in-

to a cell, type
=SQRT(221)
, press F9, and then press Enter. Excel enters the result: 14.8660687473185. You also

can use this technique to evaluate just part of a formula. Consider this formula:

=(145*1.05)/A1

If you want to convert just the expression within the parentheses to a value, get into cell edit mode and select the

part that you want to evaluate. In this example, select 145*1.05. Then press F9 followed by Enter. Excel converts

the formula to the following:

=(152.25)/A1

Using Operators in Formulas

As previously discussed, an operator is one of the basic elements 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)