Creating Simple Cell Formulas

Building calculations in Excel is pretty straightforward. If you want to find the sum of the values in two cells, you just type an equal sign (=), the reference of the first cell, a plus sign (+), and the reference of the second cell. The formula you enter will appear on the formula bar, where you can examine and edit it.

Build a Formula

  1. Click the cell into which you want to enter a formula.

  2. Type =.

  3. Type the expression representing ...

Get Microsoft® Office Excel® 2007 Plain & Simple 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.