=IF(MOD(ROW()+1,3)=0,INDEX(B:B,ROW()+4)/3,
=IF(MOD(ROW()+1,3)=0,INDEX(B:B,ROW()+4)/3,
=IF(MOD(ROW(),3)=0,"",IF(MOD(ROW(),3)=1,Sheet1!B$1,INDEX(She
IF(MOD(ROW(),3)=0,"",IF(MOD(ROW(),3)=1,Sheet1!A$1,INDEX(Shee
IF(MOD(ROW(),3)=1,a,IF(MOD(ROW(),3)=2,b,""))这个函数怎么解
=IF(MOD(ROW(),3),OFFSET(工资表!$A$1,(MOD(ROW()-1,3)>0)*ROUND(RO
row()-1 =IF(ROW()>SUM(IF($B$2:$B$10=$E$2,1,0))+1,"",INDEX($C
这个公式什么意思=IF(MOD(ROW(),2)=1,A$7,IF(MOD(ROW(),2)=0,INDEX($A:$D
=INDEX(AA!H:H,SMALL(IF(AA!$B$2:$B$2001=$C$3,ROW($2:$2000),4^
excel中 =CHOOSE(MOD(ROW(B4),3)+1,"",B$1,OFFSET(B$1,ROW(B5)/3,
关于=INDEX(D:D,SMALL(IF($B$3:$B$11=$B$15,ROW($B$3:$B$11),65536
=INDEX(A:A,SMALL(IF(ISERROR(FIND("城区",$B$1:$B$6)),4^8,ROW($B
=INDEX($B:$B,SMALL(IF($A$1:$A$17=$D2,ROW($1:$17),4^8),COLUMN