Mahinga TIKI KAUPAPA

01 o 01

Te Rapu Raraunga me te Mahi INDIRECT

Ka taea te whakamahi i te mahi INDIRECT, e ai ki tona ingoa, ki te tohutoro tuhi i tetahi pūtau i roto i te tuhinga mahi .

Ka mahia tenei ma te whakauru i tetahi tohutoro pūtau ki roto i te pūtau e pānuihia ana e te mahi.

Hei whakaatu i te tauira i runga ake nei, ka mutu te mahi INDIRECT i roto i te pūtau D2 whakaatu i te raraunga kei roto i te pūtau B2 - te tau 27 - ahakoa kaore he tohutoro tika ki taua pūtau.

Me pehea tenei, i roto i te huarahi tino pai, ko:

1. Ko te mahi INDIRECT kei roto i te pūtau D2;
2. ko te tohutoro pūtau i roto i nga tohu porohita e whakaatu ana i te mahi ki te pānui i nga ihirangi o te A2 pūtau - kei roto i tetahi atu tohutoro pūtau - B2;
3. ko te mahi ka panui i nga ihirangi o te pūtau B2 - kei hea e kitea ana te tau 27;
4. Ko te mahi e whakaatu ana i tenei tau i roto i te pūtau D2.

Kei te hono tonu a INDIRECT me etahi atu mahi, penei i te OFFSET me te SUM - rarangi 7 o te tauira i runga ake nei, ki te waihanga i nga tauira matatini.

Hei mahi tenei, me whakaae te mahi tuarua ki te tohutoro pūtau hei tautohe .

He whakamahinga noa mo INDIRECT ko te tuku ia koe ki te whakarereke i tetahi korero nui atu ranei i roto i tetahi tahua kaore he whakatika i te ture .

Ko te Syntax Mahi me te Whawhai

Ko te whakahuatanga o te mahi e pa ana ki te whakatakotoranga o te mahi me te whakauru i te ingoa o te mahi, te tohu, te wehewehe me te tohenga.

Ko te whakahuahua mo te mahi INDIRECT ko:

= INDIRECT (Ref_text, A1)

Ref_text - (e hiahiatia ana) Ko te tohutoro pūtau tika (ko te tohutoro kāhua A1 ranei R1C1) ranei he raupapa ingoa - rarangi 6 i te ahua i runga i te wahi i hoatu ai te A6 i te ingoa Alpha;

A1 - (he kōwhiringa) Ko te uara arorau (TRUE ranei FALSE anake) e tohu ana i te ahua o te tohutoro pūtau kei roto i te whakautu Ref_text.

• Mena he A1 he TRUE, kaore ranei, ka whakamaorihia te Ref_text e te mahi hei whakamahi i te tohutoro pūtau A1-noa ake - rarangi 3 o te tauira i runga;
• Mena he A1 ko FALSE, ka whakamaorihia te Ref_text e te mahi hei whakamahi i te tohutoro pūtau R1C1 noa iho.

#REF! Hapa me te INDIRECT

Ka whakahokia e INDIRECT te #REF! he uara hapa ki te whakautu a Ref_text :

• ehara i te tohutoro pūtau tika - rarangi 8 i runga;
• Kei roto he tohutoro waho ki tetahi pukamahi rereke, a, kaore i tuwhera te pukamahi;
• e pa ana ki te awhe waea i waho atu o te tuhinga mahi - i tua atu o te rarangi 1,048,576 te tīwae XFD rānei.

Te whakauru i te Mahi INDIRECT

Ahakoa ka taea te tuhi i te tauira katoa penei

= INDIRECT (A2)

me te ringa ki roto i te pukupuku mahi, ko tetahi atu waahanga ko te whakamahi i te pouaka korero a te mahi hei whakauru i te mahi me ana tautohetohe ano i tautuhia i nga taahiraa i raro nei ki te pūtau D2.

1. Patohia te D2 ki te hanga i te rorohiko kaha;
2. Patohia te ripa Whakaraupapa o te tahua ripapa;
3. Kōwhiritia te Tirohanga me te Tohutoro mai i te ripa hei whakatuwhera i te rārangi maturuturu o te taumahi;
4. Pawhiria te INDIRECT i roto i te rarangi hei kawe ake i te pouaka korero a te mahi
5. I roto i te pouaka korero, pa ki te raina Ref_text ;
6. Patohia te A2 i roto i te pukamahi hei whakauru i te tohutoro pūtau ki te pouaka korero hei whakautu Ref_text ;
7. Pāwhiritia OK hei whakaoti i te mahi me te kati i te pouaka korero;
8. Ko te tau 27 e puta mai ana i roto i te D2 pūtau no te mea ko te raraunga i roto i te pūtau B2
9. Ina pahia e koe i runga i te taiao D2 te mahi oti = INDIRECT (A2) i roto i te paerewa ture i runga i te pepa mahi.