series of conditional formulas

[nilizandr]

hello,
i would like to create a formula which says:

if the value in column A is -1, and the value in column B is 2, and th
value is column C is 0, then return the value -1
AND
if the value in column A is 2, and the value in column B is 1, and th
value is column C is -1, then return the value 0
AND
etc.etc.

There is a finite list of possible permutations for the values i
columns A, B, and C, and I would like to define a result for eac
possible permutation. I know that I could accomplish this by dedicatin
a separate column and IF() formula to each possible outcome, the
summing the results, but I'd love to do something more elegant in jus
one column. Any thoughts?

Thanks!
Nil

 

[Guest]

=IF(AND(A1=-1,B1=2,C1=0),-1,"")&IF(AND(A1=2,B1=1,C1=-1),0,"")&...
there's no practical limit to this, because there's no nesting.
Bob Umlas
Excel MVP

 

[nilizandr]

Thanks,
I tried this great recommendation, but now I am getting a #VALUE
error. Any idea why? The individual if(and(...)) commands work fine
but when I try to connect them with "&" I get the error.
Thanks!
Nili