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?
Thank you in advance,