I would not like the responsibility of maintaining your IF statement!

Looking at the statement your AND statements are the wrong construct...

=IF(AND(condition1,condition2 ,,,,,,,),TRUE result, FALSE result)

NOT

=IF(AND(condition1,AND(condition2 )),TRUE result, FALSE result)

I am sure the statements can be improved: hard coding names does not appear a good approach.