excel选择语句公式太长了不能计算，怎么才能解决这个問題。

可以用vlookup类的函数代替你现在的公式。=IF(ISNA(VLOOKUP(B5,{"ZH1",14;"ZH2",14;"ZH3",16;"ZH4",16;"ZH5",16;"ZH6",20;"ZH1a",22;"ZH2a",28;"ZH3a",28;"ZH2b",14;"ZH3b",25;"ZH4b",25;"ZH2c",16;"ZH3c",18;"ZH4c",20;"ZH5c",20;"ZH6c",25;"ZH2d",16;"ZH3d",18;"ZH4d",20;"ZH5d",20;"ZH6d",25},2,)),,VLOOKUP(B5,{"ZH1",14;"ZH2",14;"ZH3",16;"ZH4",16;"ZH5",16;"ZH6",20;"ZH1a",22;"ZH2a",28;"ZH3a",28;"ZH2b",14;"ZH3b",25;"ZH4b",25;"ZH2c",16;"ZH3c",18;"ZH4c",20;"ZH5c",20;"ZH6c",25;"ZH2d",16;"ZH3d",18;"ZH4d",20;"ZH5d",20;"ZH6d",25},2,))