Combining Formulas

[HotWheels]

I have the following 4 formulas that I would like to combine into one and just can not get it to work. What this is trying to figure out is a person’s current level in cell (D3), what the level is for current assessment in cell (D1) and then figure out their rating based on the values in the formulas.


1st
=IF(D1=0,"-",IF(AND((D3)="QA Lead",(D1)>=400),"Outstanding",IF(AND((D3)="QA Lead",(D1)>=364,(D1)<401),"Exceeds",IF(AND((D3)="QA Lead",(D1)>=328,(D1)<365),"Successful",IF(AND((D3)="QA Lead",(D1)<328),"Needs Imp")))))

2nd
=IF(D1=0,"-",IF(AND((E3)="Sr. QA Analyst",(D1)>=360),"Outstanding",IF(AND((E3)="QA Lead",(D1)>=327,(D1)<360),"Exceeds",IF(AND((E3)="QA Lead",(D1)>=294,(D1)<327),"Successful",IF(AND((E3)="QA Lead",(D1)<294),"Needs Imp")))))

3rd
=IF(D1=0,"-",IF(AND((D3)="QA Analyst II",(D1)>=277),"Outstanding",IF(AND((D3)="QA Analyst II",(D1)>=252,(D1)<277),"Exceeds",IF(AND((D3)="QA Analyst II",(D1)>=227,(D1)<252),"Successful",IF(AND((D3)="QA Analyst II",(D1)<227),"Needs Imp")))))

4th
=IF(D1=0,"-",IF(AND((D3)="QA Analyst II",(D1)>=263),"Outstanding",IF(AND((D3)="QA Analyst II",(D1)>=239,(D1)<263),"Exceeds",IF(AND((D3)="QA Analyst II",(D1)>=215,(D1)<239),"Successful",IF(AND((D3)="QA Analyst II",(D1)<215),"Needs Imp")))))