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
+
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)

Search JabSto ::

Custom Search