这个公式有什么错误!=IF(C3=11,"单柱1-1",IF(C3=12,"单柱1-2",IF(C3=13,"单柱1-3

问题描述:

这个公式有什么错误!
=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,"附着标志"))))))))))))))))))))
1个回答 分类:综合 2014-10-09

问题解答:

我来补答
你是用03版的EXCEL吧,在这个版本中函数只能嵌套7层,你用的IF函数层数太多了,所以出错(07以上版本你这个IF公式还是可以用的)
公式改成如下
=IF(C3="","",VLOOKUP(C3,{11,"单柱1-1";12,"单柱1-2";13,"单柱1-3";21,"单柱2-1";31,"单柱3-1";41,"单柱4-1";42,"单柱4-2";211,"双柱1-1";212,"双柱1-2";213,"双柱1-3";214,"双柱1-4";221,"双柱2-1";222,"双柱2-2";231,"双柱3-1";711,"悬臂柱1-1";712,"悬臂柱1-2";713,"悬臂柱1-3";721,"悬臂柱2-1";722,"悬臂柱2-2";0,"附着标志"},2,))
 
 
展开全文阅读
剩余:2000
下一页:数学函数值域