# Nested IF error

Occasional Visitor

# Nested IF error

Hi! I have a problem here I don't know how. The last if seems to be problematic. When I use IF 5 times its OK but when I add the last one it won't let me finish the formula. I'm assigning a value based on the string (a-c) and if the row is odd or even. I have a list of some values for example abcbaba and next to it the Q-P 5-7 table of values to assign. I don't know if it is enough info, I would have to remake the table (translate, remove sensible data...)

=IF(AND(C5="a";ISEVEN(ROW()));\$Q\$5;

IF(AND(C5="a";ISODD(ROW()));\$P\$5;

IF(AND(C5="b";ISEVEN(ROW()));\$Q\$6;

IF(AND(C5="b";ISODD(ROW()));\$P\$6;

IF(AND(C5="c";ISEVEN(ROW()));\$Q\$7;

IF(AND(C5="c";ISODD(ROW()));\$P\$7;"error"))))) (error here to let me know i wrote bad string value)

2 Replies

# Re: Nested IF error

You're missing the last closing parenthesis:

=IF(AND(C5="a",ISEVEN(ROW())),\$Q\$5,IF(AND(C5="a",ISODD(ROW())),\$P\$5,IF(AND(C5="b",ISEVEN(ROW())),\$Q\$6,IF(AND(C5="b",ISODD(ROW())),\$P\$6,IF(AND(C5="c",ISEVEN(ROW())),\$Q\$7,IF(AND(C5="c",ISODD(ROW())),\$P\$7,"error"))))))

Here is a shorter version of the formula:

=IF(C5="a",IF(ISODD(ROW()),\$P\$5,\$Q5),IF(C5="b",IF(ISODD(ROW()),\$P\$6,\$Q\$6),IF(C5="c",IF(ISODD(ROW()),\$P\$7,\$Q\$7),"error")))

# Re: Nested IF error

As variant

``````=INDEX(
\$Q\$5:\$R\$7,
1*(\$C\$5="a")+2*(\$C\$5="b")+3*(\$C\$5="c"),
MOD(ROW(),2)+1)``````