Nested IF/AND functions... Multiple Conditions

Hey y'all... Please help me out. I am having difficulty getting my formula to work when I have multiple IF and AND conditions for a formula.

I am trying to do this with the attached:

if (D4) = 2301 2303 2304 2305
and (I12) = Yes
TRUE then (I13) F12-F15-5000
FALSE then (I13) F12-F15


Book3.xlsx

I am trying to use:

Please Login or Register  to view this content.

but it's not working for me.

Try these

Formula:

Please Login or Register  to view this content.

Thank you!

Does D4 contain those 4 values separated by commas? If so, then they will be treated as text values so you need to put quotation marks around them in your formula, like this:

=IF(AND(D4="2301,2303,2304,2305",I12="Yes"),F12-F15-5000,F12-F15)

If D4 only contains one 4-digit number, but it could be one of the 4 listed, then you can do it this way:

=IF(AND(ISNUMBER(MATCH(D4,{2301,2303,2304,2305},0)),I12="Yes"),F12-F15-5000,F12-F15)

I've removed some unnecessary brackets.

Hope this helps.

Pete