I have one IF statement that is pulling from a list of codes, and I have it only pulling the code "01-7306".

How do I in another IF statement get it to pull all the other code besides the "01-7306", using the same criteria.

below is my IF statement:

=IF(O2="01-7306",IF(AND(Q2>=$Y$1,Q2<=$Z$1),(IF(V2="Yes"," ","Upcoming"))," "),IF(O2="01-7306-01",IF(AND(Q2>=$Y$1,Q2<=$Z$1),(IF(V2="Yes"," ","Upcoming"))," ")," "))

I tried =IF(O2<>"01-7306", and a couple other things, but no luck.

Thanks,
Rob