Create Simple Formulas

To apply a function, you create a formula that uses that function. If you know the formula you want to use, you can type it directly into a worksheet cell, or into the Formula Bar (which displays the cell content in a larger space). If you’re uncertain about the specific function that will perform the calculation you want, or unsure about how to put together a formula using that function, you can call on the Formula Builder to help you put one together.

You can create a formula in any of these three ways:

  • Type the formula directly into the worksheet cell in which you want the results to appear.

  • Display the Formula Bar, and ...

Get Microsoft® Office 2008 for Mac Step by Step 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.