Excel 中如何使用函数,... 效果...a1=3,a2=4,a3=6 b1=3 如何做到B1=0...答:加IF到8万都正常,但加到10万就出问题! TO: =IF (A1>=0,IF(A1<40000,IF(A1<500,A1*5%,IF(A1<2000,A1*10%,IF(A1< 5000,A1*15%,IF(A1<20000,A1*20%,A1*25%))),IF(A1<60000,A1*30%,IF(A1< 80000,A1*35%,IF(A1<100000,A1*40%,A1*45%))),"数据错误") (!!!)=IF(A1<=500,A1...