Phakathi kwezinkulumo eziningi ezahlukahlukene ezisetshenziswayo lapho usebenza neMicrosoft Excel, imisebenzi enengqondo kufanele igqanyiswe. Zisetshenziselwa ukukhombisa ukugcwaliseka kwezimo ezahlukahlukene kumafomula. Ngaphezu kwalokho, uma izimo ngokwazo zingahluka kakhulu, khona-ke umphumela wemisebenzi ebonakalayo ungathatha amanani amabili kuphela: isimo senelisiwe (IQINISO) futhi isimo aseneliseki (FALSE) Ake sibhekisise ukuthi yimiphi imisebenzi enengqondo e-Excel.
Ama-opharetha abalulekile
Kukhona opharetha abanengqondo abahlukahlukene. Phakathi kwezinto eziphambili yilezi ezilandelayo:
- IQINISO;
- FALSE;
- UMA;
- UMA IRROR;
- NOMA
- Futhi;
- Hhayi;
- I-ERROR;
- KULULA.
Kunemisebenzi engatheni evamile enengqondo.
Omunye wabasebenza ngenhla, ngaphandle kwalaba bokuqala, unazo izimpikiswano. Izimpikiswano zingaba izinombolo ezithile noma umbhalo, noma izixhumanisi ezikhombisa ikheli lamaseli wedatha.
Imisebenzi IQINISO futhi FALSE
Umsebenzi IQINISO yemukela kuphela uhlobo oluthile. Lo msebenzi awunazimpikiswano, futhi, njengomthetho, cishe njalo uyingxenye ebalulekile yezinkulumo eziyinkimbinkimbi ngokwengeziwe.
Umsebenzi FALSEkunalokho, kuthatha noma yiliphi inani elingelona iqiniso. Ngokufanayo, lo msebenzi awunazimpikiswano futhi ufakwa ezinkulumweni eziyinkimbinkimbi ngokwengeziwe.
Imisebenzi Futhi futhi NOMA
Umsebenzi Futhi isixhumanisi phakathi kwezimo eziningana. Kuphela uma zonke izimo ezibopha lo msebenzi ziyaneliswa, ibuyisela inani IQINISO. Uma okungenani impikiswano eyodwa ibika inani FALSEbese kuba opharetha Futhi ngokuvamile ibuyisela inani elifanayo. Ukubuka okujwayelekile kwalomsebenzi:= Futhi (log_value1; log_value2; ...). Umsebenzi ungafaka phakathi kokuphikisana okungu-1 kuye ku-255.
Umsebenzi NOMA, okuphambene nalokho, ibuyisela i-TRUE noma ngabe eyodwa kuphela yezimpikiswano ihlangabezana nemibandela futhi bonke abanye bengamanga. Isifanekiso sakhe sinje:= Futhi (log_value1; log_value2; ...). Njengomsebenzi owedlule, opharetha NOMA zingafaka phakathi kwezimo ezi-1 kuye kwezingu-255.
Umsebenzi Hhayi
Ngokungafani nezitatimende ezimbili ezedlule, umsebenzi Hhayi inengxabano eyodwa. Ushintsha okushiwo yile nkulumo nge IQINISO kuvuliwe FALSE esikhaleni sengxabano eshiwo. I-syntlax ejwayelekile ye-formula imi kanje:= HAYI (log_value).
Imisebenzi UMA futhi UMA ISIQHAWU
Ngemiklamo eyinkimbinkimbi, sebenzisa umsebenzi UMA. Lesi sitatimende sikhombisa ukuthi yiliphi inani IQINISOfuthi ini FALSE. Ithempulethi yayo ejwayelekile imi kanje:= UMA (boolean_expression; value_if_true; value_if_false). Ngakho-ke, uma isimo sihlangabezana, khona-ke imininingwane ebekade icacisiwe igcwaliswa kuseli equkethe lo msebenzi. Uma isimo singekho, khona-ke iseli ligcwele enye idatha echazwe endaweni yesithathu yokusebenza.
Umsebenzi UMA ISIQHAWU, uma impikiswano iyiqiniso, ibuyisela inani layo esitokisini. Kepha, uma impikiswano inephutha, khona-ke inani elivezwa ngumsebenzisi libuyiselwa esitokisini. I-syntax yalo msebenzi, equkethe izimpikiswano ezimbili kuphela, imi ngale ndlela elandelayo:= UMA IRROR (inani; inani_if_error).
Isifundo: sebenza UMA ku-Excel
Imisebenzi I-ERROR futhi KULULA
Umsebenzi I-ERROR Ihlola ukubona ukuthi iseli ethile noma uhla lwamaseli liqukethe amanani ayiphutha. Amanani ayiphutha asho okulandelayo:
- # N / A;
- #VALUE;
- # INANI !;
- #DEL / 0!;
- # LINK !;
- #NAME ?;
- # EMPTY!
Ngokuya ngokuthi impikiswano inephutha noma cha, opharetha ubika inani IQINISO noma FALSE. I-syntax yalomsebenzi imi kanje:= I-ERROR (inani). Ukuphikisana kubhekiselwa kuphela kuseli noma uhlu lwamaseli.
Umsebenzi KULULA Ihlola iseli ukubona ukuthi ayinalutho noma iqukethe amanani. Uma iseli lingenalutho, umsebenzi ubika inani IQINISOuma iseli liqukethe idatha - FALSE. I-syntax yalokhu ku-opharetha imi kanje:= EMPTY (inani). Njengasesimweni esedlule, ukuxabana kubhekiselwa kuseli noma uhlu.
Isibonelo somsebenzi
Manje ake sibheke ukusetshenziswa kweminye yemisebenzi engenhla ngesibonelo esithile.
Sinohlu lwabasebenzi bebhizinisi nemiholo yabo. Kepha, ngaphezu kwalokho, bonke abasebenzi banebhonasi. I-premium ejwayelekile ngama-ruble angama-700. Kodwa abahola impesheni nabesifazane banelungelo lebhonasi ekhuphukile yama-ruble ayi-1 000. Okuhlukile yilaba basebenzi abasebenze isikhathi esingaphansi kwezinsuku eziyi-18 ngenyanga abanikezwe yona. Kunoma ikuphi, banelungelo lebhonasi ejwayelekile yama-ruble angama-700.
Ake sizame ukwenza ifomula. Ngakho-ke, sinezimo ezimbili lapho kubekwa khona ibhonasi yama-ruble ayi-1000 - lokhu kufinyelela kweminyaka yokuthatha umhlalaphansi noma ubulili besifazane. Ngasikhathi sinye, sifaka bonke labo abazalwa ngaphambi kuka-1957 njengabahola impesheni. Okwethu, kumugqa wokuqala wethebula, ifomula izothatha le ndlela elandelayo:= UMA (NOMA (C4 <1957; D4 = "Abesifazane"); "1000"; "700"). Kepha ungakhohlwa ukuthi imfuneko yokuthola i-premium iyasebenza izinsuku eziyi-18 noma ngaphezulu. Ukuze sisebenzise lesi simo kwifomula yethu, sisebenzisa umsebenzi Hhayi:= UMA (NOMA (C4 <1957; D4 = "ngowesifazane") * (HAYI (E4 <18)); "1000"; "700").
Ukuze ukopishe lo msebenzi kumaseli wekholomu yetafula lapho kukhonjiswa khona inani le-premium, siba yisikhombisi ekhoneni elingezansi kweseli lapho ifomula isivele ikhona. Umaka wokugcwalisa uyavela. Mane udonsele phansi ekugcineni kwetafula.
Ngakho-ke, sathola itafula elinolwazi mayelana nosayizi webhonasi kulowo nalowo msebenzi webhizinisi.
Isifundo: izici eziwusizo ze-Excel
Njengoba ukwazi ukubona, imisebenzi enengqondo iyithuluzi elilula kakhulu lokwenza izibalo ku-Microsoft Excel. Usebenzisa imisebenzi eyinkimbinkimbi, ungabeka imibandela eminingana ngasikhathi sinye bese uthola umphumela wokuphuma, ngokuya ngokuthi lezi zimo ziyahlangabezana yini noma cha. Ukusetshenziswa kwamafomula anjalo kungenza i-othomathikhi yezenzo ezithile, esiza ukusiza isikhathi somsebenzisi.
