题意理解:当A列含有“陈堂村”或“陈庄村”字符串时,B列显示“坝桥”;当A列含有“丁楼村”或“大苏庄村”字符串时,B列显示“张汪”
解法:在 Excel 2007 中,可以用下列公式满足上述要求:
=IF(MID(A4,FIND("镇",A4)+1,10)="陈堂村","坝桥",IF(MID(A4,FIND("镇",A4)+1,10)="陈庄村","坝桥",IF(MID(A4,FIND("镇",A4)+1,10)="丁楼村","张汪",IF(MID(A4,FIND("镇",A4)+1,10)="大苏庄村","张汪",""))))
注:针对下图的表格,B1单元格输入公式并下拉即可
公式的结果如下图示: