Pochita zowerengera zina zofunika kuti mupeze kuchuluka kwa ntchito. Kuwerengera kotereku kumachitidwa ndi owerengetsa, osunganiza, okonza mapulani, ophunzira a magulu a maphunziro. Mwachitsanzo, njira iyi yowerengera ikufunika kuti mudziwe zambiri pa malipiro a masiku ogwira ntchito. Kuchita izi kungakhale kofunikira m'mafakitale ena, komanso ngakhale kufunikira kwa pakhomo. Tiyeni tione momwe mu Excel mungathe kuwerengera kuchuluka kwa ntchito.
Kuwerengera kuchuluka kwa ntchito
Kuchokera pa dzina lomwelo likuwonekeratu kuti chiwerengero cha ntchito ndifupikitsa za zotsatira za kuchulukitsa manambala. Mu Excel, izi zikhoza kuchitidwa pogwiritsira ntchito njira yosavuta ya masamu kapena kugwiritsa ntchito ntchito yapadera. SUMPRODUCT. Tiyeni tiwone njira izi mwatsatanetsatane.
Njira 1: Gwiritsani ntchito masamu
Ambiri ogwiritsira ntchito amadziwa kuti mu Excel mungathe kuchita zambiri mwa masamu pamasom'pamaso poika chizindikiro "=" mu selo yopanda kanthu, ndiyeno kulemba mawu molingana ndi malamulo a masamu. Njira iyi ingagwiritsidwe ntchito kupeza mndandanda wa ntchito. Pulogalamuyo, malinga ndi malamulo a masamu, nthawi yomweyo amawerengera ntchitozo, ndipo pokhapokha amawonjezera ndalamazo.
- Ikani chizindikiro chofanana (=) mu selo momwe zotsatira za ziwerengero zidzawonetsedwa. Timalembera pamenepo mafotokozedwe a chiwerengero cha ntchito malinga ndi template yotsatirayi:
= a1 * b1 * ... + a2 * b2 * ... + a3 * b3 * ... + ...Mwachitsanzo, mwa njira iyi mukhoza kuwerengera mawu awa:
=54*45+15*265+47*12+69*78 - Kuti muwerenge ndi kusonyeza zotsatira zake pawindo, dinani pa Enter lokosi pa makiyi.
Njira 2: ntchito ndi maulumikizi
Mmalo mwa nambala yeniyeni mu dongosolo ili, mukhoza kufotokoza maulumikilo kwa maselo omwe ali. Malumikizowo angalowetsedwe pamanja, koma ndizovuta kuchita izi powonekera pambuyo pa chizindikiro "=", "+" kapena "*" selo lofanana lokhala nalo nambala.
- Kotero, nthawi yomweyo timalemba mawu, kumene m'malo mwa manambala mafotokozedwe a maselo amasonyezedwa.
- Ndiye, kuti muchite mawerengedwe, dinani pa batani Lowani. Zotsatira za chiwerengero zidzawonetsedwa pawindo.
Zoonadi, mawerengedwe awa ndi osavuta komanso ovuta, koma ngati tebulo ili ndi mfundo zambiri zomwe ziyenera kuwonjezeka ndikuwonjezeredwa, njira iyi ikhoza kutenga nthawi yayitali.
Phunziro: Gwiritsani ntchito mayina mu Excel
Njira 3: Kugwiritsa ntchito SUMPRODUCT ntchito
Kuti awerenge ndalama zonsezi, ena amagwiritsa ntchito ntchito yomwe yapangidwa kuti ichitikepo - SUMPRODUCT.
Dzina la woyendetsa makinawa amalankhula za cholinga chake paokha. Kupindula kwa njira iyi kuposa imodzi yapitayi ndikuti ingagwiritsidwe ntchito pokonza zida zonse panthawi imodzi, komanso kuti musachite zochita ndi nambala iliyonse kapena selo limodzi.
Chidule cha ntchitoyi ndi ichi:
= SUMPRODUCT (array1; array2; ...)
Mikangano ya woyendetsa izi ndi mitsinje ya deta. Panthawi imodzimodziyo amagawidwa ndi magulu a zinthu. Izi ndizo, ngati tiyambira pa chitsanzo chomwe tinkakambirana pamwambapa (a1 * b1 * ... + a2 * b2 * ... + a3 * b3 * ... + ...), ndiye poyambirira ndi zifukwa za gululo amuchiwiri - gulu bmu gulu lachitatu c ndi zina zotero Mipata iyi iyenera kukhala yofanana ndi yofanana m'litali. Iwo akhoza kuikidwa onse awiri molunjika ndi mopingasa. Zonsezi, wogwiritsira ntchitowa akhoza kugwira ntchito ndi chiwerengero cha zotsutsana kuyambira 2 mpaka 255.
Mchitidwe SUMPRODUCT Mukhoza kulembera kalata ku selo kuti muwonetse zotsatira, koma ogwiritsa ntchito ambiri amaziwona kuti ndi zophweka komanso zosavuta kupanga mawerengero kupyolera mu Wopanga Ntchito.
- Sankhani selo pa pepala momwe zotsatira zake zidzasonyezedwe. Timakanikiza batani "Ikani ntchito". Imalembedwa ngati chithunzi ndipo ili kumanzere kwa munda wamatabwa.
- Mutagwiritsa ntchito izi, muthamangitse Mlaliki Wachipangizo. Amatsegula mndandanda wa onse ogwira ntchito, ndi zochepa zochepa, omwe mungathe kugwira nawo ntchito ku Excel. Kuti tipeze ntchito yomwe tikufunikira, pitani ku gululo "Masamu" kapena "Mndandanda wathunthu wa alfabeti". Atapeza dzina "SUMMPROIZV"sankhani ndipo dinani pa batani "Chabwino".
- Ntchito yotsutsana zenera ikuyamba. SUMPRODUCT. Mwa chiwerengero cha zifukwa, izo zingakhale ndi minda 2 mpaka 255. Maadiresi a Band angayendetsedwe mwadongosolo. Koma zidzatenga nthawi yochuluka. Inu mukhoza kuchita chinachake chosiyana. Ikani cholozeracho kumunda woyamba ndikusankha mndandanda wa kutsutsana koyamba pa pepala pamene mukugwira batani lamanzere. Timachita chimodzimodzi ndi mndandanda wachiwiri ndi zonse zomwe zikutsatira, zomwe zikuwonetseratu nthawi yomweyo. Deta yonse italowa, dinani pa batani "Chabwino" pansi pazenera.
- Zitatha izi, pulogalamuyo idzachita zowerengera zonse zofunikira ndikuwonetsa zotsatira zomaliza mu selo yomwe yasankhidwa mu ndime yoyamba ya chiphunzitso ichi.
Phunziro: Wowonjezera Wogwira Ntchito
Njira 4: Gwiritsani ntchito ntchitoyi
Ntchito SUMPRODUCT chabwino ndi chakuti icho chingagwiritsidwe ntchito ndi chikhalidwe. Tiyeni tione momwe izi zakhalira ndi chitsanzo cha konkire.
Tili ndi tebulo la malipiro ndi masiku ogwira ntchito ogwirira ntchito kwa miyezi itatu mwezi uliwonse. Tiyenera kudziwa m'mene Parfenov DF wogwirira ntchito adachitira panthawiyi.
- Mofanana ndi nthawi yapitayi, timayitana ndondomeko yotsutsana SUMPRODUCT. M'madera awiri oyambirira, timasonyeza kuti ndizomwe zimagwiritsidwa ntchito, malinga, momwe malire a antchito ndi chiwerengero cha masiku omwe akugwira ntchito akuwonetsedwa. Izi ndizo, timachita zonse monga momwe zinalili kale. Koma mu gawo lachitatu timayika ndondomeko ya mndandanda, womwe uli ndi mayina a ogwira ntchito. Pambuyo pa adiresi yomwe tikuwonjezera kulowera:
= "Parfenov D.F."Deta yonse italowa, dinani batani "Chabwino".
- Kugwiritsa ntchito kumachita mawerengedwe. Mizere yokha ndi dzina imatengedwa "Parfenov D.F.", ndicho chimene tikusowa. Chotsatira cha kuwerengetsera chikuwonetsedwa mu selo yoyamba yosankhidwa. Koma zotsatira zake ndi zero. Ichi ndi chifukwa chakuti mawonekedwe omwe ali nawo tsopano sakugwira ntchito molondola. Tiyenera kusintha izo pang'ono.
- Kuti mutembenuze mawonekedwe, sankhani selo ndi mtengo wake wonse. Chitani zotsatira mu bar. Kutsutsana ndi chikhalidwe kumatengedwa mu mabakia, ndipo pakati pa izo ndi zifukwa zina timasintha timagulu ndi chizindikiro chochulukitsa (*). Timakanikiza batani Lowani. Pulogalamuyi imapanga mawerengedwe ndipo nthawi ino imapereka mtengo woyenera. Tinalandira malipiro okwanira kwa miyezi itatu, chifukwa cha Parfenov D.F.
Mofananamo, zikhalidwe zingagwiritsidwe ntchito osati m'malemba okha, komanso kwa manambala ndi masiku, kuwonjezera chizindikiro "<", ">", "=", "".
Monga mukuonera, pali njira zazikulu ziwiri zowerengera ndalama za ntchito. Ngati palibe deta yochulukirapo, ndiye kosavuta kugwiritsa ntchito njira yosavuta ya masamu. Pamene nambala yambiri ikuphatikizidwa, wogwiritsa ntchitoyo adzapulumutsa kuchuluka kwa nthawi ndi mphamvu yake ngati atagwiritsa ntchito mwayi wa ntchito yapadera. SUMPRODUCT. Kuonjezerapo, pogwiritsira ntchito njira imodzimodziyo, n'zotheka kuchita mawerengedwe pamtundu umene mawonekedwe a nthawi zonse sangathe kuchita.
