drop down list data change in excell

i have an excell sheet ,the user will first choose the type from a drop down list which contains (Payroll,Staff,selfemployeed,other) , for each of these types we wull have three percents (percent 1, percent 2, percent 3).so if the user choose Payroll he will get (5%,6%,7%) for percent 1 , percent 2, percent 3)
if he choses Staff, he will get (7,8,10 %) for ( percent 1 , percent 2, percent 3)

and there is a list a field that must give him if the loan is approved or not, so if the summation of (percent 1 & percent 2 & percent 3)<35 then it must returns approved..else the filed must return not approved
loan.xlsx