The Calculator

Excel's Calculator feature offers another way to enter formulas into cells. It displays a familiar interface—like a standard pocket calculator (Figure 41)—for building formulas. As you click or type to enter formula components into the Calculator, it displays the result of the formula in a text box. Clicking OK in the Calculator completes the formula and enters it into the worksheet cell.

Figure 41. The Calculator offers a familiar interface for entering formulas.

To enter a formula with the Calculator

1.
Activate the cell in which you want to enter the formula.
2.
Click the Calculator button on the formula bar. The Calculator appears ...

Get Microsoft Excel X for Mac OS X: Visual QuickStart Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.