Hi.
I'm using this function:
=IF(AND(C13=0,B13=0),0,IF(AND(C13=1,B13=0),1,IF(AND(C13=2,B13=0),2,IF(AND(C13=1,B13=1),1,IF(AND(C13=2,B13=1),"Unknown",IF(AND(C13=0,B13=2),2,IF(AND(C13=0,B13=1),1,2)))))))
currently, raws "B" and "C" have the values 0,1,2.
This function works fine on raw "A".
The problem occures when I'm adding my final "IF" - as always, just before the "UK", so it looks like this:
=IF(AND(C22=0,B22=0),0,IF(AND(C22=1,B22=0),1,IF(AND(C22=2,B22=0),2,IF(AND(C22=1,B22=1),1,IF(AND(C22=2,B22=1),"Unknown",IF(AND(C22=0,B22=2),2,IF(AND(C22=0,B22=1),1,if(and(C22=1,B22=2),"Unknown",2))))))))
I keep getting an error: "The formula you typed contains an error".
Is there an "AND" usage limit?
any ideas?
Thanks.
I'm using this function:
=IF(AND(C13=0,B13=0),0,IF(AND(C13=1,B13=0),1,IF(AND(C13=2,B13=0),2,IF(AND(C13=1,B13=1),1,IF(AND(C13=2,B13=1),"Unknown",IF(AND(C13=0,B13=2),2,IF(AND(C13=0,B13=1),1,2)))))))
currently, raws "B" and "C" have the values 0,1,2.
This function works fine on raw "A".
The problem occures when I'm adding my final "IF" - as always, just before the "UK", so it looks like this:
=IF(AND(C22=0,B22=0),0,IF(AND(C22=1,B22=0),1,IF(AND(C22=2,B22=0),2,IF(AND(C22=1,B22=1),1,IF(AND(C22=2,B22=1),"Unknown",IF(AND(C22=0,B22=2),2,IF(AND(C22=0,B22=1),1,if(and(C22=1,B22=2),"Unknown",2))))))))
I keep getting an error: "The formula you typed contains an error".
Is there an "AND" usage limit?
any ideas?
Thanks.