Assign Formula Values Based On Variables

  • 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,

  • Re: Assigning Values Based On Two Other Variables

    this shouldnt work?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!