=IF(OR(Combo_4_000664!C11={"All","222"}),"1",IF(Co mbo_4_000664!C11="quota","0","else..."))


"Eden397" wrote:

I am confused as to why I'm getting a "FALSE" from 3 IF Statements. Here is
my function:

=IF(Combo_4_000664!C11="All","1",IF(Combo_4_000664 !C11="quota","0",IF(Combo_4_000664!C11="222","1")) )

but I am getting a "FALSE" when I enter 222 in my linked spreadsheet. I
believe it's because I am already using a "1" for my "All" case, so does
anyone
know how to rewrite this to clean it up. I really appreciate this help,
everyone.