March 2013
Intermediate to advanced
1032 pages
33h 29m
English
Content preview from Office 2013 In Depth
Become 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
Performing Calculations in Excel Worksheets
Excel provides you with two different possibilities for doing calculations in your worksheets: formulas and functions. Formulas are do-it-yourself math. You specify the cells to be referenced in the calculation and you also provide the operators, which determine what kinds of calculations actually take place. Formulas are best reserved for simple calculations, such as subtraction, multiplication, and division. Figure 13.1 shows a subtraction formula that subtracts the payment to the instructor (G10) from the Tuition Total for that class (D10).
Figure 13.1. A subtraction formula.
Note that the formula ...