Forecasting with several conditions

[Oprichnick]

Hello,
I'm trying to forecast values along down a table.
I have already used Forecast (Linear) formula without a problem, but now I need several conditions to be met.

This is what I have so far:

{FORECAST.LINEAR([@Date];AND(IF([Date]>=([@[Date]]-5); [Score];"");IF([Date]<[@[Date]]; [Score];""));AND(IF([Date]>=[@[Date]]; [Date];"");IF([Date]<[@[Date]]; [Date];"")))}

Using just one condition for X's and Y's, the formula works. But when I start writing AND's I get errors.
So I bet that there is something wrong in the AND's part but I'm not figuring out what.

Thanks in advance for your help,
Pedro

[joeu2004]

We cannot use AND etc in array-entered formulas if the intent is a row-by-row logic test.

Instead, array-enter (press ctrl+shift+Enter instead of just Enter) the following formula:

Please Login or Register  to view this content.

I seperated the FORECAST parameters to make them clearer.

I mofidied the conditions of the second parameter. I assume the omission of -5 is a mistake. It is unusual for the two parameters to have different conditions.

[Oprichnick]

Hi Joeu2004,
Thank you for the explanation.
Works very well.

Regards