Hi,

I recently want to evaluate the accuracy of monthly forecast starting
from Jan'07.
If the Actual/forecast(A/F) 115% or <85% for consecutive 3 months in
most recent 3 months, I will mark it as "over", otherwise I will mark
it as "normal".
Table looks like this

Directors Jan(A/F) Feb(A/F) Mar(A/F) Apr(A/F) ...........Dec(A/
F) Evaluate
A 85.1% 73.1% ........................................
Over

Because it is a rolling forecast, I have to modify my "evaluate"
formula every month:

=IF(AND(ABS('JanA/F'-1)0.15,ABS('FebA/F'-1)0.15,ABS('MarA/
F'-1)0.15),"over","normal")

Is it possible to write a formula running formula before an empty
column ( I will leave "months after current month" blank ) that I
don't need to update formula but only add current month A/F data and
it will automatically shows most recent 3 months?

Thank a ton.