Problem 277
What formulas would you have to enter to instruct the computer to calculate the number in cells C2 and C3 in the spreadsheet shown?
|
A |
B |
C |
|
| 1 | Number of Items | Cost per Item(12) | Total Cost ($) |
| 2 |
7 |
8 |
56 |
| 3 |
9 |
12 |
108 |
Solution
A2 x B2 for cell C2 and A3 x B3 for cell C3