I got this working for you I think per your requirements. I created 3 columns:
- Product Line (Choice)
- Platform (Choice)
- Return (Calculated)
I created 5 list items, one to test each different Platform condition. So for each item I chose a different platform then I created my formula. Here it is working:
It can certainly confusing to work with these nasty nested formulas. Here is the column formula:
=IF(AND(ProductLine="A",Platform="1"),"11 12 13",IF(AND(ProductLine="A",Platform="2"),"11 14 15",IF(AND(ProductLine="A",Platform="3"),"16 11",IF(AND(ProductLine="A",Platform="4"),"1 2 3 4 5 6",IF(AND(ProductLine="A",Platform="5"),"7 8 9 10","not applicable")))))
We do not need any OR statements as this is taken care of by the ELSE part of the IF statement. You also weren't wrapping your return value numbers in quotes. The way it works is using nested IF AND statements. We say the first condition IF productline=A AND platform=1, then give 11 12 13. The key is the ELSE.
IF(AND(conditioncol1=value1, conditioncol2=value2), "returned value", ELSE)
You start with the first statement then copy it 4 times and fix the values for the other 4.
IF(AND(ProductLine="A",Platform="2"),"11 14 15",ELSE)
IF(AND(ProductLine="A",Platform="3"),"16 11",ELSE)
IF(AND(ProductLine="A",Platform="4"),"1 2 3 4 5 6",ELSE)
IF(AND(ProductLine="A",Platform="5"),"7 8 9 10","not applicable")
Then paste that 2nd IF statement in the ELSE of the previous one (e.g. paste platform 3 formula in the ELSE of platform 2). Then you keep doing that until you end up with one big fat long statement. For me, it worked first time! Let me know if I misunderstood if you needed something different.