=INDIRECT(CONCATENATE("Sheet2!","R",(ROW()-3)/24+2,"C",2),FA
来源:学生作业帮 编辑:搜搜考试网作业帮 分类:综合作业 时间:2024/06/05 16:08:01
=INDIRECT(CONCATENATE("Sheet2!","R",(ROW()-3)/24+2,"C",2),FALSE) 上面各个符号代表是什么意思呢?
INDIRECT函数返回由文本字符串指定的引用.
CONCATENATE函数将几个文本字符串合并为一个文本字符串.
ROW()函数返回引用的行号.
"Sheet2!","R",(ROW()-3)/24+2,"C",2可简化为"Sheet2!R",(ROW()-3)/24+2,"C2“
每24行引用B列B3开始的数据,可改为:
=INDIRECT("Sheet2!B"&INT((ROW()-3)/24+2))
CONCATENATE函数将几个文本字符串合并为一个文本字符串.
ROW()函数返回引用的行号.
"Sheet2!","R",(ROW()-3)/24+2,"C",2可简化为"Sheet2!R",(ROW()-3)/24+2,"C2“
每24行引用B列B3开始的数据,可改为:
=INDIRECT("Sheet2!B"&INT((ROW()-3)/24+2))
=INDIRECT(CONCATENATE("Sheet2!","R",(ROW()-3)/24+2,"C",2),FA
求解释在excel中,函数:=INDIRECT("sheet2!A"&((ROW(Sheet2!A2)-2)*20+(C
=SUMPRODUCT(SUMIF(INDIRECT(ROW($1:$2)&"!C:C"),$C5,INDIRECT(R
谁能看懂这个函数公式吗?=INDIRECT(CONCATENATE("汇总表!B",1+ROW()*3),TRUE)
INDIRECT(CONCATENATE("常数!d",($B$2+2))
请问EXCEL中“=INDIRECT(CONCATENATE("Sheet2!",ADDRESS((B6-TRUNC(B
=INDIRECT("a"&2*ROW()-1)&INDIRECT("a"&2*ROW())求详解,改能里关系到文字位置
=IF(N2="","",OFFSET(INDIRECT($R$1),ROW()-2,COLUMN()-14))
EXCEL 公式:=INDIRECT("sheet2!"&ADDRESS(ROW(A1),(COLUMN(A1)-1)*
忘了问你了,=indirect("sheet2!C"&(row(a1)-1)*31+4)这个公式中,a1代表什么呢?
请一下,您的公式里面=INDIRECT(ADDRESS((ROW(A1)-1)/3+2,MOD(ROW(A1)-1,3)
=OFFSET(Sheet2!$M$2,(ROW(Q1)-1)/2,MOD(ROW(Q1)-1,2))