ok,
heres what i am trying to do now, lol.
Take two cells one will be the projection say 10
the other will be actual say 9
can excel tell me that equals -1 ?
i mean minus one from the projection not a negative number
and if so then can it cumulative totals of that ?
say i have projections in different cells ex: 9,10,11,12
the actual numbers below would be 9,11,8,10
so the formula needs to tell me first one is qual second plus 1 third minus 3 forth plus 2 and so forth and once it gives me those then total them in colum so would total minus 4?
sorry hard to explain
TIA
Bookmarks