Phakathi kwemisebenzi eminingi i-Microsoft Excel esebenza ngayo, umsebenzi we-IF kufanele uqokonyiswe. Lokhu kungenye yalabo opharetha abasebenzisi baphendukela kuwo kaningi lapho benza imisebenzi kuhlelo lokusebenza. Ake sibheke ukuthi yini umsebenzi we-IF, nokuthi ungasebenza kanjani nalo.
Ukuchazwa okujwayelekile nezinhloso
IF yisici esejwayelekile seMicrosoft Excel. Imisebenzi yakhe ifaka phakathi ukuqinisekisa ukugcwaliseka kwesimo esithile. Esimweni lapho isimo sigcwalisiwe (kuyiqiniso), khona-ke inani elilodwa libuyiselwa esitokisini lapho lo msebenzi usetshenziswa khona, futhi uma kungenzeki (ngamanga) - okunye.
Isichasiso salo msebenzi kanje: "UMA (inkulumo enengqondo; [inani uma liyiqiniso]; [inani uma lingelamanga])."
Isibonelo sokusetshenziswa
Manje ake sibheke izibonelo ezithile lapho kusetshenziswa ifomula enesitatimende se-IF.
Sinethebula lomholo. Bonke abesifazane bathola ibhonasi ngoMashi 8 kuma-ruble ayi-1 000. Ithebula linekholamu elibonisa ubulili babasebenzi. Ngakho-ke, kudingeka siqinisekise ukuthi emgqeni ngenani "abafazi". kukholamu "Ubulili", inani "1000" likhonjiswe kuseli elihambisanayo lekholamu "I-Premium ngoMashi 8", nasemigqeni enenani "umyeni." kukholamu "Umklomelo kaMashi 8" ume inani "0". Umsebenzi wethu uzothatha ifomu: "UMA (B6 =" owesimame. ";" 1000 ";" 0 ")."
Faka le nkulumo kuseli eliphezulu kakhulu lapho umphumela kufanele uboniswe khona. Ngaphambi kwenkulumo, beka uphawu "=".
Ngemuva kwalokho chofoza inkinobho ethi Faka. Manje, ukuze le formula ivele kumaseli angaphansi, sivele sime ekhoneni elingezansi kwesokudla kweseli egcwele, chofoza inkinobho yegundane, bese uhambisa isikhombisi siye ezansi etafuleni.
Ngakho-ke, sithole itafula elinekholomu eligcwele umsebenzi "UMA".
Isibonelo somsebenzi ngezimo eziningi
Ungafaka futhi imibandela eminingana emsebenzini we-IF. Kulokhu, ukunamathiselwa kwesitatimende esisodwa se-IF kwesinye kuyafakiwe. Lapho isimo sihlangatshezwa, umphumela obekiwe ukhonjiswa esitokisini; uma isimo singatholakali, umphumela obonisiwe uxhomeke ku-opharetha wesibili.
Isibonelo, ake sithathe itafula elifanayo ngokukhokha kwe-premium ngoMashi 8. Kepha, kulokhu, ngokuya ngemibandela, usayizi webhonasi uncike esigabeni sabasebenzi. Abesifazane abanesimo sabasebenzi abakhulu bathola ama-ruble ayi-1 000 webhonasi, kuyilapho abasebenzi abasizayo bethola ama-ruble angama-500 kuphela. Ngokwemvelo, kwabesilisa lolu hlobo lokukhokha ngokuvamile aluvunyelwe, noma ngabe isigaba sini.
Ngakho-ke, isimo sokuqala ukuthi uma isisebenzi singabesilisa, khona-ke inani lephrimiyamu elitholwe zero. Uma leli nani lingamanga, futhi umsebenzi engeyona indoda (isb. Owesifazane), isimo sesibili siyahlolwa. Uma owesifazane engowabasebenzi abakhulu, inani elingu- "1000" lizokhonjiswa esitokisini, bese kungenjalo "500". Esimweni sefomula, kuzobukeka kanjena: "= IF (B6 =" umyeni. ";" 0 "; IF (C6 =" staff basic ";" 1000 ";" 500 ")).
Namathisela le nkulumo kwiseli ephakeme kunazo zonke kukholamu ethi "Mhlaka 8 Mashi".
Njengokugcina, "sidonsa" ifomula phansi.
Isibonelo sokugcwalisa izimo ezimbili ngasikhathi sinye
Ungasebenzisa futhi Osebenza ku-NO ekusebenzeni kwe-IF, okuvumela ukuthi ucabange njengeqiniso kuphela uma izimo ezimbili noma ngaphezulu zigcwaliseka ngasikhathi.
Isibonelo, kithi, umklomelo owenziwe ngoMashi 8 ngenani lama-ruble ayi-1000 unikezwa kuphela abesifazane okuyizisebenzi eziphambili, kuyilapho abamele abesilisa nabesifazane ababhaliswe njengabasebenzi abasizayo bengatholi lutho. Ngakho-ke, ukuze inani lamaseli wekholamu "iPrimiyamu ngoMashi 8" abe yi-1000, kufanele kuhlangatshezwane nemibandela emibili: ubulili - abesifazane, isigaba sabasebenzi - abasebenzi abasezingeni eliphakathi. Kuzo zonke ezinye izimo, inani elikula maseli lizoba yi-zero zakuqala. Lokhu kubhaliwe ifomula elandelayo: "= UMA (FUTHI (B6 =" owesimame. "; C6 =" Abasebenzi abahamba phambili ");" 1000 ";" 0 ")." Faka esitokisini.
Njengasesikhathini esedlule, kopisha inani lefomula kumaseli angezansi.
Isibonelo sokusebenzisa opharetha we-OR
Umsebenzi we-IF ungasebenzisa futhi i-opharetha ye-OR. Kusho ukuthi inani liyiqiniso uma okungenani eyodwa yezimo eziningana yanelisekile.
Ngakho-ke, ake sithi ngoMashi 8, umklomelo wabekwa kuma-ruble ayi-100 kuphela kwabesifazane abaphakathi kwabasebenzi abakhulu. Kulokhu, uma isisebenzi singabesilisa, noma singabasebenzi abasizayo, khona-ke inani lebhonasi lakhe lizoba zero, kungenjalo ama-ruble ayi-1000. Esimweni sefomula, kubukeka kanjena: "= UMA (NOMA (B6 =" umyeni. "; C6 =" Abasebenzi Abesekayo ");" 0 ";" 1000 ")." Sibhala le formula esitokisini esihambelanayo sethebula.
"Donsela" imiphumela phansi.
Njengoba ukwazi ukubona, umsebenzi we- “IF” ungaba umsizi omuhle kumsebenzisi lapho usebenza nedatha ekwi-Microsoft Excel. Ikuvumela ukuthi ubonise imiphumela ehlangabezana nemibandela ethile. Akukho lutho oluyinkimbinkimbi kakhulu ekuqondeni imigomo yokusebenzisa lo msebenzi.
