Umsebenzi we-IF uneza ukwenza izinqumo kuma- spreadsheet e-Excel ngokuhlola isimo esibekiwe ukuze ubone ukuthi kuyiqiniso noma kumanga. Uma isimo siyiqiniso, umsebenzi uzokwenza isenzo esisodwa. Uma isimo singamanga, sizokwenza isenzo esihlukile. Funda kabanzi mayelana nomsebenzi we-IF ngezansi.
Ukwenza izibalo nokufaka idatha nge-IF Function
I- syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi, amabakaki, nokuphikisana .
I-syntax yalo msebenzi yilezi:
= IF (ukuhlolwa kwelogi, ukubaluleka uma kuyiqiniso, ukubaluleka uma kungamanga)
Isivivinyo sama-logic sihlale siqhathanisa phakathi kwamagugu amabili. Ama-opharetha wokuqhathanisa asetshenzisiwe, isibonelo, ukubona ukuthi inani lokuqala likhulu kunanoma yiliphi, noma lilingana nalo.
Isibonelo, esithombeni lapha, ukuhlolwa kwelogiki kuqhathanisa nezinzuzo zomsebenzi ezisekholomu B ukuze ubone ukuthi zingaphezu kuka-$ 30,000.00.
= IF (B2> 30000, B2 * 1%, 300)
Uma umsebenzi ubeka ukuthi ukuhlolwa kwe-logic kuyiqiniso noma kungamanga, kufeza enye yezenzo ezimbili ezichazwe inani uma liyiqiniso futhi libiza uma izimpikiswano zamanga.
Izinhlobo zezenzo umsebenzi ongazifeza zihlanganisa:
- ukwenza izibalo ngokusebenzisa ifomula noma ukungena kwedatha yenombolo
- ukubonisa izitatimende zombhalo kumaseli omsebenzi okhethiwe,
- ushiye iseli elitshekile lingenalutho.
Ukwenza izibalo nge-IF Function
Umsebenzi we-IF ungenza izibalo ezahlukene kuye ngokuthi ngabe umsebenzi ubuyisela yini inani langempela noma cha.
Emfanekisweni ngenhla, ifomula isetshenziselwa ukubala inani lokudonsa elisuselwe kumholo wokuqashwa.
= IF (B2> 30000, B2 * 1%, 300)
Isilinganiso sokudonsa sibalwa ngokusebenzisa ifomula efakwe njengexabiso uma ingxabano yeqiniso . Ifomula iphindaphinda imali etholakala kukholomu nge-1% uma imali yomsebenzi ingaphezulu kuka-$ 30,000.00.
Ukufaka idatha nge-IF Function
Umsebenzi we-IF ungasethwa futhi ukufaka idatha yocingo kwiseli elihlosiwe. Le datha ingasetshenziswa kwezinye izibalo.
Esikhathini esingenhla, uma inzuzo yomsebenzi ingaphansi kuka-$ 30,000.00, inani uma ingxabano yamanga isethelwe ukufaka isilinganiso esiphezulu se $ 300.00 sokudonswa kunokusebenzisa isibalo.
Qaphela: Ayikho isibonakaliso se-dollar noma i-comma separator efakwe ngezinombolo ezingu-30000 noma ezingu-300 kulo msebenzi. Ukufaka noma eyodwa noma kokubili kudala amaphutha kwifomula.
- Imisebenzi ye-Excel isebenzisa i-comma njengokuhlukanisa phakathi kwezimpikiswano, ngakho ukungena kwamakhompi ngezinombolo kubangela i-Excel ukuba ikholelwe ukuthi kunezingxabano ezingaphezu kwezingu-3 ezifakwe emsebenzini we-IF.
- Njengoba izimpawu ze-dollar ziyizinhlamvu zombhalo, ukufaka kuzo ngezinombolo kuholela ku-Excel ukuze ukholelwe ukuthi iphutha lokuthayipha liye lazinikezwa futhi linikeza ukulilungisa.
Ukubonisa Izitatimende Zombhalo noma Ukushiya Amaseli Aphuliwe Ngomsebenzi We-Excel IF
Ukubonisa Amagama noma Umbhalo Wezitatimende nge-IF Function
Ukuba nombhalo oboniswe umsebenzi we-IF kunokuba inombolo ingenza kube lula ukuthola nokufunda imiphumela ethile kumshicileli wokusebenzela.
Kulesi sibonelo esingenhla, umsebenzi we-IF usethelwe ukuhlola ukuthi ngabe abafundi bathatha imenyu ye-geography baqonde kahle yini imizi emikhulu yezindawo eziningi eNingizimu Pacific.
Ukuhlolwa kwelokusebenza komsebenzi we-IF kuqhathanisa nezimpendulo zabafundi kukholomu B nempendulo efanelekile efakwe engxabaneni ngokwalo.
Uma impendulo yomfundi ihambelana negama elifakwe engxenyeni yombhalo we-logic, igama elilungile likhonjiswa kukholomu C. Uma igama lingavumelani, iseli lingashiywanga lutho.
= IF (B2 = "i-Wellington", "lungisa", "")
Ukusebenzisa amagama angashadile noma izitatimende zombhalo ku-IF umsebenzi ngamunye ukungena kufanele kufakwe emacaphuni, njenge:
- ingxabano yokuhlola logic: B2 = "Wellington"
- inani uma ingxabano yeqiniso "iqondisa"
Ukushiya Amaseli Aphuliwe
Njengoba kuboniswe ngenani uma ingxabano yamanga kulesi sibonelo ngenhla, amaseli ashiywe engenalutho ngokufaka idijithi yamanothi wekhothethi angenalutho ( "" ).