Question

求一个excel公式

如题，小于等于18部分提点0.09，18-24部分提点0.12，24-30部分提点0.15，30以上部分提点0.2

Answer 1

试试公式：
=SUMPRODUCT(TEXT(A1-{0,18,24,30},"0.00;\0")*{0.09,0.03,0.03,0.05})

Answer 2

=a2*if(a2>30,0.2,if(a2>24,0.15,if(a2>18,0.12,0.09)))

追问

题目没有表述清楚，已经修改过

追答

这个就类似个人所得税的算法了
=if(a2<18,a2*0.09,if(a2<24,18*0.09+(a2-18)*0.12,if(a2<30,18*0.09+6*0.12+(a2-24)*0.15,18*0.09+6*0.12+6*0.15+(a2-30)*0.2)))

Answer 3

B1为A1的星期数，为何是=WEEKDAY(D4,2)？？D4的？假设你公式弄错了！

C1公式=2+(B1>4)或者=if(b1>4,3,2)

Answer 4

=lookup(A1,{0,18,24,30},{0.09,0.12,0.15,0.2})

追问

题目没有表述清楚，已经修改

Answer 5

=if(a1<18,0.09,if(a1<24,0.12if(a1<30,0.15,0.2)))

追问

题目没有表述清楚，已经改过

题目没有表述清楚，已经改过