50005000且Y26<10000,应该写作AND(Y26>5000,Y26<10000)。根据题意,公式可以简化如下公式之一:=Y26*IF(Y26<=5000,01,IF(Y26>10000,02,015))=Y26*IF(Y26<=5000,01,IF(Y26<=10000,015,02))=Y26*IF(Y26>10000,02,IF(Y26>5000,015,01))=Y26*IF(Y26>10000,02,IF(Y26<=5000,01,015))=Y26*IF(Y26<=10000,IF(Y26<=5000,01,015),02)=Y26*IF(Y26<=10000,IF(Y26>5000,015,01),02)=Y26*LOOKUP(Y26,{0,001,001},{1,5,2}/100)=Y26*LOOKUP(Y26,{0,001,001;01,015,02})