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]]; [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

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Forecasting with several conditions

Thread starter Oprichnick
Start date Feb 14, 2018
Tags

and & or statement condition forecast ifs statement

Oprichnick

Board Regular

Feb 14, 2018

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