Nested iif else condition.

[Sana Firdaus]

This is quite easy to get but m not getting expected results.I have a field final,Get1,get2,get3,get4.These fields are having G,R,B,Y inside it as data.so,the formula is if get1,get2,get3,get4 all are G ,THEN Final wud be G,IF any of get1,get2,get3 and get4 is R ,then R,if any of get1,get2,get3 and get4 is Y,then Y provided none is R,else final wud be B.HERE IS THE Formula I am applying:

iif(get1="R" or get2="R" or get3="R" or get4="R","R",iif(get1="Y" or get2="Y" or get3="Y" or get4="Y" And get1 <> "R" & get2 <> "R" & get3 <> "R" & get4 <> "R"," Y",iif(get1="G" & get2="G" & get3="G" & get4="G","G","B")))

The problem is for all get1,get2,get3 and get4 as G,I m getting "Y" as final instead of G.please help.Thanks

[JoeM]

Note that it looks like you switched over mid function from using AND to using &.
Note that & is a concatenation function, and doesn't function as AND.
Also, in the second and third cases with you are using both OR and AND, I would recommend using parentheses to make sure the order is working as it should (i.e. surround the ORs with parentheses and the ANDs with parentheses).