Microsoft Office Tutorials and References

In Depth Information

**Chapter 2: Basic Facts about Formulas**

Sample formulas

If you follow the above instructions for entering formulas, you can create a variety of formulas.

This section provides a look at some sample formulas.

h
The following formula multiplies 150

.01, returning 1.5. This formula uses only literal

values, so it doesn’t seem very useful. However, it may be useful to show your work when

you review your spreadsheet later.

×

=150*.01

h
This formula adds the values in cells A1 and A2:

=A1+A2

h
The next formula subtracts the value in the cell named
Expenses
from the value in the cell

named
Income:

=Income–Expenses

h
The following formula uses the SUM function to add the values in the range A1:A12.

=SUM(A1:A12)

h
The next formula compares cell A1 with cell C12 by using the = operator. If the values in

the two cells are identical, the formula returns TRUE; otherwise, it returns FALSE.

=A1=C12

h
This final formula subtracts the value in cell B3 from the value in cell B2 and then

multiplies the result by the value in cell B4:

=(B2–B3)*B4

Editing formulas

If you make changes to your worksheet, you may need to edit formulas. Or if a formula returns

one of the error values described later in this chapter, you might need to edit the formula to

correct the error. You can edit your formulas just as you edit any other cell.

Here are several ways to get into cell edit mode:

h
Double-click the cell.
This enables you to edit the cell contents directly in the cell. This

technique works only if the Double-click Allows Editing Directly in Cell check box is

selected on the Advanced tab in the Excel Options dialog box.