Question

excel表格 假如a1大于等于10000 a1*0.5 A1大于等于20000 a1*0.8 A1小于10000 A1*0.3 公式怎么写

Answer 1

=if(a1<10000,a1*0.3,if(a1<20000,a1*0.5,a1*0.8))

追问

如果在加2个大于呢该怎么写 比如在加大于30000 a1*0.9 大于40000 a1*0.12

追答

=if(a1<10000,a1*0.3,if(a1<20000,a1*0.5,if(a1<30000,a1*0.8,if(a1<40000,a1*0.9,a1*1.2))))
大于40000，应该是1.2*a1吧

Answer 2

=if(a1<10000,a1*0.3,if(a1<20000,a1*0.5,a1*0.8))
同1楼

Answer 3

B1=IF(A>=20000,A1*0.8,IF(A1>=10000,A1*0.5,A1*0.3))

Answer 4

电子表格如果表一A1大于等于1小于等于5，则表二A1等于1,如果表一A1大于5，=LOOKUP(Sheet1!A1,{0,0;1,1;6,2}) 在sheet2的a1单元格

Answer 5

=iif(a1>=20000,a1*.8,iif(a1<=10000,a1*.3,a1*.5))