Hello,

I am trying to set up a payroll spreadsheet for the automotive shop I work for. I want the spreadsheet to calculate the technician's commission based on the dollar amount he earns that week and the percentage he makes from those earnings. Below is one of the technicians sliding scale and an example of the formula I tried to enter in the spreadsheet based on research I was doing online. Excel said I had too many arguments contained in one cell. I have only created simple spreadsheets, this seems to be really complicated...help please!?

Technician's Sliding Scale:

Maintenance Total Percent Commission
$.00 to $4000.00 14%
$4001.00 to $4500.00 14.5%
$4501.00 to $5000.00 15%
$5001.00 to $5500.00 15.5%
$5501.00 to $6000.00 16%
$6001.00 to $6500.00 16.5%
$6501.00 to $7000.00 17%
$7001.00 to $7500.00 17.5%
$7501.00 to $8000.00 18%
$8001.00 to $8500.00 18%
$8501.00 and up 18%

Formula that I tried entering in cell B2:

=IF(ISNUMBER(B2)=FALSE,0,IF(B2<=4000,0.14,IF(AND(B2>=4001,B2<=4500),0.145,IF(AND(B2>=4501,B2<=5000),0.15,IF(AND(B2>=5001,B2<=5500),0.155,IF(AND(B2>=5501,B2<=6000),0.16,IF(AND(B2>=6001,B2<=6500),0.165,IF(AND(B2>=6501,B2<=7000),0.17,IF(AND(B2>=7001,B2<=7500),0.175,IF(AND(B2>=7501,B2<=8000),0.18,IF(AND(B2>=8001,B2<=8500),0.18,IF(AND(B2>=8501,B2<=10000),0.18))))))

Note: I am also unsure about the $8501.00 and up part of the formula...