March 2013
Intermediate to advanced
1032 pages
33h 29m
English
Content preview from Office 2013 In DepthBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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 ...