problem with if calculating revenue for my employees

[MAXAHMADI]

Hi all,

This is my first posting and skeptical about this. But I still need to get help. I am trying to put a formula together that allows to me track my sales associates commission. I would like to do the following:

If gross profit is below 1000, and units are at 5 or less, then its 50 per units, and if its at 6 to 10, then its 100 per, if tis at 11 to 15, then its 150., but if the gross profit is between more then 1000 and less then 2000, and units are at 5 or less, then its 200 per units, and if its at 6 to 10, then its 250 per, if tis at 11 to 15, then its 150, but if the gross profit is more then 2000, and units are at 5 or less, then its 300 per units, and if its at 6 to 10, then its 3500 per, if tis at 11 to 15, then its 400. I hope this makes sense. I have enclosed a screen shot of what I have. I have this much of the formula but it wont calculate anything over 2000 profit.

=IF((((AA10-(AH10*600))/AH10))<1000,SUMPRODUCT(((((AA10-(AH10*600))/AH10)<1000))*(AH10<=5)*AH10*50)+SUMPRODUCT(((((AA10-(AH10*600))/AH10)<1000))*(IF(AH10>=6,AH10<11)*AH10*100))+SUMPRODUCT(((((AA10-(AH10*600))/AH10)<1000))*(IF(AH10>=11,AH10<16)*AH10*150))+SUMPRODUCT(((((AA10-(AH10*600))/AH10)<1000))*(IF(AH10>=16,AH10<21)*AH10*200))+SUMPRODUCT(((((AA10-(AH10*600))/AH10)<1000))*(AH10>=21)*AH10*250),IF(((((AA10-(AH10*600))/AH10)*1000<>2000)),SUMPRODUCT(((((AA10-(AH10*600))/AH10)*1000<>2000))*(AH10<=5)*AH10*200)+SUMPRODUCT(((((AA10-(AH10*600))/AH10)*1000<>2000))*(IF(AH10>=6,AH10<11)*AH10*250))+SUMPRODUCT(((((AA10-(AH10*600))/AH10)*1000<>2000))*(IF(AH10>=11,AH10<16)*AH10*300))+SUMPRODUCT(((((AA10-(AH10*600))/AH10)*1000<>2000))*(IF(AH10>=16,AH10<21)*AH10*350))+SUMPRODUCT(((((AA10-(AH10*600))/AH10)*1000<>2000))*(AH10>=21)*AH10*400),IF(((((AA10-(AH10*600))/AH10)>2000)),SUMPRODUCT(((((AA10-(AH10*600))/AH10)>2000))*(AH10<=5)*AH10*300)+SUMPRODUCT(((((AA10-(AH10*600))/AH10)>2000))*(IF(AH10>=6,AH10<11)*AH10*350))+SUMPRODUCT(((((AA10-(AH10*600))/AH10)>2000))*(IF(AH10>=11,AH10<16)*AH10*400))+SUMPRODUCT(((((AA10-(AH10*600))/AH10)>2000))*(IF(AH10>=16,AH10<21)*AH10*450))+SUMPRODUCT(((((AA10-(AH10*600))/AH10)>2000))*(AH10>=21)*AH10*500),0)))




Can someone please help me. Thank you.