【excel技巧】阶梯电价、提成和个税怎么算
一片粉嫩的羽毛
2024-05-31 21:37:12
最佳回答
1如下图所示,a1单元格存储本月所用电量数(单元格实际输入的数据是633,通过自定义单元格格式显示成如图效果),需根据阶梯价格表计算本月应交电费金额。1此文章未经授权抓取自百度经验2为解决上述问题提供下列3个公式,本次讲解第一个公式:=sumproduct(if(a1-{0,260,600}>0,a1-{0,260,600},)*{0.68,0.05,0.25})=sumproduct(text(a1-{0,260,600},"0;\0")*{0.68,0.05,0.25})=sumproduct(text(a1%-{0,2.6,6},"0%;\0")*{68,5,25})end 20210311