O'Reilly logo

Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours by Trudi Reisner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required