ss3-Department Budget 1
Remember: DO NOT type the $, commas or percent symbols
USE the format options available
Formulas:
The Change column:
the difference between the 2012 budget number and the 2011 budget number
Note that if the numbers go up from 2011 to 2012 the results should be positive
The % Change column:
divide the change column by the original amount (2011)
format to show no decimal places
Totals:
Total the 2011, 2012 and the change columns
The % Change column is determined by dividing the total Change by the total of the 2011 column