关于阶梯电价的电费计算公式Excel

2025-03-24 22:26:15

推荐回答（3个）

回答1：

如图输入公式
=IF(A2<=180,0.573*A2,IF(AND(A2>180,A2<=400),180*0.573+(A2-180)*0.623,0.573*180+0.623*220+0.873*(A2-400)))

回答2：

假设用电度数写在A1单元格,则
B1单元格写入公式
=IF(A1="","",IF(A1<181,A1*0.573,IF(A1<401,(A1-181)*0.623+103.713,(A1-401)*0.873+240.773)))
或
=MAX(A1*{0.573,0.623,0.873}-{0,9.05,109.3})

如果还要四舍五入保留两位小数,则公式为
=ROUND(MAX(A1*{0.573,0.623,0.873}-{0,9.05,109.3}),2)

回答3：

如果用电的度数在b2,c3为电费，那么在c3输入=if(b2<181,b2*0.573,if(b2<401,(b2-180)*0.623+180*0.573,(b2-400)*0.873+(400-180)*0.623+180*0.573)