多个IF不是并列排在一起,应嵌套。另外,公式所在单元格地址AF6不用写进公式。=IF(AE6<=1500,0.03,IF(AE6<=4500,0.1,IF(AE6<=9000,0.2,IF(AE6<=35000,0.25,"大于35000税率"))))