这个公式有什么错误!=IF(C3=11,"单柱1-1",IF(C3=12,"单柱1-2",IF(C3=13,"单柱1-3",IF(C3=21,"单柱2-1",IF(C3=31,"单柱3-1",IF(C3=41,"单柱4-1",IF(C3=42,"单柱4-2",IF(C3=211,"双柱1-1",IF(C3=212,"双柱1-2",IF(C3=213,"双柱1-3",IF(C3=214,"双柱1-4",IF(C3=221,"双柱2-1",IF(C3=222,"双柱2-2",IF(C3=231,"双柱3-1",IF(C3=711,"悬臂柱1-1",IF(C3=712,"悬臂柱1-2",IF(C3=713,"悬臂柱1-3",IF(C3=721,"悬臂柱2-1",IF(C3=722,"悬臂柱2-2",IF(C3=0,"附着标志"))))))))))))))))))))
问题描述：
这个公式有什么错误!
=IF(C3=11,"单柱1-1",IF(C3=12,"单柱1-2",IF(C3=13,"单柱1-3",IF(C3=21,"单柱2-1",IF(C3=31,"单柱3-1",IF(C3=41,"单柱4-1",IF(C3=42,"单柱4-2",IF(C3=211,"双柱1-1",IF(C3=212,"双柱1-2",IF(C3=213,"双柱1-3",IF(C3=214,"双柱1-4",IF(C3=221,"双柱2-1",IF(C3=222,"双柱2-2",IF(C3=231,"双柱3-1",IF(C3=711,"悬臂柱1-1",IF(C3=712,"悬臂柱1-2",IF(C3=713,"悬臂柱1-3",IF(C3=721,"悬臂柱2-1",IF(C3=722,"悬臂柱2-2",IF(C3=0,"附着标志"))))))))))))))))))))
答
你是用03版的EXCEL吧,在这个版本中函数只能嵌套7层,你用的IF函数层数太多了,所以出错(07以上版本你这个IF公式还是可以用的)公式改成如下=IF(C3="","",VLOOKUP(C3,{11,"单柱1-1";12,"单柱1-2";13,"单柱1-3";21,"单柱2...