Phakathi kwamazwi amaningi ahlukene asetshenziswa uma usebenzisa i-Microsoft Excel, kufanele ukhethe imisebenzi enengqondo. Zisetshenziselwa ukukhombisa ukugcwaliseka kwezimo ezihlukahlukene emafomulini. Ngaphezu kwalokho, uma izimo ngokwazo zingahlukahluka kakhulu, umphumela wemisebenzi enengqondo ingathatha amanani amabili kuphela: isimo sigcwaliseka (Iqiniso) futhi isimo asihlangabezane (FALSE). Ake sibheke ngokucophelela lokho okusebenzayo okunembile ku-Excel.
Opharetha abakhulu
Kukhona opharetha abaningana bemisebenzi enengqondo. Phakathi kokuyinhloko, okulandelayo kufanele kugcizelelwe:
- IQINISO;
- FALSE;
- IF;
- ERROR;
- OR;
- Futhi;
- CHA;
- ERROR;
- UKUKHULUZA.
Kunemisebenzi ejwayelekile engavamile.
Ngamanye ama-operators angenhla, ngaphandle kwalababili bokuqala, unezimpikiswano. Iziphakamiso zingaba izinombolo ezithile noma umbhalo, noma izinkomba ezibonisa ikheli lamaseli wedatha.
Imisebenzi Iqiniso futhi FALSE
I-Operator Iqiniso yamukela kuphela inani elithile elibhekiswe kulo. Lo msebenzi awunazo izimpikiswano, futhi, njengomthetho, cishe njalo uyingxenye yezinkulumo eziyinkimbinkimbi.
I-Operator FALSENgokuphambene nalokho, lamukela noma yiliphi inani elingelona iqiniso. Ngokufanayo, lo msebenzi awunazo izimpikiswano futhi ufakwe ezinkulumweni eziyinkimbinkimbi.
Imisebenzi Futhi futhi Noma
Umsebenzi Futhi yisixhumanisi phakathi kwezimo eziningana. Kuphela uma zonke izimo ukuthi lo msebenzi ubopha, ingabe ubuya Iqiniso. Uma okungenani impikiswano eyodwa ibika inani FALSEke opharetha Futhi ngokuvamile kubuyisa inani elifanayo. Ukubuka okujwayelekile kwalokhu msebenzi:= Futhi (log_value1; log_value2; ...). Umsebenzi ungabandakanya kusuka ku-1 kuya ku-255 izimpikiswano.
Umsebenzi Noma, ngokuphambene nalokho, ubuyisela i-TRUE, ngisho noma enye yezingxabano ihlangabezana nezimo, futhi bonke abanye bangamanga. Isifanekiso sayo sinjengoba:= Futhi (log_value1; log_value2; ...). Njengomsebenzi wangaphambilini, opharetha Noma ingafaka phakathi kokungu-1 kuya kwangu-255 izimo.
Umsebenzi CHA
Ngokungafani nezitatimende ezimbili ezedlule, umsebenzi CHA Kunengxabano eyodwa kuphela. Lishintsha incazelo yenkulumo nge Iqiniso kuqhubeke FALSE endaweni yesigatshana esicacisiwe. I-formula jikelele ye-syntax yile ndlela elandelayo:= CHA (i-log_value).
Imisebenzi IF futhi ERROR
Ukuze uthole izakhiwo eziyinkimbinkimbi, sebenzisa umsebenzi IF. Lesi sitatimende sikhombisa ukuthi yiliphi inani Iqinisofuthi yikuphi FALSE. Iphethini layo jikelele linjengalokhu:= I-IF (i-boolean_yokucindezela; inani_if_es_far_; value_if-false). Ngakho-ke, uma isimo sifinyelelwe, idatha ecacisiwe ngaphambili igcwaliswe eselilini equkethe lo msebenzi. Uma lesi simo singagciniwe, iseli ligcwele enye idatha ecacisiwe kwingxabano yesithathu yomsebenzi.
I-Operator ERROR, uma ngabe iphikisana liyiqiniso, libuyisela inani layo esitokisini. Kodwa, uma ukuphikisana kungavumelekile, inani elibuyiselwe umsebenzisi libuyiselwa kuseli. I-syntax yalo msebenzi, equkethe izingxabano ezimbili kuphela, kanje:= ERROR (inani; value_if_fault).
Isifundo: Uma ngabe umsebenzi ku-Excel
Imisebenzi ERROR futhi UKUKHULUZA
Umsebenzi ERROR uhlola ukuthi ngabe iseli ethile noma ububanzi bamaseli aqukethe amanani angalungile. Ngaphansi kwamanani angalungile yilokhu okulandelayo:
- # N / A;
- #VALUE;
- #NUM!;
- # DEL / 0!;
- # LINK!;
- # NAME ?;
- # NULL!
Kuye ngokuthi ingxabano engavumelekile noma cha, u-opharetha ubika inani Iqiniso noma FALSE. I-syntax yalo msebenzi ilandelayo:= ERROR (inani). Ukuphikisana kubhekisela kuphela esitokisini noma inqwaba yamaseli.
I-Operator UKUKHULUZA yenza isheke lihlole ukuthi lingenalutho noma liqukethe amanani. Uma iseli lingenalutho, lo msebenzi ubika inani Iqinisouma iseli liqukethe idatha - FALSE. I-syntax yalesi sitatimende yile:= CORRECT (inani). Njengokwesikhashana esidlule, ukuphikisana kubhekisela esitokisini noma emgqeni.
Isibonelo sohlelo lokusebenza
Manje ake sicabangele ukusetshenziswa kwemisebenzi engenhla ngesibonelo esithile.
Sine uhlu lwabasebenzi abanemiholo yabo. Kodwa, ngaphezu kwalokho, bonke abasebenzi bathola ibhonasi. I-premium evamile ingama-ruble angu-700. Kodwa abahola impesheni nabesifazane banelungelo lokukhushulwa kwama-ruble angu-1,000. Ngaphandle kwabasebenzi abaye basebenza izinsuku ezingaphansi kwezinsuku ezingu-18 enyangeni enikeziwe ngezizathu ezihlukahlukene. Kunoma yikuphi, banelungelo lokukhokhela i-premium evamile yama-ruble angu-700.
Ake sizame ukwenza ifomula. Ngakho-ke, sinemibandela emibili, ukusebenza okubeka imali eyinkulungwane ye-ruble 1000 - ukufinyelela eminyakeni yobudala bomhlalaphansi noma ukusebenza komuntu wesifazane. Ngesikhathi esifanayo, sizokwabela bonke labo abazalelwa ngaphambi kuka-1957 kubafesheni. Esikhathini sethu, emgqeni wokuqala wetafula, ifomula izobukeka kanje:= IF (OR (C4 <1957; D4 = "owesifazane"); "1000"; "700"). Kodwa ungakhohlwa ukuthi into ebalulekile yokuthola i-premium eyanda isebenza ezinsukwini ezingu-18 noma ngaphezulu. Ukushumeka lesi simo esimweni sethu, sebenzisa umsebenzi CHA:= IF (OR (C4 <1957; D4 = "owesifazane") * (CHA (E4 <18)); "1000"; "700").
Ukuze ukopishe lo msebenzi kumaseli ekholomu yetafula, lapho inani le-premium likhonjiswa khona, siba isikhombisi ekhoneni elingaphansi kwesokudla leseli lapho kakade ifomula. Uphawu lokugcwalisa luvela. Vele uhudule phansi ekugcineni kwetafula.
Ngakho, sithole itafula ngolwazi mayelana nenani lomklomelo ngomsebenzi ngamunye webhizinisi ngokwehlukana.
Isifundo: imisebenzi ewusizo kakhulu
Njengoba ungabona, imisebenzi enengqondo iyithuluzi elilula kakhulu lokwenza izibalo ku-Microsoft Excel. Ukusebenzisa imisebenzi eyinkimbinkimbi, ungabeka izimo eziningana ngesikhathi esisodwa bese uthola umphumela wokukhishwa kuye ngokuthi lezi zimiso zigcwalisekile noma cha. Ukusetshenziswa kwamafomula anjalo kukwazi ukuzenzakalela izinyathelo eziningi, okugcina isikhathi somsebenzisi.
