EXCEL问题:输入一个数A,分为A小于90,大于90小于100,大于100小于130,大 ...答:OR(A1=90,A1=100,A1=130),"",IF(A1<90,A1*0.1,IF(AND(A1>90,A1<100),A1*0.2,IF(AND(A1>100,A1<130),100*0.2+(A1-100)*0.3,100*0.2+30*0.3+(A1-130)*0.4)))注:由于你的数据条件未涵盖A=90、100、130这三个情况,当A1中输入这三个值时,B1中会返回空值 ...