if(and(or...logic question

Hello all

im having some serious struggle trying to implement put logic that works ...here is my formula

=IF(AND('ISE Performance'!$BQ11>0,$C8<>"ISE Name"),SUMPRODUCT(--('OTS Bonus Payout'!$C$6:$C$16<=D8),--('OTS Bonus Payout'!$E$6:$E$16>=D8),'OTS Bonus Payout'!$G$6:$G$16),"")

it works, however there is one other step that im failing to add. basically, im trying to calculate the bonus amount based on the sale person's performance.

my criteria is as follows:
1) bonus applies if person has tenure greater than 3 months
2) if C8 on bonus worksheet has a name "john doe" then find the bonus range in column E and then column F gives the bonus amount

the issue:
-when the person enters their 4th month, bonus should be given on the 4th month, but my formula shows bonus for months 1, 2, 3
i.e. I got hired in Feb....i should get paid in may, my formula works fine but when may comes by....a bonus amount is assigned to feb/march/april


can someone pls help. i have highlighted the columns in "red" that i need to implement another logic that will not show bonus prior to 3 months.

pls help!! **pls run macro "unprotect sheet"

also, in my current example, the sales person should not be getting any bonus, formula works, but when his tenure increase beyond 3 months, all bonus value show.

any suggestions guys?

anything guys? pls and thx u

pls help guys!!