O'Reilly logo

Office 2013 In Depth by Joe Habraken

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

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