Error using IF/AND/OR Statement with multiple conditions

[d87]

I am trying to write a formula based on the following conditions and it is not working

• IF A1 = "S", and B1 = 254 or 127, Use LIST NOLIST
• IF A1 = "F" or "M", and B1 = 254, and C1 is even, Use LIST EVEN254
• IF A1 = "F" or "M", and B1 = 254, and C1 is odd, use LIST ODD254
• IF A1 = "F" or "M", and B1 = 127, and C1 is even, Use LIST EVEN127
• IF A1 = "F" or "M", and B1 = 254, and C1 is odd, use LIST ODD127

Here's the formula I am currently using. I am receiving an #VALUE error

=IF(OR(AND(B1=127,B1=254),AND(A1="S")),NOLIST,IF(OR(AND(A1="F",A1="M"),AND(B1=127,C1="T")),EVEN127,IF(OR(AND(A1="F",A1="M"),AND(B1=127,C1="F")),ODD127,IF(OR(AND(A1="F",A1="M"),AND(B1=254,C1="T")),EVEN254,IF(OR(AND(A1="F",A1="M"),AND(B1=254,C1="F")),ODD254,"")))))

I also tried this which did not work either

=IF(AND(B1=254,C1="T",OR(A1="F",A1="M")),EVEN254,IF(AND(B1=254,C1="F",OR(A1="F",A1="M")),ODD254,IF(AND(B1=127,C1="T",OR(A1="F",A1="M")),EVEC127,IF(AND(B1=127,C1="F",OR(A1="F",A1="M")),ODD127,IF(AND(B1=254,B1=127),OR(A1="S")),NOLIST,""))))

My initial formula was working, and then I realized I had to add the conditions for the ODD/EVEN numbers so after I added those conditions to the formula, it stopped working. Here's my original formula

=IF(OR(AND(B1=127,B1=254),AND(A1="S")),NOLIST,IF(OR(AND(A1="F",A1="M"),AND(B1=127)),EVEN127,IF(OR(AND(A1="F",A1="M"),AND(B1=254)),EVEN254,"")))

I changed the list names for simplicity, so the original list names did not contain even/odd.

Can anyone help me solve this?

 

[mole999]

should EVEN254 bw text, so requires "" to wrap ?

 

[Fluff]

If nolist, even254 are named ranges try
=IF(AND(A1="S",OR(B1={254,127})),list,IF(OR(A1={"F","M"}),IF(B1=254,IF(C1="T",even254,ODD254),IF(B1=127,IF(C1="T",even127,ODD127))),""))

 

[d87]

should EVEN254 bw text, so requires "" to wrap ?

That doesn't seem to make a difference, but thank you for your help!

 

[d87]

If nolist, even254 are named ranges try
=IF(AND(A1="S",OR(B1={254,127})),list,IF(OR(A1={"F","M"}),IF(B1=254,IF(C1="T",even254,ODD254),IF(B1=127,IF(C1="T",even127,ODD127))),""))

That does seem to work, but the only issue is that I forgot to mention I am putting in a data validation as a list and arrays cannot be used. Thank you for your help!

 

[Fluff]

In that case do it like
OR(B1=254,B1=127)