Microsoft Office Tutorials and References

In Depth Information

=Income–Expenses

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

=SUM(A1:A12)

• 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

• 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:

•
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.

•
Press F2.
This enables you to edit the cell contents directly in the cell. If the Double-click Allows Editing

Directly in Cell check box is not selected, the editing will occur in the Formula bar.

•
Select the formula cell that you want to edit and then click in the Formula bar.
This enables you to edit

the cell contents in the Formula bar.

When you edit a formula, you can select multiple characters by dragging the mouse over them or by holding

down Shift while you use the arrow keys. You can also press Home or End to select from the cursor position to

the beginning or end of the current line of the formula.

Suppose you have a lengthy formula that contains an error, and Excel won't let you

enter it because of the error. In this case, you can convert the formula to text and tackle

it again later. To convert a formula to text, just remove the initial equal sign (=). When

you're ready to return to editing the formula, insert the initial equal sign to convert the

cell contents back to a formula.

Using the Formula bar as a calculator