Complex If Statement

here's a copy saved as a 2003 format....

obviously it gave me a major error because of the length of the formulas.

but... i thought this way you might get the visual.