公式只能对公式所在的单元格产生作用。输入后自动改变可以在选项-校对里设置自动更正，或用vba里的change事件。
参考如下公式：=IF(COUNT(FIND({"北京","天津","河北","山西","内蒙古"},C33)),"华北",IF(COUNT(FIND({"辽宁","吉林","黑龙江"},C33)),"东北",IF(COUNT(FIND({"上海","江苏","浙江","安徽","福建","江西","山东"},C33)),"华东",IF(COUNT(FIND("河南",C33)),"华中",IF(COUNT(FIND({"湖北","湖南","广东","广西","海南"},C33)),"华南",IF(COUNT(FIND({"重庆","四川","贵州","云南","西藏"},C33)),"西南","西北"))))))
内容全部来源于网络收集，如有侵权，请联系网站删除！