Can anybody help,
I'm trying to show a trend or a forecast but I'm doing something wrong
because I keep getting #Value as a result. Can I adjust a forecast to show a 25% drop in figures over a period of month.
I would be eternally Grateful
ray:
I'm trying to show a trend or a forecast but I'm doing something wrong
because I keep getting #Value as a result. Can I adjust a forecast to show a 25% drop in figures over a period of month.I would be eternally Grateful
ray:| actual (version 1).xls | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | |||
| 2 | Cost/RevenueElements | Month8 | Month9 | Month10 | Month11 | Month12 | Month13 | Month14 | Month15 | |||
| 3 | relief | ***57799TotalServiceLineExpense | 454,589.37 | 364,721.53 | 379,434.32 | 431,460.78 | 400,553.52 | #VALUE! | ||||
| 4 | expen | ***57999TotalComputerRelated | 304,757.55- | 206,708.59- | 270,758.96- | 277,508.18- | 269,607.96- | #VALUE! | ||||
| 5 | expen | ***59699TotalAdministrative | 3,348.16- | 3,347.91- | 3,347.90- | 6,484.16- | 3,347.91- | #VALUE! | ||||
| 6 | Expense | 308,105.71- | 210,056.50- | 274,106.86- | 283,992.34- | 272,955.87- | #VALUE! | |||||
| 7 | Contribution | *******75999UnitContribution | 151,793.02 | 152,378.22 | 105,327.46 | 147,468.44 | 127,597.65 | |||||
Sheet1 | ||||||||||||
