C
Carl
I am trying to create a formula that calculates a Quarter change from year to
year where the Quarters are in the columns - so i would need to add the
formula to a new row but cant seem to get it to calculate the different years
- is there an IF function that can be used?
Data
Year Qtr 1 Qtr 2 Qtr 3 Qtr 4
2009 $111,814,953 $176,858,096 $81,572,938 $83,166,330
2010 $116,999,566 $195,651,553 $102,976,126 $46,935,333
(formula to calc differences in Qtr's?????)
Grand Total$228,814,519 $372,509,649 $184,549,063 $130,101,663
year where the Quarters are in the columns - so i would need to add the
formula to a new row but cant seem to get it to calculate the different years
- is there an IF function that can be used?
Data
Year Qtr 1 Qtr 2 Qtr 3 Qtr 4
2009 $111,814,953 $176,858,096 $81,572,938 $83,166,330
2010 $116,999,566 $195,651,553 $102,976,126 $46,935,333
(formula to calc differences in Qtr's?????)
Grand Total$228,814,519 $372,509,649 $184,549,063 $130,101,663