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