Create Forecast Worksheet Going below 0?

[oneblondebrow]

Hi all,

I have only just got into this forecasting with Excel, please bare with me.

I have attached a test sheet where i have a some data (and a picture of the settings), Not quite 12 months worth though, As you will see the data has a downward trend, I am using the "Forecast" sheet wizard to create the forecast but understandably, because the trendline goes down, the forecast also goes down, below 0 into the minus's, this won't be the case as there will always be an amount of these "Tickets", Is there a way for me to add some sort of Limit so it doesn't go into the minus's?, I have tried using the MAX function but it's not working how i want it to, I still want the upper and lower confidence to be there but the lower confidence to be above 0, which will then straighten out the middle line (if that makes sense?).

As always, thanks in advance for any advise.

[dflak]

Try this formula =MAX(C49-FORECAST.ETS.CONFINT(A49,$B$2:$B$48,$A$2:$A$48,0.95,1,1),0) - you can replace 0 with some other lower control limit.