The Sold , Sales and Totals information on Alistair's spreadsheet can be calculated
A B C D E F G 1 Artist Title Price Number Running Total Sold Sales 2 Hell Zombies I'm upset! £14.99 2 55 3 M-Psink! I Want U Baby £13.99 5 27 4 Bushwacker Ibiza Chill £12.99 3 45 5 The Squires Dublin Diaries £9.99 1 22 6 Mr TNT Garage Hits £9.99 0 12 7 Totals
To calculate the Sales for Hell Zombies you need to know:
No. of CDs Sold x Price = Sales (total income from the sale of CDs ) To complete this sum you will need to know:
The price of the CD (this is in cell C2) How many CDs sold (this information will be in cell F2, but you need to work this out)
If you are unable to view the Flash movie above, click here for a non-Flash alternative.
If you are unable to view the Flash movie above, click here for a non-Flash alternative.
There is a simple way of copying the formula into the other Sales cells without having to type it in 4 times. You can drag the formula down by using the handle on the bottom right hand corner of the cell:
If you are unable to view the Flash movie above, click here for a non-Flash alternative.
Go to the next screen to have a look at updating the information.
