公式1:不知道为啥数量一多就不能使用,以前这个公式都是可以正常运行
=IF(D2="Florida","FL",IF(D2="Pennsylvania","PA",IF(D2="California","CA",IF(D2="Louisiana","LA",IF(D2="New York","NY",IF(D2="Georgia","GA",IF(D2="Ohio","OH",IF(D2="Illinois","IL",IF(D2="South Carolina","SC",IF(D2="North Carolina","NC",IF(D2="Texas","TX",IF(D2="Michigan","MI",IF(D2="Kansas","KS",IF(D2="Maryland","MD",IF(D2="Oklahoma","OK",IF(D2="Tennessee","TN",IF(D2="Colorado","CO",IF(D2="Missouri","MO",IF(D2="Oregon","OR",IF(D2="Wisconsin","WI",IF(D2="Alabama","AL",IF(D2="New Mexico","NM",IF(D2="Massachusetts","MA",IF(D2="Indiana","IN",IF(D2="New Jersey","NJ",IF(D2="Virginia","VA",IF(D2="Nevada","NV",IF(D2="Connecticut","CT",IF(D2="Arkansas","AR",IF(D2="Utah","UT",IF(D2="South Dakota","SD",IF(D2="Arizona","AZ",IF(D2="Mississippi","MS",IF(D2="Idaho","ID",IF(D2="Minnesota","MN",IF(D2="Montana","MT",IF(D2="Kentucky","KY",IF(D2="Washington","WA",IF(D2="North Dakota","ND",IF(D2="Iowa","IA",IF(D2="Maine","ME",IF(D2="New Hampshire","NH",IF(D2="Delaware","DE",IF(D2="Nebraska","NE",IF(D2="District of Columbia","DC",IF(D2="West Virginia","WV",IF(D2="Rhode Island","RI",1))))))))))))))))))))))))))))))))))))))
公式2:数量少可以正常运行,再多一个都会报错
=IF(D2="Florida","FL",IF(D2="Pennsylvania","PA",IF(D2="California","CA",IF(D2="Louisiana","LA",IF(D2="New York","NY",IF(D2="Georgia","GA",IF(D2="Ohio","OH",IF(D2="Illinois","IL",1))))))))![](http://tiebapic.baidu.com/forum/w%3D580/sign=82921f85d8510fb37819779fe933c893/41a3a4c27d1ed21b6aab7fd9eb6eddc451da3f67.jpg?tbpicau=2024-07-03-05_47a555ad44bf575f41d37e0010562f39)
![](http://tiebapic.baidu.com/forum/w%3D580/sign=567bcf14d12bd40742c7d3f54b899e9c/05cafc039245d6888b60e398e2c27d1ed21b2467.jpg?tbpicau=2024-07-03-05_674238d81087135ed1293df67f1a8e51)
=IF(D2="Florida","FL",IF(D2="Pennsylvania","PA",IF(D2="California","CA",IF(D2="Louisiana","LA",IF(D2="New York","NY",IF(D2="Georgia","GA",IF(D2="Ohio","OH",IF(D2="Illinois","IL",IF(D2="South Carolina","SC",IF(D2="North Carolina","NC",IF(D2="Texas","TX",IF(D2="Michigan","MI",IF(D2="Kansas","KS",IF(D2="Maryland","MD",IF(D2="Oklahoma","OK",IF(D2="Tennessee","TN",IF(D2="Colorado","CO",IF(D2="Missouri","MO",IF(D2="Oregon","OR",IF(D2="Wisconsin","WI",IF(D2="Alabama","AL",IF(D2="New Mexico","NM",IF(D2="Massachusetts","MA",IF(D2="Indiana","IN",IF(D2="New Jersey","NJ",IF(D2="Virginia","VA",IF(D2="Nevada","NV",IF(D2="Connecticut","CT",IF(D2="Arkansas","AR",IF(D2="Utah","UT",IF(D2="South Dakota","SD",IF(D2="Arizona","AZ",IF(D2="Mississippi","MS",IF(D2="Idaho","ID",IF(D2="Minnesota","MN",IF(D2="Montana","MT",IF(D2="Kentucky","KY",IF(D2="Washington","WA",IF(D2="North Dakota","ND",IF(D2="Iowa","IA",IF(D2="Maine","ME",IF(D2="New Hampshire","NH",IF(D2="Delaware","DE",IF(D2="Nebraska","NE",IF(D2="District of Columbia","DC",IF(D2="West Virginia","WV",IF(D2="Rhode Island","RI",1))))))))))))))))))))))))))))))))))))))
公式2:数量少可以正常运行,再多一个都会报错
=IF(D2="Florida","FL",IF(D2="Pennsylvania","PA",IF(D2="California","CA",IF(D2="Louisiana","LA",IF(D2="New York","NY",IF(D2="Georgia","GA",IF(D2="Ohio","OH",IF(D2="Illinois","IL",1))))))))
![](http://tiebapic.baidu.com/forum/w%3D580/sign=82921f85d8510fb37819779fe933c893/41a3a4c27d1ed21b6aab7fd9eb6eddc451da3f67.jpg?tbpicau=2024-07-03-05_47a555ad44bf575f41d37e0010562f39)
![](http://tiebapic.baidu.com/forum/w%3D580/sign=567bcf14d12bd40742c7d3f54b899e9c/05cafc039245d6888b60e398e2c27d1ed21b2467.jpg?tbpicau=2024-07-03-05_674238d81087135ed1293df67f1a8e51)