One time commission triggers

[wthomasoh]

Hello,

I need to calculate when a one time commission is triggered.

The commission award is based on total closed sales milestones, so -

once you reach 50 closed sales you get a $500 1x commission the next month
once you reach 100 sales you get a $500 1x commission the next month
and so on for each 100 closed sales

since you may not make 100 sales in any given month, i need to be able to track over time

I am sure there is a way to do this, just not sure how to ask

Thanks!

 

[shg]

       --A-- ---B---
   1   Sales  Comm  
   2      49     $0 
   3      50     $0 
   4      51   $500 
   5      99   $500 
   6     100 $1,000 
   7     101 $1,000 
   8     199 $1,000 
   9     200 $1,500 
  10     201 $1,500

The formula in B2 and down is

=500*((A2>50) + INT(A2/100))