英语翻译=IF($A1>10,IF(COLUMN(A1)=1,"大",""),IF(COLUMN(A1)=2,"小","

来源：学生作业帮编辑：神马作文网作业帮分类：综合作业时间：2024/11/19 06:03:44

英语翻译
=IF($A1>10,IF(COLUMN(A1)=1,"大",""),IF(COLUMN(A1)=2,"小",""))
这是数据在A列的情况下
如果数据在K列呢,或者在H列,怎么改

=IF($K1>10,IF(COLUMN(A1)=1,"大",""),IF(COLUMN(A1)=2,"小",""))
=IF($H1>10,IF(COLUMN(A1)=1,"大",""),IF(COLUMN(A1)=2,"小",""))
再问：假如我的数据在H列，公式输进去后怎么都显示大，是否与$K1>10这个环节有关，
再答：数据在H列，就用下面一个公式啊。。

英语翻译=IF($A1>10,IF(COLUMN(A1)=1,"大",""),IF(COLUMN(A1)=2,"小"," F1=IF($A1="","",IF($A1+COLUMN($A1)+5=COLUMN(),COLUMN()-COLUM F1=IF($A1="","",IF($A1-COLUMN(A1)+1=0,COLUMN()-6,"")) 右拉复制公式 =IF(COUNTA($A1:$E1)>=COLUMN(A1),INDEX($A1:$E1,SMALL(IF($A1:$ =IF（A1="","",VLOOKUP（A1,SHEET1!$A$1：$E$10,COLUMN（B1）,FALSE） [=IF(COUNTIF($B:$B,$A1)=0,"",VLOOKUP($A1,$B:$C,COLUMN(A1),)) =IF(ROW(A1)>7,"",INDIRECT("sheet1!A"&ROW(A1)+COLUMN(A1)*7-7) =IF($A1="","",VLOOKUP($A1,Sheet1!$A:$B,COLUMN(B1),FALSE)) excel中:=SUM(IF(MID(A1,COLUMN(A1:E1),1)="a",1,0))怎么解释 excel,函数公式改写 =IF(AND(IF(MOD(COLUMN($C1:H1),2),$A1,$B1)=$C1:H If Target.Column = 1 IF(MONTH(DATE($A$1,$D$1,COLUMN(A1)))=$D$1,DATE($A$1,$D$1,COL