Omunye wemisebenzi eyakhelwe ngaphakathi kwe-Excel yiyona I-FLOSS. Umsebenzi walo ukubuyela esakhiweni sephepha, lapho sitholakala khona, okuqukethwe kweseli, lapho isixhumanisi kufomathi yombhalo sichazwa njengengxabano.
Kubonakala sengathi akukho lutho olukhethekile ngalokhu, ngoba kungenzeka ukubonisa okuqukethwe kwesinye iseli komunye ngezindlela ezilula. Kodwa, njengoba kuvela, ngokusetshenziswa kwalena opharetha kufakwe ama-nuances awenzayo ahlukile. Kwezinye izimo, leli fomula likwazi ukuxazulula izinkinga ezinjalo ukuthi ezinye izindlela azikwazi ukubhekana nazo noma zizoba nzima nakakhulu ukuzenza. Ake sithole kabanzi mayelana nokuthi yini opharetha. I-FLOSS nokuthi ingasetshenziswa kanjani ekusebenzeni.
Ukusetshenziswa kwefomula ye-dvssyl
Igama lalo opharetha I-FLOSS imelela kanjani "Isixhumanisi Double". Empeleni, lokhu kubonisa injongo yayo - ukukhipha idatha ngokusebenzisa isixhumanisi esichaziwe kusuka kwelinye iseli kuya kwesinye. Ngaphezu kwalokho, ngokungafani neminye imisebenzi eminingi esebenza nezixhumanisi, kufanele icaciswe kwifomethi yombhalo, okungukuthi, iqokonyiswe ngamaphuzu ezinhlangothi zombili.
Lo opharetha ungokwesigaba semisebenzi "Izixhumanisi nezigaba" futhi ine-syntax elandelayo:
= I-FLOSS (isixhumanisi seseli; [a1])
Ngakho-ke, ifomula inezimpikiswano ezimbili kuphela.
Ukuphikisana I-Link Link iboniswa njengesixhumanisi esakhiweni sephepha, idatha equkethwe lapho ofuna ukukubonisa khona. Kulesi simo, isixhumanisi esibekiwe kufanele sibe nokubonakala kombhalo, okungukuthi, "kuhlanganiswe" kumacaphuno.
Ukuphikisana "A1" Akuyona igunya futhi ezimweni eziningi akudingeki ukuba kuchaziwe. Kungaba nezincazelo ezimbili. "TRUE" futhi "FALSE". Esikhathini sokuqala, opharetha uchaza izixhumanisi ngesitayela "A1", okungukuthi lesi sitayela sifakiwe ku-Excel ngokuzenzakalelayo. Uma inani lempikiswano lingacacisiwe nhlobo, khona-ke lizocatshangwa ngendlela efanayo "TRUE". Esimweni sesibili, izixhumanisi zichazwa ngesitayela "R1C1". Le ndlela yokuxhumanisa kumele ifakwe ngqo kuzilungiselelo ze-Excel.
Mane nje ubeke, ke I-FLOSS Kuyinto efana nokulinganisa kwesinye iseli komunye ngemuva kwesibonakaliso esifanayo. Isibonelo, ezimweni eziningi inkulumo
= I-FLOSS ("A1")
izofana nalokho okushiwo
= A1
Kodwa ngokungafani nkulumo "= A1" opharetha I-FLOSS ayibopheli esitokisini esithile, kodwa kuya kuzixhumanisi zento esetsheni.
Cabanga ukuthi lokhu kusho ukuthini esibonelweni esilula. Emasethini B8 futhi B9 ngokulandelana ngokuthunyelwe okuqoshiwe "=" ifomula nomsebenzi I-FLOSS. Womabili amafomula abhekisela kwisici. B4 futhi ubonise okuqukethwe kwayo kushidi. Ngokuvamile lokhu okuqukethwe kuyafana.
Engeza enye into engenalutho etafuleni. Njengoba ungabona, imigqa ihambile. Kufomula nge kufana inani lihlala lifanayo, ngoba libhekisela esitokisini sokugcina, noma ngabe izixhumanisi zayo zishintshile, kodwa idatha ekhishwa ngu-opharetha I-FLOSS ushintshile. Lokhu kubangelwa ukuthi akubhekiseli kulesici seseti, kepha kuzixhumanisi. Ngemuva kokungeza ikheli le-line B4 iqukethe enye into yephepha. Okuqukethwe kwayo manje kuyifomula futhi kubonisa kushidi.
Lo opharetha uyakwazi ukukhipha kwenye iseli hhayi izinombolo kuphela, kodwa futhi umbhalo, umphumela wokubala amafomula nanoma yiziphi ezinye izindinganiso ezitholakala engxenyeni ekhethiwe yeshidi. Kodwa ngokuzikhandla, lo msebenzi awuvamile ukusetshenziselwa ngokuzimela, kodwa kaningi kuyingxenye ebalulekile yefomula eziyinkimbinkimbi.
Kumele kuqashelwe ukuthi lo opharetha usebenza ngokubhekisela kwamanye amashidi ngisho nakwezinye izincwadi ze-Excel, kodwa kuleli cala kumele zigijime.
Manje ake sibheke izibonelo ezithile zesicelo se-opharetha.
Isibonelo 1: uhlelo lokusebenza olulodwa lomsebenzisi
Ukuze uqale, cabangela isibonelo esilula kunazo zonke lapho umsebenzi khona I-FLOSS yenza ngokuzimela ukuze ukwazi ukuqonda umsebenzi wakhe.
Sinetafula elingenakuphikisana. Umsebenzi ukukhombisa idatha yeselula yokuqala yekholomu yokuqala engxenyeni yokuqala yekholomu ehlukile esebenzisa ifomula efundwayo.
- Khetha isici sekholomu esingenalutho lapho sihlela ukufaka ifomula. Chofoza kusithonjana "Faka umsebenzi".
- Ifasitela iqala. Amakhosi omsebenzi. Hambisa kusigaba "Izixhumanisi nezigaba". Kusuka ohlwini, khetha inani "DVSSYL". Chofoza inkinobho "Kulungile".
- Iwindi le-opharetha ocacisiwe lusiwe. Ensimini I-Link Link kufanele ucacise ikheli lesici eshadini, okuqukethwe okuzovela kukho. Yiqiniso, ingangena ngesandla, kodwa kuyoba usizo nakakhulu ukwenza okulandelayo. Setha isikhombisi ensimini, bese uchofoza inkinobho yegundane lesokunxele kulesi sici esilandelayo kushidi. Njengoba ubona, ngokushesha ngemva kwalokhu, ikheli lakhe liboniswe ensimini. Bese kusuka ezinhlangothini zombili ukhethe isixhumanisi ngezingcaphuno. Njengoba sikhumbula, lokhu kuyisici sokusebenza ngempikiswano yale fomula.
Ensimini "A1", njengoba sisebenza ngohlobo olujwayelekile lwezixhumanisi, singafaka inani "TRUE"noma ungayishiya engenalutho nhlobo, esizokwenza. Lezi zizoba izenzo ezilinganayo.
Emva kwalokho chofoza inkinobho "Kulungile".
- Njengoba ungabona, manje okuqukethwe kweseli yokuqala yekholomu yokuqala yetafula kuboniswa esakhiweni sephepha lapho ifomula itholakala khona I-FLOSS.
- Uma sifuna ukusebenzisa lolu msebenzi kumaseli atholakala ngezansi, khona-ke kulokhu kuzodingeka sifake ifomula kusigaba ngasinye ngokwehlukana. Uma sizama ukukukopisha ngokusebenzisa uphawu lokugcwalisa noma enye indlela yokukopisha, zonke izakhi zekholomu zizobonisa igama elifanayo. Iqiniso liwukuthi, njengoba sikhumbula, isixhumanisi sisebenza njengengxabano efomini yombhalo (ehlanganiswe ngamanothi okucaphuna), ngakho-ke ayikwazi ukulingana.
Isifundo: I-Excel umsebenzi wizard
Isibonelo sesi-2: ukusetshenziswa komsebenzisi ku-formula eqondile
Futhi manje ake sibheke isibonelo sokusetshenziswa okuvame kakhulu ko-opharetha I-FLOSSuma kuyingxenye yefomula eyinkimbinkimbi.
Sinetafula yanyanga zonke yokuthola ibhizinisi. Sidinga ukubala inani lemali engenayo esikhathini esithile, isibonelo, ngoMashi - ngoMeyi noma ngoJuni - Novemba. Yiqiniso, ukwenza lokhu, ungasebenzisa ifomula elula yokufometha, kodwa kulokhu, uma udinga ukubala umphumela wesikhathi ngasinye, kuzodingeka sishintshe le fomula ngaso sonke isikhathi. Kodwa uma usebenzisa lo msebenzi I-FLOSS kuzokwazi ukuguqula ibanga elifingqiwe, kumaseli athile abonisa inyanga ehambelana nayo. Ake sizisebenzise le ndlela ngokusebenza, kuqala ukubala inani lenkathi kusukela ngo-Mashi kuya ku-Meyi. Lokhu kuzosebenzisa ifomula ngenhlanganisela yama-opharetha SUM futhi I-FLOSS.
- Okokuqala, ngezici ezihlukene kushidi esifaka amagama ezinyangeni zokuqala nokuphela kwenkathi okuzobalwa ngayo, ngokulandelanayo "Mashi" futhi "Kwangathi".
- Manje ake sisho wonke amaseli akukholomu. "Inzuzo"okuzofana negama lenyanga ehambelana nayo. Yilokho, into yokuqala kukholomu "Inzuzo"okuqukethe inani lemali okufanele libizwe "Januwari"okwesibili - "February" nokunye
Ngakho-ke, ukunikeza igama engxenyeni yokuqala yekholomu, ukhethe bese uchofoza inkinobho yesokudla yegundane. Imenyu yomongo ivulwa. Khetha into kuwo "Yika igama ...".
- Igama lokudala igama liqala. Ensimini "Igama" faka igama "Januwari". Awekho izinguquko ezisefasiteleni okudingeka zenziwe, nakuba nje uma ungahlola ukuthi izixhumanisi ezisensimini "Range" ihambelana nekheli leseli eliqukethe inani lemali ngoJanuwari. Emva kwalokho chofoza inkinobho "Kulungile".
- Njengoba ungabona, manje uma lesi sici sikhethiwe, igama layo aliboniswa egameni lewindi, kodwa egameni esilinike lona. Senza ukufana okufanayo nazo zonke ezinye izakhi zekholomu. "Inzuzo"ngokubanika amagama alandelanayo "February", "Mashi", "Ngo-Ephreli" nokunye kuze kufike uDisemba.
- Khetha iseli lapho inani lemikhawulo yekhefu elichaziwe lizoboniswa, bese ukhetha. Bese uchofoza isithonjana. "Faka umsebenzi". Itholakala ngakwesokunxele kwebha yefomula futhi ngakwesokudla kwensimu lapho igama lamaseli liboniswa khona.
- Ewindini esebenziwe Amakhosi omsebenzi hamba kusigaba "Isibalo". Lapho sikhetha igama "SUMM". Chofoza inkinobho "Kulungile".
- Ngemuva kokukwenziwa kwalesi senzo, iwindi le-argument ye-argument ithunyelwe. SUMumsebenzi wakhe okuwukuphela kokubamba lezi zimiso. I-syntax yalo msebenzi ilula kakhulu:
= SUM (inombolo1; inombolo2; ...)Ngokuvamile, inani lezingxabano lingase liphakeme kakhulu 255. Kodwa zonke lezi zimpikiswano ziyafana. Bamele inombolo noma izixhumanisi zeseli lapho le namba iqukethe khona. Zingaba ngesimo sefomula eyakhelwe ngaphakathi ebala inani elifunayo noma amaphuzu ekhelini leshidi leshidi lapho lifakwe khona. Kule mbandela yomsebenzi owakhelwe ngaphakathi ukuthi opharetha uzosetshenziswa. I-FLOSS kulokhu.
Setha isikhombisi emkhakheni "Number1". Bese uchofoza isithonjana ngesimo soxantathu oluguquguqukile ngakwesokudla kwenkambu yegama lebanga. Uhlu lwemisebenzi esanda kusetshenziswa kakhulu luboniswa. Uma kukhona igama phakathi kwabo "DVSSYL"bese uchofoza ngokushesha ukuze uhambe iwindi lempikiswano yalo msebenzi. Kodwa kungenzeka ukuthi kulolu hlu ngeke uwuthole. Kulokhu, chofoza igama. "Ezinye izici ..." ezansi ohlwini.
- Ifasitela esivele esazijwayele isunguliwe. Amakhosi omsebenzi. Hambisa kusigaba "Izixhumanisi nezigaba" bese ukhetha igama lomqhubi lapho I-FLOSS. Ngemuva kwalesi sinyathelo chofoza inkinobho. "Kulungile" phansi kwefasitela.
- Ifasitelana lokuphikisana lomqhubi liqalisiwe. I-FLOSS. Ensimini I-Link Link ucacise ikheli lesici sephepha eliqukethe igama lwenyanga yokuqala ebangeni elihloselwe ukubala inani. Sicela uqaphele ukuthi kulokhu akudingekile ukuthi uthathe isixhumanisi kumamaki wesikhangiso, kusukela kulokhu, ikheli ngeke libe yizixhumanisi zeseli, kodwa okuqukethwe kwalo, okuvele kunesakhiwo sombhalo (igama "Mashi"). Inkambu "A1" shiya kungenalutho, ngoba sisebenzisa uhlobo olujwayelekile lokuqokwa kwenombolo.
Ngemuva kokuthi ikheli liboniswe ensimini, ungasheshi ukucindezela inkinobho "Kulungile", ngoba lokhu kuyisici esakhiwe, futhi izenzo zayo zihluke ku-algorithm evamile. Chofoza egameni "SUMM" kubha yefomula.
- Ngemva kwalokho sibuyela ewindini lempikiswano SUM. Njengoba ungabona, ensimini "Number1" opharetha ubonisiwe kakade I-FLOSS nokuqukethwe kwalo. Setha isikhombisi ensimini efanayo ngemva komlingisi wokugcina erekhodi. Beka uhlamvu lwekoloni (:). Lo mfanekiso ukhombisa isibonakaliso sekheli leseli leseli. Okulandelayo, ngaphandle kokukhipha isikhombisi kusukela ensimini, chofoza futhi kwisithonjana ngesimo senxantathu ukuze ukhethe imisebenzi. Lesi sikhathi ohlwini lwama-opharetha asanda kusetshenziswa igama "DVSSYL" kufanele kube khona, ngoba sisanda kusebenzisa lesi sici. Chofoza egameni.
- Ifasitelana lokuphikisana lomsebenzisi livula futhi. I-FLOSS. Sifaka ensimini I-Link Link ikheli lezinto kushidi lapho igama lenyanga likhona, eliqeda isikhathi sokukhokha. Futhi, izixhumanisi kufanele zifakwe ngaphandle kwamacaphuno. Inkambu "A1" shiya ungenalutho futhi. Emva kwalokho chofoza inkinobho "Kulungile".
- Njengoba ubona, emva kwalokhu kwenziwa, uhlelo lubala futhi lunikeza umphumela wokwengezwa kwengeniso yenkampani esikhathini esibekiwe (Mashi - Meyi) kwisici esikhethiwe ngaphambili sephepha lapho ifomula ngokwayo ikhona khona.
- Uma sishintsha kumaseli lapho amagama ezinyanga zokuqala nokuphela kwenkathi yokukhokha efakiwe, kwabanye, isibonelo "Juni" futhi "Novemba"khona-ke imiphumela izoshintsha ngokufanele. Kuzongezwa kwinani lemali engenayo esikhathini esibekiwe.
Isifundo: Indlela yokubala inani ku-Excel
Njengoba ungabona, naphezu kokuthi umsebenzi I-FLOSS ayikwazi ukubizwa ngokuthi oyedwa othandwa kakhulu ngabasebenzisi, noma kunjalo, kusiza ukuxazulula izinkinga zokuhluka okuyinkimbinkimbi ku-Excel kulula kakhulu kunalokho okwakungenziwa ngosizo lwamanye amathuluzi. Ngaphezu kwakho konke, lo opharetha uyasiza njengengxenye yamafomula adidayo lapho enza khona inkulumo. Kodwa nokho kufanele kuqashelwe ukuthi wonke amathuba opharetha I-FLOSS Kunzima kakhulu ukuyiqonda. Lokhu kuchaza ukuthandwa okuphansi kwalesi sici esiwusizo phakathi kwabasebenzisi.
