I'm trying to calculate commissions for my team. They get $100 per unit sold once they hit 9. But if its a half deal (.5) they do not get $50 instead. Only on full deals.
example: 1-8 deals = 0 bonus
9 deals = $900
9.5 deals = $900
10 deals=$1000 and so on
but with my formula 9.5 deals= $950...