Page 3 of 24PREVNEXT

Get to know Excel: Enter formulas

Formula 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 select cell C6, the formula appears in the formula bar.

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 do math in Excel by typing simple formulas into cells. 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 select cell C6 again.

Page 3 of 24PREVNEXT