excel表格中if多条件与lookup的组合应用

见样表截图D1输入=IF(A1="pt1",IF(B11,C1*0.2,""),IF(A1="pt2",C1*IF(B1=50,0.3,0.25),IF(A1="pt3",C1*IF(B1=70,0.4,0.35),IF(A1="pt4",C1*IF(B1=90,0.45,0.4),IF(A1="pt5",C1*IF(B1100,0.48,0.43))))))公式下拉