More efficient conditional check than nested ANDs in an IF(OR

[kcmuppet]

Is there a shorter / more efficient formula for doing than like this?:

=IF(OR(AND(C7<>"",C8=""), AND(C9<>"",C10=""), AND(C11<>"",C12="")), "Check!","Carry on")

I'm flagging if there's a an entry in a cell in one row, but nothing in the corresponding cell in the same column in the next row.

 

[6StringJazzer]

There might be an obscure "tricky" way to do this and make it shorter, but there is nothing about this formula that needs to be fixed. It is straightforward, it is clear to anyone who reads it what is doing, and it will be easy to update if you ever need to change it.

The reason that shortening it would be tricky is that the cells you are checking for <>"" are discontiguous, and the cells you are checking for ="" are discontiguous. Otherwise an array formula might be shorter. But even so, there would nothing inherently better about it.

The only thing I would consider is making it longer to indicate specifically which cells have the problem.

=IF(AND(C7<>"",C8=""),"Check C8 ","")&IF(AND(C9<>"",C10=""), "Check C9 ","")&IF(AND(C11<>"",C12=""), "Check C11 ","")

Actually, I would use three different formulas in three cells, instead of mashing them together.