如图例：
B2=SUM(TEXT(A2-{0,4,10},"0;!0")*{10,-5,-1.5})
借用
xsczd
的公式:=SUM(TEXT(A1-{0,3,9},"0;!0")*{10,-5,-1.5})
A1代表数据 IF(A1<4,A1*10,IF(A1<=10,A1*5,A1*3.5))
