ref_textæ¯è¡¨ç¤ºå¼ç¨çå符串ï¼å¦A1ï¼A1:B10ç
=indirect("A1")ä¸=A1çä»·ã
åç
indirect("A1:B10")ç¸å½äºå¼ç¨A1:B10åºåã
ç±äºå¼ç¨ä¸çå符串ä¸è½éæ·»å æå é¤è¡åèèªå¨æ¹åï¼å æ¤ä¹æ人称ä¹ä¸ºç»å¯¹ä¹ç»å¯¹å¼ç¨ã
al为indirectå½æ°çå¯éåæ°ï¼æ两个åå¼èå´ï¼0æ1ï¼å¨çç¥æ¶åé»è®¤å¼1ï¼å³A1å¼ç¨ï¼å½a1å0æ¶ï¼å¼ç¨å为R1C1å¼ç¨ã
å¦indirect("R1C2",0)表示ä»ç¬¬1è¡ç¬¬2åçåå
æ ¼ï¼å³B1åå
æ ¼ã
indirect("RC3",0)表示å¼ç¨å½ååå
æ ¼æå¨è¡ï¼ç¬¬3åçåå
æ ¼ã
indirect("R2C",0)表示å¼ç¨ç¬¬2è¡ï¼å½ååå
æ ¼æå¨åçåå
æ ¼ã
INDIRECT("R[3]C[4]",0)表示å¼ç¨å½ååå
æ ¼åä¸3è¡ï¼åå³4åçåå
æ ¼ï¼å¦æå½ååå
æ ¼ä¸ºC2ï¼åå¼ç¨ç为G5åå
æ ¼ã
indirect("R1C1:R2C3",0)ï¼å¼ç¨ç为A1:C2åºå
温馨提示:答案为网友推荐,仅供参考