Creating and Editing Formulas

Creating formulas in Excel is straightforward. You can include cell addresses, values, and even functions in your formulas. The values in the formula (specified by cell addresses) are then acted on by an operator or operators that you specify in the formula. When you begin a new formula in a cell, you start the formula’s notation with the = sign. This lets Excel know that you are entering a formula. You can then specify the cell addresses for the formula and the required operators. For example, you might enter the formula:

=B6-C6

You are specifying that Excel should take the value in C6 and subtract it from the value in B6. The result is placed in the cell where you entered the formula. Table 13.1 shows some of the ...

Get Office 2013 In Depth now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.