Excel 常用函数操作

=IF(SHEET1!E2="是", CONCATENATE(RIGHT(D2,-1+FIND("_",TEXTJOIN("",TRUE,MID(D2,LEN(D2)-ROW(INDIRECT("1:"&LEN(D2)))+1,1)))), "00 ", SHEET1!D2), "")

=TEXTJOIN("",TRUE,MID(O2,LEN(O2)-ROW(INDIRECT("1:"&LEN(O2)))+1,1)) 字符串反转

=CHAR(64+COLUMN(H3))&ROW(H3)) // 返回单元格位置的字符串 即"H3"

=HYPERLINK(CONCATENATE("#基线!",CHAR(64+COLUMN(E3))&ROW(E3)),IF(ISBLANK(基线!E3), "", 基线!E3)) // 单元格链接

=HYPERLINK(IF(SHEET1!H3="", "", CONCATENATE("#SHEET1!",CHAR(64+COLUMN(H3))&ROW(H3))),IF(ISBLANK(SHEET1!H3), "", SHEET1!H3)) // 单元格链接

=IF(AN2="是", CONCATENATE("AI_TAXI_", E2), "") //字符串拼接

=IF(ISBLANK(基线!E2), "", 基线!E2)