Page 3 of 24PREVNEXT

Get to know Excel 2007: Enter formulas

Forumula typed in worksheet

Callout 1 Type the formula in cell C6.
Callout 2 Press ENTER to display the formula result.
Callout 3 Any time you click in cell C6, the formula appears in the formula bar.

The two CDs purchased in February cost $12.99 and $16.99. The total of these two values is the CD expense for the month.

You can add these values in Excel by typing a simple formula into cell C6.

Excel formulas always begin with an equal sign (=). Here's the formula typed into cell C6 to add 12.99 and 16.99:


The plus sign (+) is a math operator that tells Excel to add the values.

If you wonder later on how you got this result, the formula is visible in the formula bar Formula bar near the top of the worksheet whenever you click in cell C6 again.

Page 3 of 24PREVNEXT