K4=EDATE(J4,1), copy across.
J8=IF(AND(J$4>=$E8,J$4<=$F8,J$4<$H8),$G8/12*1000,IF(OR(J$4<$E8,J$4>$F8),0,$G8/12*1000*(1+$I8))).
K4=EDATE(J4,1), copy across.
J8=IF(AND(J$4>=$E8,J$4<=$F8,J$4<$H8),$G8/12*1000,IF(OR(J$4<$E8,J$4>$F8),0,$G8/12*1000*(1+$I8))).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks