Sorry about that. Again my first time posting. Doing my best to explain it best I can.

What I'm looking to do is provide a certain amount of credits to some of our sellers for a certain amount sold. Each seller has a baseline amount they need to make each month. Let's say it's $100. So if they make 100%-115% of their baseline, they get 5% back. I've tried to reflect that here.

=IF(AND(E5<1.15,E5>1),D5*0.05,0)

However, if the seller goes over 115% of their baseline, we are only allowed to give them 5% up to that 115%. That's the issue I'm having to finish the formula. I was wondering if there's a way in the false column of the formula to make it so that if they don't meet the baseline they get no credit or give them their 5% up to 115% of what they sold.

I hope that this makes better sense.