excel里,某一单元格数值在某些指定数值范围,作不同的公式计算答:A2=IF(A1<=1000,A1*10,IF(A1<=5000,(A1-1000)*2+1000*10,IF(A1<=10000,(A1-5000)*30+4000*10,IF(A1<=30000,(A1-10000)*40+5000*30+4000*20+100*10,(A1-30000)*50+20000*40+5000*30+4000*20+1000*10)))或 =IF(A1<=1000,A1*10,IF(A1<=5000,(A1-1000)*2+10000,IF(A1...