Creating a Simple Formula

Simple formulas that work with values are easy to create. In essence, simple formulas use Excel like a calculator. These simple formulas are somewhat limiting because they don't use any values from the other cells in the worksheet. You can enter a formula into a cell, or you can enter it into the Formula bar.

The next To Do exercise gives you a chance to create and edit some simple formulas. Because the formulas are only for practice, you should be working on a blank worksheet.

To Do: Work with Simple Formulas

1.
The first formula adds a series of numbers together. Click into a blank cell on the worksheet and type =35+35+35. When you're done typing, press the Enter key. Notice that the result of the calculation, 105 ...

Get Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours 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.