几个EXCEL函数的问题，求高手！算出得分

假定基础分在A列，业绩完成率在B列，达标率在C列，总得分在D列 D2 =12+(A2-12)/12*50+(B2*35)*(B2=0.6)+(50+((B2-1)*50))*(B2=1)+(88.5+((B2-1.5)*55))*(B2>=1.5)+LOOKUP(C2,{0,0.2,0.4,0.6,0.8,1},{1,2,3.5,5.5,8})