Hi there,
If you haven't found someone to help you, I'd love the opportunity. I have over 13 years of experience working in Excel using advanced functions and formulas including very complex IF/AND statements.
Hopefully I can take a look at your existing IF statement and hear more about the issue and then I am sure I will be able to solve it for you.
Thanks either way and best of luck!
Shaun