想问个excel的函数问题!大于多少乘以多少，小于多少乘以多少

Question

想问个excel的函数问题 如果A1<1600则乘以0.84,如果1600<=A1<2000则乘以0.77，如果2000<=A1<3000,则乘以0.7，如果A1>=3000则乘以0.63，求个高手帮帮忙

Answer 1

这是个普通的if函数组合
B1输入：
=if(a1<1600,a1*0.84,if(a1<2000,a1*0.77,if(a1<300,a1*0.7,a1*0.63)))
下拉填充

Answer 2

=IF(A1>=3000,A1*0.63,IF(A1>=2000,A1*0.7,IF(A1>=1600,A1*0.77,A1*0.84)))

Answer 3

这是个普通的if函数组合
B1输入
=if(a1<1600,a1*0.84,if(a1<2000,a1*0.77,if(a1<300,a1*0.7,a1*0.63)))
下拉填充

Answer 4

=LOOKUP(A1,{0,1600,2000,3000},{0.84,0.77,0.7,0.63})*A1