=IF(A1<8,0,IF(A1<=11,B1*.6,IF(A1<=16,B1,IF(A1<=19,B1*1.2,B1*1.5))))
=lookup(A1-0.0001,{0,8,11,16,19},{0,0.6,1,1.2,1.5})*B1少了个19到20之间的条件,请补充完整