Mu phunziro ili, tidziwa mawonekedwe amitundu yambiri, kusanthula chitsanzo chabwino cha momwe amagwiritsidwira ntchito mu Excel, ndikuwonanso zina zomwe zimagwiritsidwa ntchito. Ngati simukudziwa zamitundu yosiyanasiyana, tikukulimbikitsani kuti mutembenuzire phunzirolo, lomwe limafotokoza mfundo zazikuluzikulu zogwirira nawo ntchito.
Kugwiritsa ntchito ma multicell array formula
Chithunzi chomwe chili pansipa chikuwonetsa tebulo lomwe lili ndi dzina la mankhwala, mtengo wake ndi kuchuluka kwake. Maselo D2:D6 amawerengera mtengo wonse wamtundu uliwonse wa mankhwala (poganizira kuchuluka kwake).
Mu chitsanzo ichi, mitundu D2: D6 ili ndi njira zisanu. Fomula yama cell angapo imakupatsani mwayi wowerengera zotsatira zomwezo pogwiritsa ntchito fomula imodzi. Kuti mugwiritse ntchito array formula, tsatirani izi:
- Sankhani magulu osiyanasiyana omwe mukufuna kuwonetsa zotsatira. Kwa ife, ichi ndi mtundu wa D2:D6.
- Monga ndi fomula iliyonse mu Excel, gawo loyamba ndikulowetsa chizindikiro chofanana.
- Sankhani mndandanda woyamba wamtengo. Kwa ife, izi ndizosiyana ndi mitengo ya zinthu B2:B6.
- Lowetsani chizindikiro chochulukitsa ndikuchotsa mndandanda wachiwiri wamakhalidwe. Kwa ife, izi ndizosiyana ndi kuchuluka kwa zinthu C2:C6.
- Ngati tikanati tilowetse fomu yokhazikika mu Excel, tingathe kumaliza kulowetsako mwa kukanikiza kiyi Lowani. Koma popeza iyi ndi njira yotsatsira, muyenera kukanikiza kuphatikiza kiyi Ctrl + Shift + Lowani. Izi zidzauza Excel kuti iyi si njira yokhazikika, koma njira yotsatsira, ndipo imangoyitsekera muzitsulo zopindika.
Excel imadzitsekera yokha fomula yosakanikirana muzitsulo zopindika. Mukayika mabulaketi pamanja, Excel idzatanthauzira mawuwa ngati mawu osavuta.
- Dziwani kuti ma cell onse mumtundu wa D2:D6 ali ndi mawu ofanana ndendende. Zingwe zopindika kuzungulira izo zimasonyeza kuti ndi ndondomeko yotsatizana.
- Ngati titasankha kachulukidwe kakang'ono polowetsa masanjidwe, mwachitsanzo, D2:D4, ndiye kuti ingobweretsa zotsatira zitatu zoyambirira kwa ife:
- Ndipo ngati kuchuluka kwake kuli kokulirapo, ndiye kuti m'maselo "owonjezera" padzakhala mtengo # N / A (palibe data):
Tikachulukitsa gulu loyamba ndi lachiwiri, zinthu zawo zimachulukitsidwa (B2 ndi C2, B3 ndi C3, B4 ndi C4, ndi zina). Zotsatira zake, mndandanda watsopano umapangidwa, womwe uli ndi zotsatira za mawerengedwe. Chifukwa chake, kuti mupeze zotsatira zolondola, miyeso yamagulu onse atatu iyenera kufanana.
Ubwino wa ma fomula amitundu yambiri
Nthawi zambiri, kugwiritsa ntchito fomula imodzi yama cell angapo mu Excel ndikwabwino kugwiritsa ntchito mitundu ingapo. Ganizirani zabwino zomwe limapereka:
- Pogwiritsa ntchito fomula yama cell angapo, muli otsimikiza 100% kuti mafomula onse omwe amawerengeredwa adalowetsedwa bwino.
- Njirayi imatetezedwa kwambiri kuti isasinthe mwangozi, chifukwa gulu lonse lonse likhoza kusinthidwa. Ngati mutayesa kusintha gawo la gululo, mudzalephera. Mwachitsanzo, ngati muyesa kuchotsa fomula mu cell D4, Excel ipereka chenjezo ili:
- Simungathe kuyika mizere kapena mizati yatsopano mumtundu womwe fomula yanu yayikidwa. Kuti muyike mzere watsopano kapena mzere watsopano, muyenera kutanthauziranso gulu lonselo. Mfundo imeneyi tingaione ngati yabwino komanso yoipa.
Chifukwa chake, muphunziro ili, mwadziwa ma fomula amitundu yambiri ndikusanthula chitsanzo chaching'ono. Ngati mukufuna kuphunzira zambiri za masanjidwe mu Excel, werengani nkhani zotsatirazi:
- Chiyambi cha mafomula osiyanasiyana mu Excel
- Mafomu amtundu wa cell mu Excel
- Mndandanda wa zosinthika mu Excel
- Kusintha mitundu yosiyanasiyana mu Excel
- Kugwiritsa ntchito mitundu yosiyanasiyana mu Excel
- Njira zosinthira masanjidwe amitundu mu Excel