假设用电度数写在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)
没有实际的行列号？
D2=IF(AND($C2>=0,$C2<=190),$C2*0.5,IF(AND($C2>=191,$C2<=990),$C2*1,$C2*1.5))
下拉公式
内容全部来源于网络收集，如有侵权，请联系网站删除！