小区居民的电费，如何计算阶梯电费？

如图
F5=SUMPRODUCT(--TEXT(((D5-$C5)-{0,2160,3120})*{0.56,0.05,0.25},0.00;!0;0))
I5=SUMPRODUCT(--TEXT(((G5-$C5)-{0,2160,3120})*{0.56,0.05,0.25},0.00;!0;0))-F5
L5=SUMPRODUCT(--TEXT(((J5-$C5)-{0,2160,3120})*{0.56,0.05,0.25},0.00;!0;0))-F5-I5
下拉填充即可