LEFT取得的值为文本一是乘数字1转化为数值，二是等于号右边的值加双引号=IF(OR(LEFT(D3,6)*1=371323,LEFT(D3,6)*1=372827),"沂水","其他县区")或者=IF(OR(LEFT(D3,6)="371323",LEFT(D3,6)="372827"),"沂水","其他县区")
