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:

Addition

+

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.

In addition to cell addresses and mathematical

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

Functions,” for more information.

functions