请Excel公式函数高手来为小弟解释一下此公式的含义.=ROUND((B3-MAX(B5-B4,0))*LOOKUP(-(B3-MAX(B5-B4,0))/12,-1000*{9999,100,80,60,40,20,5,2,0.5,0},5%*{9,8,7,6,5,4,3,2,1,0})-LOOKUP(-(B3-MAX(B5-B4,0))/12,-1000*{9999,100,80,60,40,20,5,2,0
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/03 10:36:36
![请Excel公式函数高手来为小弟解释一下此公式的含义.=ROUND((B3-MAX(B5-B4,0))*LOOKUP(-(B3-MAX(B5-B4,0))/12,-1000*{9999,100,80,60,40,20,5,2,0.5,0},5%*{9,8,7,6,5,4,3,2,1,0})-LOOKUP(-(B3-MAX(B5-B4,0))/12,-1000*{9999,100,80,60,40,20,5,2,0](/uploads/image/z/1503799-7-9.jpg?t=%E8%AF%B7Excel%E5%85%AC%E5%BC%8F%E5%87%BD%E6%95%B0%E9%AB%98%E6%89%8B%E6%9D%A5%E4%B8%BA%E5%B0%8F%E5%BC%9F%E8%A7%A3%E9%87%8A%E4%B8%80%E4%B8%8B%E6%AD%A4%E5%85%AC%E5%BC%8F%E7%9A%84%E5%90%AB%E4%B9%89.%3DROUND%28%28B3-MAX%28B5-B4%2C0%29%29%2ALOOKUP%28-%28B3-MAX%28B5-B4%2C0%29%29%2F12%2C-1000%2A%7B9999%2C100%2C80%2C60%2C40%2C20%2C5%2C2%2C0.5%2C0%7D%2C5%25%2A%7B9%2C8%2C7%2C6%2C5%2C4%2C3%2C2%2C1%2C0%7D%29-LOOKUP%28-%28B3-MAX%28B5-B4%2C0%29%29%2F12%2C-1000%2A%7B9999%2C100%2C80%2C60%2C40%2C20%2C5%2C2%2C0)
请Excel公式函数高手来为小弟解释一下此公式的含义.=ROUND((B3-MAX(B5-B4,0))*LOOKUP(-(B3-MAX(B5-B4,0))/12,-1000*{9999,100,80,60,40,20,5,2,0.5,0},5%*{9,8,7,6,5,4,3,2,1,0})-LOOKUP(-(B3-MAX(B5-B4,0))/12,-1000*{9999,100,80,60,40,20,5,2,0
请Excel公式函数高手来为小弟解释一下此公式的含义.
=ROUND((B3-MAX(B5-B4,0))*LOOKUP(-(B3-MAX(B5-B4,0))/12,-1000*{9999,100,80,60,40,20,5,2,0.5,0},5%*{9,8,7,6,5,4,3,2,1,0})-LOOKUP(-(B3-MAX(B5-B4,0))/12,-1000*{9999,100,80,60,40,20,5,2,0.5,0},25*{615,415,255,135,55,15,5,1,0,0}),2)
上述公式是年终奖所得税的计算公式,B3单元格是年终奖,B4是当月工资,B5是起征点,当前为2000元.
小弟不太了解Excel的函数的定义,)特别是大括号内那一大串数字为何要这样写?
你们都回答的什么乱七八糟的,不想答可以不要答,打字也是要消耗体能的!无聊!
请Excel公式函数高手来为小弟解释一下此公式的含义.=ROUND((B3-MAX(B5-B4,0))*LOOKUP(-(B3-MAX(B5-B4,0))/12,-1000*{9999,100,80,60,40,20,5,2,0.5,0},5%*{9,8,7,6,5,4,3,2,1,0})-LOOKUP(-(B3-MAX(B5-B4,0))/12,-1000*{9999,100,80,60,40,20,5,2,0
思雪遥遥说的确实有道理,遇到过太多求助者的不礼貌行为.
楼主的公式不是数组公式.而且(B4是当月工资)这个公式与当月工资没有多大关系了.也就是只要工资大于b5,工资3000和30万所得税是不会变化的.
MAX(B5-B4,0)指起征点减去工资后与0比较取最大值,即b5>b4时,取b5-b4,当b5