Imisebenzi ye-Excel ibonelela ngenzuzo enkulu yokusinceda ukuba sizenzele iziphumo zemisebenzi eyahlukeneyo, nakwinqanaba lengqiqo.. Le yokugqibela ibhekisela kwinyani yokukwazi ukuhlalutya ixabiso ngenjongo yokumisela ukuba nayiphi na imeko echazwe ngaphambili idibene. Umzekelo, ukuba unoluhlu lwabafundi abanamabanga abo, unokwenza iseli apho bangqinisiswe khona ukuze bazi ukuba bamkelwe okanye hayi. Ukuba ufuna ukusebenzisa enye indlela efana nale, ufikile kwindawo elungileyo kuba siza kukubonisa indlela yokusebenzisa u-Ukuba umsebenzi kwi-Excel.
Yifomula ethi, ngenxa yomsebenzi wayo ekusebenzeni okusengqiqweni, inokoyikisa kwaye ibonakaliswe njengento enzima ukuyisebenzisa. Nangona kunjalo, kuchasene kwaye apha siza kubonisa ngomzekelo osebenzayo wokuyiqonda ngcono.
Yintoni i-If function kwi-Excel yeyantoni?
Ngaphambili, sikhankanye umzekelo apho siye sahlalutya ixabiso ukuze siqonde ukuba ibakala lomfundi liyaphumelela okanye akunjalo. Le yenye yamawaka eemeko apho sinokusebenzisa i-Ukuba umsebenzi kwi-Excel kwaye ukuba usebenzisa isixhobo rhoqo, kuqinisekile ukuba unoxwebhu onokuthatha kulo ithuba.
Umzekelo, asinakukwazi nje ukuhlalutya inani ukuze sazi ukuba likwinqanaba elithile okanye hayi, sinokuthelekisa iiseli ezimbini kwaye sijonge ukuba kukho iimatshisi.. Oku kuluncedo kakhulu kwiimeko apho kufuneka uqinisekise ubukho bedatha efanayo kumaphepha amabini e-Excel okanye iincwadi zokusebenza. Kuyakwanela ukubhenela kwi-Ukuba umsebenzi kwaye ungenise iimatshisi esizikhangelayo phakathi kweeparamitha.
Okulandelayo, siza kukubonisa onke amanyathelo ekufuneka uwalandele kunye neengqwalasela zangaphambili zokusebenzisa i-Ukuba umsebenzi kwi-Excel ngempumelelo kwaye ngaphandle kweengxaki.
Amanyathelo okusebenzisa u-Ewe umsebenzi
Abaqhubi bokuthelekisa
I-If function kwi-Excel isebenza ngokusetyenziswa kwezinto ezibizwa ngokuba ngabaqhubi bokuthelekisa. kwaye ukuzazi kuya kusivumela ukuba sazi ukuba zeziphi izixhobo esinazo ukuze siqhube iinkqubo esizidingayo ngale fomula. Abasebenzisi bengqiqo ngaba balandelayo:
- Ngokufanayo: =
- Enkulu kune: >
- Incinci kune:
- Enkulu kuno okanye ilingana no: >=
- Ngaphantsi kwe okanye ilingana no: <=
- Yahlukile kwi: <>
Uluhlu lwangaphambili lunalo lonke uthelekiso okanye uhlalutyo esinokuthi silwenze amanani kunye namaxabiso kuyo nayiphi na iseli ye-Excel. Ekuphela kwemigaqo esekiweyo yokusebenzisa aba baqhubi yileyo iseka i-syntax yomsebenzi, ngoko ke unokuzihlengahlengisa ngokupheleleyo kwinto oyifunayo, ukuba nje uthobela oku kungasentla.
Ukuba iSintaksi yoMsebenzi
Sele sisazi ukuba luluphi uthelekiso olunokwenzeka okanye uhlahlelo kunye ne-Ukuba umsebenzi kwi-Excel, ngoku siza kuphonononga i-syntax yayo. I-syntax ibhekisa kwizinto ezenza umsebenzi kunye nolandelelwano ekufuneka ziphakanyiswe ngalo ukuze i-Excel iyiqonde kwaye ibale.. Kwimeko ye Ukuba umsebenzi, isivakalisi yile:
=IF(Uvavanyo olusengqiqweni, Ixabiso ukuba yinyaniso, Ixabiso ukuba bubuxoki)
Oku kuthetha ukuba, emva kwezibiyeli, kufuneka singene:
- ubungqina obunengqiqo: Oku akukho nto ingaphaya kothelekiso esifuna ukulwenza, oko kukuthi, ukuba iseli enikiweyo ilingana no, inkulu kuno, ingaphantsi kune, okanye yahlukile kwenye okanye ukusuka kwixabiso elithile.
- ixabiso ukuba yinyani: ibhekisa kwinto eya kuboniswa kwiseli ukuba imeko ifezekisiwe.
- ixabiso ukuba bubuxoki: yinto eza kuboniswa kwiseli ukuba imeko ayihlangatyezwanga.
Umzekelo wokusebenzisa i-If Function
Ngoku, ukuba siyithatha kumzekelo osebenzisekayo ngakumbi, siza kubuyela kumzekelo ebesixubushe ngawo ekuqaleni, apho sinoluhlu olunabafundi kunye namabanga. Sifuna ukuba negumbi apho kucazululwa isiqinisekiso ekuthethwa ngaso kwaye sibonakaliswe ukuba sivunyiwe okanye asisekelwanga kumanqaku ayi-100, kuphunyelelwe ibakala eliyi-50..
Ukwenza oku, cofa kwiseli uze ungenise:
=EWE(E7>=50, «Ewe», «Hayi»)
Faka esikhundleni u-E7 ngeseli apho ibakala lifumaneka kwimeko yakho. Ekugqibeleni, kwaye ucinezela u-Enter, umphumo uya kuboniswa ngokukhawuleza. Okunye kuya kuba kukutsala ifomula ukuya kwezinye iiseli ukuze ulwazi esifuna ukulufumana ngokuzenzekelayo luboniswe. Konke oku kufuneka usebenzise i-Ukuba umsebenzi kwi-Excel kwezi ntlobo zeemeko.
Isiphelo
Njengoko sibonile, ukuba umsebenzi kwi-Excel uluncedo kakhulu kwiimeko ezininzi ezahlukeneyo. Ngale ndlela, yifomula ekufuneka siyazi kwaye siyiphathe ngokugqibeleleyo ukuba sifuna ukusebenzisana ne-Excel rhoqo kakhulu kumsebenzi wethu wemihla ngemihla. Abaqhubi bothelekiso, besetyenziswe kakuhle kulo msebenzi, baya kukugcina ixesha elininzi kwaye baya kukuvumela ukuba ube ne-spreadsheet eluncedo kakhulu kunye nezinto ezininzi.