如图所示我只会写出一行函数输出正确了，但是多次判断就不会写了，求大佬帮忙优化下

=IF(AND(B5="1米48",D5="是"),SUM(I5*C5*1.1))
=IF(AND(B5="1米48",D5="否"),SUM(I5*C5*1))
=IF(AND(B5="1.5米48",D5="是"),SUM(I6*C5*1.1))
=IF(AND(B5="1.5米48",D5="否"),SUM(I6*C5*1))
=IF(AND(B5="2米48",D5="是"),SUM(I7*C5*1.1))
=IF(AND(B5="2米48",D5="否"),SUM(I7*C5*1))
=IF(AND(B5="1米60",D5="是"),SUM(K5*C5*1.1))
=IF(AND(B5="1米60",D5="否"),SUM(K5*C5*1))
=IF(AND(B5="1.5米60",D5="是"),SUM(K6*C5*1.1))
=IF(AND(B5="1.5米60",D5="否"),SUM(K6*C5*1))
=IF(AND(B5="2米60",D5="是"),SUM(K7*C5*1.1))
=IF(AND(B5="2米60",D5="否"),SUM(K7*C5*1))

=lookup(1,0/(b5={"1米48","1.5米48","2米48","1米60","1.5米60","2米60"}),c5*(1+(D5="是")/10)*{I5,I6,I7,K5,K6,K7})

看这个有数据对照表，可以=sumproduct((h$5:j$7=b5)*i$5:k$7)*c5*vlookup(d5,h$12:i$13,2,0)

把各种工件名称与单价放成六行两列（右边两列1米60开始的放到2米48下面），就可以用Vlookup公式了=IF(D5="是",VLOOKUP(B5,H:I,2,0)*C5*1.1,VLOOKUP(B5,H:I,2,0)*C5)+17.5*F5

ok已经很简洁了，谢谢大佬们支持 @彩虹蓝宝石 @抖/头条
阿管gg