Commission Calculator

       ----A----- ---B--- ---C--- ---D--- ---E--- ---F--- ---G--- ---H--- ---I---
   1       GP      Comm                                                          
   2   Do not Use                                                                
   3         -       0.0%                                                        
   4       2,000     3.5%                                                        
   5      10,000     5.0%                                                        
   6      25,000     6.0%                                                        
   7      40,000     8.0%                                                        
   8      60,000    10.0%                                                        
   9                                                                             
  10                                                                             
  11   Do Not Use Month1  Month2  Month3  Month4  Month5  Month6  Month7  Month8 
  12               9,000   9,000   9,000   9,000   9,000   9,000   9,000   9,000 
  13                 245     435     470     540     640     720     780     900

The formula in B13 and copied across is


=SUMPRODUCT((SUM($B12:B12) > $A$3:$A$8) * (SUM($B12:B12) - $A$3:$A$8), $B$3:$B$8 - $B$2:$B$7) - SUM($A13:A13)

I've edited your thread title. Please take a few minutes to read the forum rules before posting again.

Thanks.