Chotsani Ntchito INDIRECT

01 ya 01

Kupeza Data ndi Ntchito INDIRECT

Ntchito yotchedwa INDIRECT, monga momwe dzina lake ikusonyezera, ingagwiritsidwe ntchito mwachindunji kutanthauzira selo mu kapangidwe kake .

Izi zimachitika polowera selo loloweza mu selo lomwe likuwerengedwa ndi ntchitoyo.

Monga momwe tawonera mu chitsanzo chapamwamba, chiwerengero cha INDIRECT mu selo D2 chimatha kusonyeza deta yomwe ili mu selo B2 - chiwerengero cha 27 - ngakhale kuti sichikutchulidwa mwachindunji kwa selolo.

Momwe izi zimachitikira, mwanjira yowonongeka, ndi:

1. INDIRECT ntchito ili mu selo D2;
2. zizindikiro za selo zomwe zili m'mabwalo oyandikana zimatiuza ntchito yowerenga zomwe zili mu selo A2 - zomwe zili ndi selo lina - B2;
3. ntchitoyo imatha kuwerenga zomwe zili mu selo B2 - kumene zimapeza nambala 27;
4. ntchitoyo ikuwonetsa chiwerengero ichi mu selo D2.

ZOKHUDZA nthawi zambiri zimagwirizanitsidwa ndi ntchito zina, monga OFFSET ndi SUM - mzere 7 wa chitsanzo pamwambapa, kupanga zovuta zambiri.

Kuti izi zitheke, ntchito yachiwiri iyenera kulandira mawonekedwe a selo ngati mtsutsano .

Ntchito yowonjezera ya INDIRECT ndiyo kukulolani kuti musinthe ndime imodzi kapena zingapo za ma selo muyambidwe koma musasinthe ndondomeko yokha.

Ntchito Yowonjezera Syntax ndi Arguments

Mawu omasulira a ntchito amatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabakiteriya, olekanitsa, ndi zifukwa.

Chidule cha INDIRECT ntchito ndi:

= INDIRECT (Ref_text, A1)

Ref_text - (chofunika) Chilumikizo cholondola cha selo (chingakhale chiwonetsero cha ma A1 kapena R1C1) kapena mzere wotchulidwa mzere 6 mu chithunzi pamwambapa pomwe selo A6 lapatsidwa dzina lakuti Alpha;

A1 - (zosankha) Phindu logwirizana (TRUE kapena FALSE yekha) lomwe limatanthawuza kalembedwe ka selo komwe kuli mu Ref_text argument.

• Ngati A1 ndi yoona kapena ayi, Ref_text imamasuliridwa ndi ntchito monga kugwiritsa ntchito njira yowonjezera ya selo la A1-mzere 3 wa chitsanzo pamwambapa;
• Ngati A1 ndi FALSE, Ref_text imamasuliridwa ndi ntchito monga kugwiritsa ntchito njira yosachepera ya selo ya R1C1.

#REF! Zolakwa ndi INDIRECT

INDIRECT idzabwerera #REF! zolakwika ngati ntchito ya Ref_text kukangana:

• silololera selo lolondola - mzere 8 pamwamba;
• lili ndi kutanthauzira kwina kwa bukhu losiyana ndi buku loti sanagwirizane;
• limatanthawuza selo lili kunja kwa pepala la ntchito - kupitirira mzere 1,048,576 kapena ndime XFD.

Kulowa Ntchito YOTSIRIZA

Ngakhale kuti n'zotheka kufalitsa mawonekedwe onse monga

= INDIRECT (A2)

mwapadera mu selo la ntchito, gawo lina ndi kugwiritsa ntchito bokosi la polojekiti ya ntchito kuti alowe kuntchito ndi zifukwa zake monga momwe tafotokozera m'magulu otsatirawa mu selo D2.

1. Dinani pa selo D2 kuti mupange selo yogwira ntchito;
2. Dinani pa Fomu tab ya menyu yowonongeka;
3. Sankhani Kujambula ndi Kutchulidwa kuchokera ku Riboni kuti mutsegule ntchito yolemba pansi;
4. Dinani ku INDIRECT mundandanda kuti mubweretse bokosi lazokambirana
5. Mu bokosi la bokosi, dinani pa Ref_text line;
6. Dinani pa selo A2 patsiku la ntchito kuti mulowetse selolo mu bokosi la bokosi monga Ref_text argument;
7. Dinani OK kuti mutsirize ntchitoyi ndi kutseka bokosi la dialog;
8. Chiwerengero 27 chikuwonekera mu selo D2 chifukwa ndi data yomwe ili mu selo B2
9. Mukasindikiza pa selo D2 ntchito yonse = INDIRECT (A2) ikuwonekera mu barra yazenera pamwamba pa tsamba.