I'm running a forecast model that requires tracking week over week. Column A is this week's projection, Column B is last week's projection, and Column C is the target. Unfortunately, I can have wild swings in my trends which is causing me headaches. It only matters that I'm getting closer to the target, so -50 is better than +75 if the target is 0, following number line math. Ultimately, if I can figure out a solid formula, what I'm aiming for is an if statement that tosses out a "Y" for improvement or an "N" for no improvement. However, because my numbers swing so wildly from week to week, I'm having trouble pinpointing a formula that works in all instances. Any ideas? Thanks in advance.
-Q
Bookmarks