这个公式有什么错误!=IF(C3=11,"单柱1-1",IF(C3=12,"单柱1-2",IF(C3=13,"单柱1-3
来源:学生作业帮 编辑:大师作文网作业帮 分类:综合作业 时间:2024/09/22 17:33:23
这个公式有什么错误!
=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-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,))
公式改成如下
=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,))
这个公式有什么错误!=IF(C3=11,"单柱1-1",IF(C3=12,"单柱1-2",IF(C3=13,"单柱1-3
=IF(C3="","",VLOOKUP(C3,编码!$A$1:$B$10,2,FALSE)) 这个Excel表格公式是
excel中 =IF(C3>8,C3/2,C3*2),,c3=6 怎么算?
=IF(LEN(B3)=4,C3MID(C3,1,FIND("/",C3)-1))"这个公式是什么意思麻烦高手帮我讲解一
各位大虾,如下公式:LARGE (($C$1:$C3=C3)*ROW ($C$1:$C3), 2).看不懂什么意思,麻烦
Execl 公式=if(OR(C2=0.5*(C3+D3),C2=0.5*(C3+E3),C2=0.5*(C3+F3),
=IF(F3>=100%,C3*8,IF(F3>=90%,C3*10,IF(F3>=80%,C3*12,IF(F3>=7
=$D$1&B3&C3 这个公式是什么意思
请教这个公式的使用方法=IF(C3="","",IF(B3="",TEXT(NOW(),"yyyy-m-d"),B3))
再C3:C77之间要统计人数,用公式=SUM(IF(C$3:C$77>0,1,0)),可以计算
3.若有以下程序段,int c1=1,c2=2,c3; c3=1.0/c2*c1 则执行后,c3中的值是
哪位高手帮忙解释函数=IF(ISERR(SUMIF(C3:C160,">0")/COUNTIF(C3:C160,">0"