累進差價計費 分月份 (8892)

SUM(TEXT(D4-{0;40;45}+(LOOKUP(MONTH(A4),{0,5,11})=5)*{0;10;10},"0;!0")*{3.5;0.5;1.25})

另解=SUM(TEXT(D4-{0;40;45}+(MOD(MONTH(A4)-5,12)<6)*{0;10;10},"0;!0")*{3.5;0.5;1.25})

另解=SUM(TEXT(C4-(ABS(MONTH(A4)-7.5)>2.5)*{0,10,10}-{0,30,35},"[<]!0")*{3.5,0.5,1.25})