I have been fighting this problem for a couple of hours now and could use some real help.
I have three variables; Independent variables x & y, and dependent variable z.
x & y can take the values 1,2,3 and can equal each other
z can also take on values 1,2,3 but can never equal x or y.
I tried using if/and statements to solve this (see below), but I would have to do it for each case and it exceeds Excels embedded function limit. Any one have any ideas?
=If(and(B7=1,B10=1),riskduniform(E4:E5),if(and(B7=1,B10=2),3,if(and(B7=1,B10=3),2,if(and(B7=2,B10=2),riskduniform(1,3),if(and(B7=2,B10=1),3,if(and(B7=2,B10=1),3,if(and(B7=3,B10=3),riskduniform(1,2),if(and(B7=3,B10=1),2,if(and(B7=3,B10=2),1)))))))))
Thank you in advance,
Brian