IF AND with WILDCARD

[ah2024_2024]

I've adding a VBA to sheet with a ton of date and I'm good most ever where but cannot for the life of me figure out how to make this work.

=IF(AND($AP6,">=2/1/2025",$D6<=$AV6,$AQ6=2,I6="A",$O6,"<>*FLAT RATE"),"YES","NO")

I have now figured out that it's that an IF AND cannot support a wildcard (the FLAT RATE section of the formula).

ANY HELP WOULD BE APPRECIATED.

 

[ah2024_2024]

Try:

=IF(AND($AP6>=DATE(2025,2,1),$D6<=$AV6,$AQ6=2,I6="A",RIGHT($O6,9)<>"FLAT RATE"),"YES","NO")

 

[ah2024_2024]

THIS did it. I'm not sure I would have ever gotten there! Thank you Cubist!

 

[Cubist]

Glad we could help.
Note that dates are serial numbers and when you do >="2/1/2025", you're comparing a number with a string so won't work as intended.