Reply to thread

Message: [QUOTE="scottymong, post: 6255978"] We have a sales rep and they enter all their invoices at the end of the month. We want pay out commisions based on each invoice value. So we want to sum up invoices in a certain range and pay out x percetage based on the sum. I can get the first 5% commission I just cant get the 3% and 2% commission formula to work. Here is what I could come up with so far: Invoice value Invoice 1 2000 invoice 2 95001 Invoice 3 1256 invoice 4 62000 Commission 5% for under 50,000= 162.8 =SUMIF($B$3:$B$6,"<=50000")*(0.05) 3% for >50,0001----<=90,000=? =SUMIF($B$3:$B$6,">50000 but <=90000)*. 03 2% for >90,001=? I can work it out on my abucus, but cant get it to work in Excel :) Thanks for any help on this [/QUOTE]