代管货物,阶梯收费,能否在一个单元格内用公式计算出结果?详见截图
B2è¾å ¥
=SUMPRODUCT(TEXT(A2-{0,7,180,240,365},"0;\0")*{0,0.4,0.1,0.1,0.1})
ä¸æå ¬å¼