01 ngo 01
I-Excel INKQUBO YOMSEBENZI
Ubunzima obunzima nxamnye nomlinganiselo ongapheliyo
Ngokuqhelekileyo, xa kuthela i-average or arithmetic ithetha, inamba nganye inenani elilinganayo okanye ubunzima.
Umyinge ubalwa ngokudibanisa uluhlu lweenombolo kunye kunye nokuhlula inani lexabiso lemali kwibala .
Umzekelo uya kuba (2 + 3 + 4 + 5 + 6) / 5 enika umlinganiselo ongaphelelanga we-4.
Kwi-Excel, ezo zibalo zenziwa ngokulula usebenzisa umsebenzi WENKQUBO .
Umlinganiselo olinganisiweyo, ngakolunye uhlangothi, ucinga enye okanye amaninzi manani kwibala elifanelekileyo, okanye abe nobunzima obukhulu kunamanye amanani.
Ngokomzekelo, amanqaku athile esikolweni, njengemizuzu yokugqibela kunye nokuhlolwa kokugqibela, ngokuqhelekileyo anelungelo elingaphezu kweemvavanyo eziqhelekileyo okanye izabelo.
Ukuba ukulinganisa kusetyenziswa ukubala ukugqibela kwamanqaku okugqibela kunye nomviwo wokugqibela uza kunikwa ubunzima obukhulu.
Kwi-Excel, umyinge olinganisiweyo ungabalwa usebenzisa umsebenzi we- SUMPRODUCT .
Indlela INKQUBO YOMSEBENZI WOKUSEBENZA NGAYO
Yiyiphi i-SUMPRODUCT eyenza iphindaphinda iziganeko ezimbini okanye ngaphezulu kwaye zongeza okanye zibale imveliso.
Ngokomzekelo, kwimiba apho iipragram ezimbini ezineenkalo ezine zifakwe njengezizathu ze-SUMPRODUCT umsebenzi:
- I-element yokuqala ye-array1 yanda ngeyonto yokuqala kwiqela2;
- Isalathisi sesibini soluhlu1 lwandiswa yinto yesibili yeqela2;
- Isigaba sesithathu soluhlu1 sandiswa yinto yesithathu yeqela2;
- Isahlulo sesine soluhlu1 lwandiswa yinto yesine yeqela2.
Emva koko, iimveliso zenkqubo yokuphindaphinda ezine zichazwe kwaye zibuyiselwe ngumsebenzi njengomphumo.
I-Excel INKQUBO YOMSEBENZI Umsebenzi we-Syntax kunye neeArguments
I- syntax yomsebenzi ibhekisela kwisakhiwo somsebenzi kwaye iquka igama lomsebenzi, amabakethi kunye neengxabano.
I-syntax ye-SUMPRODUCT umsebenzi:
= I-SUMPRODUCT (i-array1, i-array2, i-array3, ... i-array255)
Iingxoxo ze-SUMPRODUCT umsebenzi zi:
uluhlu1: (olufunekayo) ingxabano yokuqala.
uluhlu2, i-array3, ... i-array255: (ukhetho) ezongezelelweyo izixhobo, ukuya ku-255. Ngemiqolo emibini okanye ngaphezulu, umsebenzi uphinda uphinde uphinde ulandelelanise izinto zeqela ngalinye kunye kwaye ungeze iziphumo.
- iinkcukacha zesebe zingabonakalisa iselferensi kwindawo yendawo kwiphepha lokusebenzela okanye amanani ahlukaniswe ngabaqhubi be- arithmetic - njenge-plus (+) okanye i-minus signs (-). Ukuba iinombolo zingenayo ngaphandle kokuhlukaniswa ngabaqhubi, i-Excel iyabaphatha njengedatha yombhalo. Le meko ichazwe kumzekelo ongezantsi.
Qaphela :
Zonke iingxabano ezidibeneyo mazibe ngolo hlobo olufanayo. Okanye, ngamanye amagama, kufuneka kube nenani elifanayo lezinto kwiqela ngalinye. Ukuba akunjalo, i-SUMPRODUCT ibuyisela i-#VALUE! xabiso le mpazamo.
Ukuba nayiphi na into edibeneyo ayilona manani - njengedatha yombhalo - ISUMPRODUCT iyabaphatha njengezeros.
Umzekelo: Bala uMlinganiselo olinganisiweyo kwi-Excel
Umzekelo oboniswe kumfanekiso ongentla ukhankanya umyinge olinganiselwe uphawu lokugqibela lomfundi usebenzisa umsebenzi we-SUMPRODUCT.
Umsebenzi ufezekisa oku:
- ukuphindaphinda amanqaku amaninzi ngesisindo somzimba ngamnye;
- ukongeza imveliso yale mi sebenzi yokuphindaphinda;
- yahlula isixa esingentla ngentlawulo yesilinganisi esilinganisayo 7 (1 + 1 + 2 + 3) kwiimvavanyo ezine.
Ukungena kweFomula yokuPhatha
Njengeminye eminye imisebenzi kwi-Excel, i-SUMPRODUCT iqhele ngokuqhelekileyo kwiphepha lokusebenzela usebenzisa ibhokisi yencoko yencoko yomsebenzi. Nangona kunjalo, ekubeni umlinganiselo wokulinganisa usebenzise i-SUMPRODUCT ngendlela engagqibekanga-isiphumo somsebenzi sihlulwe ngumlinganiselo wesisindo - ifomula yokulinganisa kufuneka ifakwe kwifom yeshishini lomsebenzi .
Amanyathelo alandelayo ayetyenziselwa ukungenisa ifomula yokulinganisa kwiseli C7:
- Cofa kwiseli C7 ukwenzela ukuba yenze iseli esebenzayo -indawo apho umqondiso wokugqibela womfundi uza kuboniswa
- Thayipha ifom elandelayo kwiseli:
= I-SUMPRODUCT (B3: B6, C3: C6) / (1 + 1 + 2 + 3)
Cinezela ukhiye wokungena kwikhibhodi
- Impendulo ye- 78.6 ibonakale kwiselfowuni C7 - impendulo yakho inokuba neendawo ezingaphezulu
Umlinganiselo ongapheliyo owamanqaku amane afanayo uya kuba ngu- 76.5
Ekubeni umfundi ube neempembelelo ezingcono kwiminyaka yakhe yokugqibela kunye neemviwo zokugqibela, ukulinganisa umyinge kuncedwe ekuphuculeni uphawu lwakhe jikelele.
Uhlobo lweeFormula
Ukugxininisa ukuba iziphumo ze-SUMPRODUCT umsebenzi zidibene ngokwahlula iinqununu zeqela ngalinye lokuhlola, umcebisi-inxalenye yokwenza ukwahlula - ingeniswe njenge (1 + 1 + 2 + 3).
Umlinganiselo wokulinganisa jikelele ungenziwa lula ngokungena kwinombolo 7 (isixa semilinganiselo) njengomcebisi. I-formula iya kuba yile:
= I-SUMPRODUCT (B3: B6, C3: C6) / 7
Olu khetho luhle ukuba inani lezinto ezikwinqanaba elincinci kwaye linokudibaniswa ngokulula, kodwa lingaba lusebenza kangangoko njengoko inani lezinto ezikwinqanaba elixinayo landa ukwenza ukongeza kwabo kunzima.
Olunye ukhetho, kwaye mhlawumbi olukhethileyo - ekubeni lisetyenziselwa iinkcukacha zeseli kunokuba kunamanani kwi-divisor-iyakuba yinto yokusebenzisa umsebenzi we- SUM ukuze uhlalutye umcebisi ngefomu:
= I-SUMPRODUCT (B3: B6, C3: C6) / ISUM (B3: B6)
Ngokuqhelekileyo ukufaka iingxelo zeeseli kunokuba kunamanani okwenza amafomula njengoko yenza lula ukuhlaziya ukuba idatha yefomula iyatshintsha.
Ngokomzekelo, ukuba iziganeko ezinzima zoMsebenzi zatshintshelwe zibe ngu-0.5 kumzekelo kunye novavanyo kwi-1.5, iifom ezimbini zokuqala zefomyula ziya kufuneka zilungiswe ngesandla ukuze zilungise umcebisi.
Kwintlukwano yesithathu, kuphela idatha kwiiseli zeB3 kunye ne-B4 kufuneka ihlaziywe kwaye ifomula iya kuphinda ibuyele kwakhona umphumo.