01 na 01
Gano Bayanai tare da Ayyukan INDIRECT
Ayyukan INDIRECT, kamar yadda sunansa ya nuna, ana iya amfani dashi a cikin hanyar da aka ba da hankali akan tantanin halitta a cikin takaddun aiki .
Anyi wannan ta hanyar shigar da tantanin halitta a tantanin salula wanda ake karantawa ta hanyar aikin.
Kamar yadda aka nuna a misalin da ke sama, aikin INDIRECT a cikin cell D2 ya ƙare yana nuna bayanan da aka samo cikin tantanin halitta B2 - lambar 27 - ko da shike bai ƙunshi bayanin kai tsaye zuwa wannan tantanin halitta ba.
Ta yaya wannan yake faruwa, a cikin hanyar da aka yi da hankali, shine:
- aikin INDIRECT yana cikin cell D2;
- bayanan salula wanda ke ƙunshe a cikin kwakwalwan zagaye ya gaya wa aikin don karanta abubuwan da ke ciki na cell A2 - wanda ya ƙunshi wani tunani na sel - B2;
- aikin sannan karanta abinda ke ciki na cell B2 - inda ya sami lamba 27;
- aikin yana nuna wannan lambar a cikin cell D2.
INDIRECT yana haɗuwa tare da sauran ayyuka, irin su OFFSET da SUM - jere 7 na misalin da ke sama, don ƙirƙirar ƙididdiga masu mahimmanci.
Don wannan don aiki, aikin na biyu dole ne yarda da tantanin halitta tantance gardama .
Amfani da ita don INDIRECT shi ne ya bar ka canza sau ɗaya ko fiye da sassan yanar gizo a cikin wata mahimmanci ba tare da gyara tsarin da kanta ba.
Harkokin aikin INDIRECT da Arguments
Haɗin aikin aiki yana nufin layout na aikin kuma ya haɗa da sunan aiki, shafuka, rabuɗɗun takaddama, da muhawara.
Haɗin aikin aikin INDIRECT shine:
= INDIRECT (Ref_text, A1)
Ref_text - (da ake buƙata) Tsararren ƙwayoyin salula (iya zama maƙalar A1 ko R1C1) ko mai lakabi mai suna - jere 6 a cikin hoto a sama inda aka ba da A6 sunan Alpha;
A1 - (zaɓuɓɓuka) Ainihin mahimmanci (TRUE ko FALSE kawai) wanda ya ƙayyade abin da salon salon tunani na sel ya ƙunshi cikin Ref_text argument.
- Idan A1 yana TRUE ko kuma an cire, Ref_text an fassara shi ta hanyar aiki kamar yadda ake amfani da mahimmancin salon salon salon A1 na yau da kullum - jere 3 na misali a sama;
- Idan A1 shine FALSE, ana fassara ma'anar Ref_text ta aikin ta amfani da mahimmancin salon salon R1C1 mai ƙaranci.
#ref! Kurakurai da INDIRECT
INDIRECT zai dawo da #REF! kuskure kuskure idan aikin aikin Ref_text argument:
- ba hanyar tantancewar salula ba ne - jere 8 sama;
- ya ƙunshi bayanin waje game da wani takardun littafi daban-daban kuma wannan littafin aikin bai bude ba;
- yana nufin wani ɗakin halitta a waje na takardun aiki - fiye da layin 1,048,576 ko shafi na XFD.
Shigar da aikin INDIRECT
Kodayake yana yiwuwa a rubuta dukkan tsari kamar
= INDIRECT (A2)
da hannu a cikin wani saitunan aikin aiki, wani zaɓi shine don amfani da maganganun maganganun don shigar da aikin da jayayya kamar yadda aka tsara a cikin matakan da ke ƙasa zuwa cikin tantanin halitta D2.
- Danna kan tantanin halitta D2 don sa shi tantanin halitta;
- Danna maɓallin Formulas na shafin ribbon ;
- Zabi Duba da kuma Magana daga ribbon don buɗe jerin aikin sauke aikin;
- Danna INDIRECT a jerin don kawo akwatin maganganun aikin
- A cikin akwatin maganganu, danna kan Ref_text line;
- Danna kan salula A2 a cikin takardar aiki don shigar da tantanin halitta a cikin akwatin maganganun a matsayin Ref_text argument;
- Danna Ya yi don kammala aikin kuma rufe akwatin maganganu;
- Lambar mai lamba 27 ya bayyana a cell D2 tun lokacin da aka samo bayanan dake cikin tantanin halitta B2
- Lokacin da ka danna kan tantanin halitta D2 cikakkiyar aikin = INDIRECT (A2) ya bayyana a cikin maɓallin tsari a sama da takardun aiki.