01 ye 01
Kutsvaga Dhiyabhorosi neIndorect Function
Iyo INDIRECT basa, sezvinoreva zita rayo, rinogona kushandiswa kureva zvakananga sero mufomiti yekushandura.
Izvi zvinoitwa nekupinda sechitinho chengero mumusero iyo iri kuverengwa nemabasa.
Sezvinoratidzwa mumuenzaniso uri pamusoro apa, INDIRECT inoshanda muchitokisi D2 inopedzisa kuratidza dhesi iri muchitokisi B2 - nhamba 27 - kunyange isina ine tsanangudzo yakananga kune iyo sero.
Izvi zvinoitika sei, mune imwe nzira yakagadzikana, ndeyokuti:
- iyo INDIRECT basa iri muchitokisi D2;
- iyo tsanangudzo yesero inowanikwa mubheji dzakatenderera inotaurira basa kuti uverenge zviri mukati memusero A2 - iyo ine imwe sero rinoreva - B2;
- basa racho rinoverenga zvinenge zviri muchitokisi B2 - painowana nhamba 27;
- basa racho rinoratidza nhamba iyi muchikamu cheD2.
INDIRECT inowanzobatanidzwa nemamwe mabasa, akadai seO OFFSET uye SUM - mutsara we7 wemuenzaniso wepamusoro, kuti aumbe mazano akaoma.
Kuti izvi zvibate, basa rechipiri rinofanira kubvuma seferensi yekuita sepikisano .
Shanduro imwe chete ye INDIRECT ndeyokukubvumira kuti uchinje rimwe kana kupfuura mamwe masero ezvinyorwa mune chirevo kunze kwekufanirwa kushandura chimiro chairo pachako.
Icho CHIMWE CHINO KUSHANDISA Syntax uye Arguments
Mutsara webasa unoreva kurongeka kwebasa racho uye rinosanganisira zita rebasa, mabheji, vatengesi vemavara, uye nharo.
Mutsara weIndIRECT basa ndewokuti:
= INDIRECT (Ref_text, A1)
Ref_text - (inotarisirwa) Inofanirwa kushandiswa seyero (inogona kuva yeA1 kana R1C1 style reference) kana inonzi yakarongedza -mutsara 6 mumufananidzo pamusoro apa apo cell A6 yakapiwa zita rokuti Alpha;
A1 - (zvichida) Nhamba inonzwisisika (TRUE kana FALSE chete) iyo inotsanangura kuti ndeapi marongerwo emasero ari mune Ref_text argument.
- Kana A1 iri CHOKWADI kana isingabvumirwi, Ref_text inodudzirwa nemabasa sekushandisa sowanowanzoitwa A1-style cell reference - rutsara 3 rwemuenzaniso uri pamusoro;
- Kana A1 iri FALSE, Ref_text inodudzirwa nemabasa sekushandisa shanduro isiri iyo ya1C1-style cell reference.
#REF! Zvikanganiso uye INDIRECT
INDIRECT ichadzoka #REF! kukanganisa kunokosha kana basa re Ref_text argument:
- haisi yakakodzera sero reference - mutsara 8 pamusoro;
- rine chinyorwa chekunze kune rimwe bhuku rebhuku uye kuti bhuku rebhuku harisi rakazaruka;
- inoreva sero iri kunze kwebasa rechikoro - kupfuura mutsara 1,048,576 kana korome XFD.
Kupinda muYOMIRECT Basa
Kunyange zvazvo zvichikwanisika kunyora zvose zvakasarudzwa zvakadai se
= INDIRECT (A2)
zvinyorwa muchiganda chebasa rekushanda, imwe nzira ndeyokushandisa sarudzo yebhokisi rebasa kuti uise basa uye mazano aro sezvinotsanangurwa mumatanho ari pasi apa muchitokisi D2.
- Dzvanya pane cell D2 kuti iite iyo inoshandiswa seki;
- Dzvanya paMafomu tab yebhoni yebhoni ;
- Sarudza Kuona uye Kutarisa kubva kubhoni kuti uzarure basa rinoderedza pasi;
- Dzvanya ku INDIRECT mune urongwa kuti ubudise bhokisi rebasa rebasa
- Mubhokisi rebhokisi, tora pa Ref_text line;
- Dzvanya pane sero A2 mune pepa rekushandisa kuti uise seferensi yesero mubhokisi rebhokisi seRef_text argument;
- Dzvanya OK kuti upedze basa uye uvhare bhokisi rebhokisi;
- Nhamba 27 inowanikwa muchitokisi D2 sezvo iri data iri muchitokisi B2
- Paunenge uchibvisa pane cell D2 basa rakakwana = INDIRECT (A2) inowanikwa mubhairi yepamusoro pane pepa pepaji.