请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的函数的定义,)特别是大括号内那一大串数字为何要这样写?
你们都回答的什么乱七八糟的,不想答可以不要答,打字也是要消耗体能的!无聊!