In doing forecasting and projecting for the remainder of the month, sometimes it's helpful to look at MTD % increase/decrease over last year and assume that for the remainder of the month. For example, if MTD performance is 25% higher than last year, it may be safe to assume the rest of the month will come out 25% higher than last year as well.
But if the day to day number is pretty similar it may make more sense to average that out as a straight line projection instead. For example, $2500/day for the remainder of the month if that is the average MTD.
I'd like to use a single cell to project off of. So it could be a percent or a whole number.
If percent, the values for the remainder of the month should calculate the values. If whole number, the values for the remainder of the month should all be the same as the whole number.
These dont seem to work:
=IF($C4<=TODAY()-1,Performance!AV19,IF(RIGHT(P51,1)="%",(P$51*R4)+R4,P51))
=IF($C4<=TODAY()-1,Performance!AV19,IF(P51<10,(P$51*R4)+R4,P51)) (if less than 10, it must be a percent because the whole number will always be more than 10 and a percentage will always be less than 1000%)
Bookmarks