请问:=IF(M8>=2%,0,IF(2%>M8>=1.5%,8-(M8-1.5%)/0.5%*8,IF(1.5%>M8>=1%,13-(M8-1%)/0.5%*5,IF(1%>M8>0,18-M8/1%*5,IF(0>=M8>=-0.3%,18,IF(-0.3>M8>=-1%,18-(-0.3%-M8)*2/0.7*100,IF(M8M8>=1.5% 这样的条件Excel是识别不了的!这样的条件可以写成and(M8>=1.5%,M8M8>=-1%中的0.3应该是0.3%,别的看不出有错了,返回的值是根据条件计算的,M8=0时,返回的是IF(-0.3%>M8>=-1%,18-(-0.3%-M8)*2/0.7*100,IF(M8=M8=M810时为5 |