excel中如何用折扣表计算折扣 使用函数哦，麻烦啦

用lookup函数解决

公式：=LOOKUP(A2,{0;56;61;66;71},{0;2;4;6;8})

第一项“zd砖”的折扣，专用公式
=J3*K3*IF(J3*K3<100,$E$3,IF(J3*K3<300,$E$4,$E$5))
合计，用属公式
=J3*K3-J3*K3*IF(J3*K3<100,$E$3,IF(J3*K3<300,$E$4,$E$5))
=TEXT(NOT(OR(B2={"canceled","suspend","ask for leave"}))*(C1-B1)+NOT(OR(D2={"canceled","suspend","ask for leave"}))*(E1-D1)+NOT(OR(F2={"canceled","suspend","ask for leave"}))*(G1-F1),"[H]")
或者：
=TEXT(AND(B2<>{"canceled","suspend","ask for leave"})*(C1-B1)+AND(D2<>{"canceled","suspend","ask for leave"})*(E1-D1)+AND(F2<>{"canceled","suspend","ask for leave"})*(G1-F1),"[H]")

在e1单元格输入如下公式，然后往下填充即可。
=d1*0.85