how to find missing "false" parts of nested IF formulas

I'm using the following formula in a workbook. As you see it uses multiple IF formulas along with some AND formulas. Is there a "hack" or other methods I can use when building these formulas so that I can see the structure? The approach I want is to say "if the first IF statement is false, go on to the next IF statement"

But as I hover my mouse over the formula I see that in the final ))))))) there are places where the formula is asking for "value if false."

Please Login or Register  to view this content.

Thanks for looking at this.

If you click in the area between each of the close brackets, you will see the help bar moves to position under the relevant IF statement.

Untitled.jpg