excel如何根据车牌号判断省份
回答如下：可以通过以下公式来判断车牌号所属的省份： =IF(LEFT(A1,1)="京","北京",IF(LEFT(A1,1)="津","天津",IF(LEFT(A1,1)="沪","上海",IF(LEFT(A1,1)="渝","重庆",IF(LEFT(A1,1)="冀","河北",IF(LEFT(A1,1)="豫"...