I-Excel INDIRECT Umsebenzi

01 ka 01

Ukuthola Idatha nge-INDIRECT Umsebenzi

Umsebenzi we-INDIRECT, njengoba igama lawo uphakamisa, ungasetshenziswa ukubhekisela ngokungaqondile iseli kufomula lokusebenzela .

Lokhu kwenziwa ngokufaka ireferensi yeseli esitokisini esifundwa ngumsebenzi.

Njengoba kuboniswe kusibonelo esingenhla, umsebenzi we-INDIRECT esitokisini se-D2 uphela ukubonisa idatha esesitokisini B2 - inombolo engu-27 - nakuba ingenakho ukubhekisela okuqondile kulolo seli.

Kwenzeka kanjani lokhu, ngandlela-thile ekhohlisiwe, yi:

1. umsebenzi we-INDIRECT usekliniki D2;
2. ireferensi yeseli equkethwe kubakaki abajikelezayo isitshela umsebenzi wokufunda okuqukethwe kweseli A2 - equkethe enye ireferensi yeseli - B2;
3. lo msebenzi ufunda okuqukethwe kweseli B2 - lapho ithola inombolo 27;
4. umsebenzi ubonisa le nombolo kuseli D2.

I-INDIRECT ivame ukuhlanganiswa neminye imisebenzi, njenge- OFFSET ne- SUM - irowu 7 yesibonelo esingenhla, ukudala amafomula adidayo.

Ukuze lokhu kusebenze, umsebenzi wesibili kufanele wamukele isithenjwa sefoni njengokungqubuzana.

Ukusetshenziswa okuvamile kwe-INDIRECT ukukuvumela ukuthi ushintshe okukodwa noma okungaphezulu kwezingqamuzana zefomula kwifomula ngaphandle kokuthi uhlele ifomula ngokwayo.

Umsebenzi we-INDIRECT Syntax ne-Arguments

I- syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi, amabakaki, ukwahlukanisa kwama-comma, nokuphikisana.

I-syntax yomsebenzi we-INDIRECT yile:

= INDIRECT (Ref_text, A1)

I-ref_text - (edingekayo) I-reference yeselula evumelekile (ingaba isitayela se-A1 noma i-R1C1 isitayela) noma uhla olubizwa ngokuthi ulayini 6 emfanekisweni ngenhla lapho iseli A6 linikezwe igama elithi Alpha;

I-A1 - (ngokuzithandela) Inani elilinganiselwe (TRUE noma FALSE kuphela) elichaza ukuthi yisiphi isitayela sesithenjwa sefoni esitholakala ku-Ref_text argument.

• Uma i-A1 ingu-TRUE noma ingashiywanga, i-Ref_text ihunyushwa ngomsebenzi njengokusebenzisa ireferensi yeseli yesitayela ejwayelekile ye-A1 - irowu 3 yesibonelo esingenhla;
• Uma i-A1 i-FALSE, i-Ref_text ihunyushwa ngomsebenzi njengokusebenzisa ireferensi yeselula ye-R1C1 yesitayela.

#REF! Amaphutha kanye ne-INDIRECT

INDIRECT izobuya i- #REF! iphutha lenani uma i-argument Ref_text yomsebenzi :

• akuyona inkomba yeseli evumelekile - irowu 8 ngenhla;
• iqukethe ukubhekisela kwangaphandle kwencwadi ehlukile futhi leyo ncwadi yokusebenzela ayivulekile;
• ibhekisela ebangeni leseli ngaphandle kwephepha lokusebenzela - ngaphesheya komugqa we-1,048,576 noma ikholomu XFD.

Ukufaka umsebenzi we-INDIRECT

Nakuba kungenzeka ukuthayipha yonke ifomula njenge

= INDIRECT (A2)

ngesandla besebenzisa iseli lokusebenzela, enye indlela ukusebenzisa ibhokisi lengxoxo yomsebenzi ukufaka umsebenzi kanye nezimpikiswano zalo njengoba kuboniswe ezinyathelweni ezingezansi kwiseli D2.

1. Chofoza kuseli D2 ukuze wenze iseli elisebenzayo;
2. Chofoza kuthebhu yefomula yemenyu ye- Ribbon ;
3. Khetha ukuLondoloza kanye neNkhombandlela kusuka kubhebhoni ukuvula uhlu lwehla lokusebenza;
4. Chofoza ku- INDIRECT ohlwini ukuze ulethe ibhokisi lengxoxo lomsebenzi
5. Ebhokisini lengxoxo, chofoza ku- Ref_text line;
6. Chofoza ku-cell A2 ekhasini lokusebenzela ukuze ufake ireferensi yeseli ebhokisini lebhokisi njenge- Ref_text argument;
7. Chofoza OK ukuze uqedele umsebenzi bese uvala ibhokisi lengxoxo;
8. Inombolo 27 ivela esitokisini D2 ngoba idatha ekhona esitokisini B2
9. Uma uchofoza ku-cell D2 umsebenzi ophelele = INDIRECT (A2) ibonakala kwibha yefomula ngaphezulu kwephepha lokusebenzela.