Microsoft Office Tutorials and References
In Depth Information
Creating Formulas
Formula Bar
Actual Formula
Result
Using Mathematical Operators
As you learned earlier, all formulas begin with
an equals (=) sign. Besides the equals sign, a
formula typically includes one or more cell
addresses that reference the values in those cells, and
one or more mathematical operators , that tell
Excel to add, subtract, multiply, divide, or to do
something else with those values . Here are some
common operators you should know:
+
Subtraction
Multiplication
*
Division
/
Figure 2-2
While the result of a formula appears in the active
cell, the formula itself appears in the Formula bar.
Exponentiation
^
Using Exponential Operations
Formula Versus Result
An example of an exponential operation
is 2 3 . To indicate exponential calculations
in a formula, use ^ as in C4^2, which tells
Excel to take the value in cell C4 squared.
In Figure 2-2, notice that the formula =
E12+E13+E14+E15 appears in the Formula
bar, but that the result, \$1,618,365, appears
in cell E16.
operators, formulas can also contain constants ,
which is just a fancy name for a number, such
as 32, 2.75, or 5%. Yes, although you should not
use dollar signs (\$) or commas when entering a
constant into a formula, if you prefer, you can
use a % sign to enter a percentage such as 25%
rather than using its decimal form (.25).
Tip
Excel comes with many built-in formulas
(such as rounding to the nearest dollar
or finding the maximum value in a group
of numbers). The built-in formulas are
called
, and they make it easier
for you to perform calculations on your
data without actually typing the
corresponding mathematical formula into a
cell. See Chapter 3, “Using Excel