View Single Post
  #1   Report Post  
kalsolelady
 
Posts: n/a
Default Calculate comission graduated scale, $2000=20%, $4000=40%, etc?

I need to set up a spreadsheet in Excel 2003 to calculate comission of sales
on a graduated scale. Salesman sells $0-2000, he receives 20% commission;
$2000.01-4000, 40%; etc. I know it's simple, but I'm stuck. Any help is
appreciated. Thank you.