Help with a string of IF statements

Try selecting cell K4 and pasting the following into the formula bar:

Formula:

=IF($D4="Yes",IF(K$2>EOMONTH($I4,$J4*3-1),$H4/4,IF($I4< EOMONTH(K$2,3),"Void",IF(AND(K$2>EOMONTH(MIN($E4,$F4),$J4*3-1),K$2<$I4),$H4/4,IF(AND(K$2>=MIN($E4,$F4),K$2<=EOMONTH(MIN($E4,$F4),$J4*3-1)),"Void",$G4/4)))),IF(K$2< $F4,$G4/4,$H4/4))

Let us know if you have any questions.