forecasting

Hi - I am sure this is an easy one! I am trying to chart forecasted sales based on sales in the fiscal year thus far. I need help with a formula on my "Forecast" line that will pick up the YTD percentage of budgeted sales that the actual sales from previous months represent, then return that same percentage of the forecasted sales for the balance of the months. So, if YTD through the fourth month sales are trending at 85% of the forecast, the worksheet should re-project the remaining months at 85%. If the fifth month is above forecast, so the result is that the YTD totals are now 90% of forecast, the remaining months would want to now pick that up. Thanks!

I'm not really sure I follow ... are the values in row 17 of your sample the expected output ? If so why do the values in I onwards use 79% rather than 78.5% as used in H ?

If you're saying that H:N should all use the % of the last YTD point (ie G) then perhaps you could apply the following to row 17:

C17: =IF(SUM($C16:C16),IF(C$16,C$16,C$15*(LOOKUP(9.99E+307,$C$16:C$16)/LOOKUP(9.99E+307,$C$16:C$16,$C$15:C$15))),"")
copied across to N17

but again - I'm not sure that's what you're looking to do...