Umsebenzi we-IF uneza ukwenza izigqibo kwi- spreadsheets ze- Excel ngokuvavanya imeko ecacileyo ukuze ubone ukuba kuyinyaniso okanye buxoki. Ukuba imeko yinyani, umsebenzi uya kuqhuba isenzo esinye. Ukuba loo mqathango ungamanga, iya kuqhuba isenzo esahlukileyo. Funda kabanzi malunga nomsebenzi we-IF apha ngezantsi.
Ukwenza izibalo kunye nokufaka idatha kunye ne-IF Function
I- syntax yomsebenzi ibhekisela kwisakhiwo somsebenzi kwaye iquka igama lomsebenzi, amabakethi kunye neengxabano .
I-syntax yomsebenzi kukuba:
= IF (uvavanyo lweengcamango, xabiso ukuba luyinyaniso, luxabiseke ukuba lubuxoki)
Uvavanyo lweengcamango luhlala luqhathaniswa phakathi kwamaxabiso amabini. Ukusetyenziswa koomatshini kusetyenziswa, umzekelo, ukubona ukuba ixabiso lokuqala likhulu kunalo okanye ngaphantsi kweyesibini, okanye lilingana nalo.
Umzekelo, emfanekisweni apha, uvavanyo lwengqondo lufanisa iimvuzo zomqeshwa ezisekholamini B ukuze zibone ukuba zinkulu kunezigidi ezingama-30,000.00.
= IF (B2> 30000, B2 * 1%, 300)
Xa umsebenzi uqikelele ukuba uvavanyo lwengqondo luyinyani okanye lubuxoki, lwenza enye yezenzo ezimbini ezichazwe yintengo ukuba yinyaniso kwaye ixabisa ukuba iingxabano zobuxoki.
Iindidi zezenzo eziza kusebenza ziquka:
- ukwenza izibalo usebenzisa ifomula okanye ukungena kwedatha yenombolo
- ukubonisa izitatimende zetekisi kwiiseli zomsebenzi ezikhethiweyo,
- ukushiya ilitye elijoliswe kuyo.
Ukwenza izibalo kunye nomsebenzi we-IF
Umsebenzi we-IF unokwenza izibalo ezahlukeneyo kuxhomekeke ekubeni ngaba umsebenzi ubuyisela ixabiso lenene okanye cha.
Kulo mfanekiso ungentla, ifomula isetyenziselwa ukubala inani lemali elithathelayo ngokusekelwe kumvuzo wokuqeshwa.
= IF (B2> 30000, B2 * 1%, 300)
Inqanaba lokuncitshiswa libalwe ngokusebenzisa ifom yangeniswa njengexabiso xa kukho ingqinano yokwenyaniso . Ifomula iphindaphinda imivuzo ekhoyo kwikholam B nge-1% ukuba impatho yomqeshwa ikhulu kune $ 30,000.00.
Ukufaka iDatha kunye ne-IF Function
Umsebenzi we-IF unokusekwa kwakhona ukufaka idatha yeenombolo kwiseli ejoliswe kuyo. Le datha ingasetyenziselwa kwezinye izibalo.
Kulo mzekelo ngasentla, ukuba umvuzo womqeshwa ungaphantsi kwe-$ 30,000.00, ixabiso ukuba imposiselo yamanga isetyenzisiweyo ukufaka isamba esicatyiweyo sama-300.00 kwi-deduction kunokusebenzisa ukubala.
Qaphela: Akukho dolaphu okanye i-comma separator engenayo neenombolo 30000 okanye ezingama-300 kumsebenzi. Ukufaka omnye okanye zombini udala amaphutha kwifomula.
- Imisebenzi ye-Excel isebenzisa i-comma njengomhluli phakathi kweengxabano, ngoko ke ukungena kwi-commas kunye namanani kukhokelela i-Excel ukuba ikholelwe ukuba ingxoxo engaphezulu kweyesithathu ifakiwe kwi-IF function.
- Ekubeni iimpawu zeedola ziimpawu zetekisi, ukungena kwabo ngamanani kubangela i-Excel ukuba ikholelwe ukuba iphutha lokuthayipha lenziwe kwaye linikeza ukukulungisa.
Ukubonisa iZitatimende zombhalo okanye Ukushiya iiseli ezingenanto kwi-Excel IF Function
Ukubonisa amagama okanye izitatimende zenkcazo nge-IF Function
Ukuba nombhalo oboniswe ngumsebenzi we-IF kunokuba inombolo ingenza kube lula ukufumana nokufunda iziphumo ezithile kwiphepha lokusebenzela.
Kulo mzekelo ukhankanywe ngasentla, umsebenzi we-IF ulungiselelwe ukuvavanya ukuba ngaba abafundi bathatha i-quiz geography ngokuchanekileyo bachonga iidolophu ezinkulu kwiindawo ezininzi eSouth Pacific.
Uvavanyo lweengcamango lomsebenzi we-IF ufanisa iimpendulo zabafundi kwikholam B kunye nempendulo echanekileyo efakwe kwingxabano ngokwayo.
Ukuba impendulo yomfundi ihambelana negama elifakwe kwingxabano yombhalo wegama, igama elichanekileyo liboniswa kwikholamu C. Ukuba igama alihambisani, iseli lishiywe libala.
= IF (B2 = "I-Wellington", "Yilungile", "")
Ukusebenzisa amagama angabodwa okanye izitatimende zetekisi kumsebenzi we-IF ngamnye ukungena kufuneka kufakwe kwiingcaphuno ezifana ne:
- ingxabano yovavanyo lologi: B2 = "iWellington"
- xabiso ukuba ingqinano yokwenyaniso "Yilungile"
Ukushiya iiseli ezingenanto
Njengoko kubonisiwe kwindleko ukuba impikiswano yobuxoki kumzekelo ongentla, iiseli zishiywe zingenanto ngokufaka ibini yamanqaku ekhutshulwa angenanto ( "" ).