求教Excel函数问题,编写一个计算个人所得税的函数。答:B1=MAX((A1)*{0.03,0.1,0.2,0.25,0.3,0.35,0.45}-{0,105,555,1005,2755,5505,13505},0)C1=IF(A1> 80000,A1*0.45-13505,IF(A1 > 55000,A1*0.35-5505,IF(A1 > 35000,A1*0.3-2755,IF(A1 > 9000,A1*0.25-1005,IF(A1 > 4500,A1*0.2-555,IF(A1 >1500,A1*0.1...
excel表格中,改变数值不改变乘积和答:L1=SUM(B1:J1*{A,B,C,D,E,F,G,H,I})公式可向下复制(注:A,B,C...是要乘的数),这样只需要改变B-J列的数据,l列里面的数值就能自动改变.