Isibonelo umsebenzi I.
Ake siqale ngokufaka umsebenzi onengqondo ku-Excel, enokwakheka okulula - I. Isetshenziselwa ukudala ifomula enemibandela, lapho kuhlolwe khona amaseli owodwa noma amaningi ukuze alandelwe ukuhambisana. Uma behlangabezana nazo zonke lezi zindlela, okuholele eqinisweni.
- Njengokujwayelekile, kusukela ekuqaleni kuyadingeka ukumemezela umsebenzi ngokufaka = futhi.
- Ungakhohlwa ukuletha ukuvulwa nokuvala amabakaki ayindilinga ukuze kube nezinkinga ezengeziwe ngokunemba kokubhala komsebenzi.
- Ngomsebenzi onemibandela futhi kufanele ucacise inani elinengqondo elihlotshaniswa neseli. Ungakwenza lokhu ngokumane uchofoze inani elidingekayo ngemuva kokumemezela umsebenzi.
- Okulandelayo setha inani elinengqondo: ngokwesibonelo, iseli le-C3 kumele libe ngaphansi kwama-424, abhalwe njenge-C3
- Beka isibonakaliso esithi ";", uhlukanisa izimpikiswano, bese ufaka inani elifanayo elinengqondo, kodwa ngesinye isimo. Qhubeka nokucacisa izimpikiswano ngendlela efanayo, ungakhohlwa ngohlukanisi olucacisiwe. Lapho zonke izimo ezinengqondo ziqoshwa, cindezela u-ENTER ukuze uqinisekise umsebenzi.
- Uma inani leseli elibekiwe lifana wonke amanani acacisiwe, "iqiniso" livela etafuleni.
- Siletha izinguquko ezincane kwifomula uqobo ukuze sithole "amanga". Lo mphumela uvela uma okungenani eyodwa yalezi zinkulumo ayihambelani neqiniso.
Ukubhekana nokuthi umsebenzi uzodinga futhi ngeke ube nzima ngisho nomuntu omusha owakha itafula lawo ngokugqama okokuqala. Ngokubhaliwe kwezimpikiswano, kufanele futhi kube nezinkinga, ngoba ziphindwa futhi azinakho izinto ezintsha kwirekhodi.
Umsebenzi wesibonelo noma
Uma ifomula elinemibandela elinemibandela ivele idale nje ngomsebenzi onengqondo futhi yaveza ukubizwa kwazo zonke lezi zingxabano, kuyacaca ukuthi noma iqiniso lizokhipha ebusweni okungenani okungenani. Ukwakhiwa kwefomula enjalo kungaba wusizo kulezo zimo lapho kunezinqubo eziningana zokuhlola zamanani athile, ezinye zazo zigculisayo. Ukubhala ifomula ngomsebenzi noma okwenzeka njengoba nje bekunjalo nenketho edlule.
- Memezela = noma () bese uhambisa isikhombisi kubakaki oyindilinga.
- Faka ngesandla iseli ukuze uthole inkulumo enengqondo noma chofoza kuyo etafuleni.
- Setha inani lokuqala elinengqondo futhi ulethe i-PROUKSAIL SISEPALI.
- Yenza okufanayo ngamanani wesibili nalandelayo anengqondo, ungakhohlwa ukuhlukanisa yonke impikiswano.
- Kulesi sikrini esilandelayo, kungabonakala ukuthi inani leseli elikhethiwe lanelisa kuphela impikiswano eyodwa, okusho ukuthi iqiniso lizovela esikrinini.
Inani lamanga livela kuphela kulezo zimo lapho kungekho lwalezi zinto ezinengqondo ezihambelana nenombolo noma umbhalo esitokisini.
Isibonelo umsebenzi ne.
Umsebenzi wokugcina akayona - wenza iqiniso kuphela ezimweni lapho inani elithile elinengqondo lingahambelani neseli, eliqondakala yigama lomsebenzi.
- Irekhodi laso liqala futhi = hhayi (), njengoba kwenzeka ngayo yonke imisebenzi.
- Okulandelayo, faka inani elinengqondo usebenzisa noma yimiphi imisebenzi yezibalo edingekayo ekubaleni.
- Ngemuva kokuqinisekiswa, naka umphumela. Kunengqondo ukuthi inani elithathwe yithi ncamashi alihambelani nelika-100,000, ngakho-ke, ifomula izohola iqiniso.
- Uma sicacisa inani eliqondile, inkulumo enengqondo izolunga. Ngokuvumelana nalokho, akukufanele kodwa amanga azovela.
Kusetshenziswa amafomula anemibandela lapho usebenza ngombhalo
Izibonelo ezichazwe ngenhla zaziphakathi kwezinombolo kuphela, kepha akukho okulimazayo ukuze ngizisebenzise futhi kuqhathaniswa nombhalo. Kuyacaca ukuthi kuphela "=" kufanelekile lapha, ngoba okubhaliwe okukodwa akunakuba ngaphansi kolunye, uma kufika enanini lezinhlamvu.
- Ake siqale ngomsebenzi ovele owaziwa futhi, ukungena kombhalo okubukeka kahle njenge = futhi (A2 = "Januwari"). Ungakhohlwa ukuthi umbhalo kufanele uhlale uthathwe izingcaphuno eziphindwe kabili.
- Ngalesi sici, okungenani kufanele uthole amanani amabili anengqondo, ngakho-ke engeza ingxabano yesibili ngerekhodi elifanayo, ungakhohlwa ukubeka ohlukanisi phambi kwalo.
- Sibona ukuthi imibhalo emibili ekhonjisiwe ihambelana nalawo acacisiwe kumaseli, ngakho-ke iqiniso liyavela. Uma okungenani eyodwa yazo ingamanga, umphumela uzoshintsha.
- Okungasho ukuthi mayelana noma, ngoba lapha, njengoba usuvele uyazi, iqiniso liboniswa ngisho nalolo oluhambelana nalo oluningi, nokuqoshwa kwefomula enjalo kunefomu = noma (A3 = "FEBRUARY") . Udinga kuphela ukushintshana amaseli nombhalo.
- Ku-Screenshot elandelayo, ubona ukubona ukuthi ukubhala okukodwa kuphela kulungele ifomula, kepha kuvela umphumela ogculisayo.
- Ngokwehlukana, kufanele futhi ukusho hhayi, ngoba lapha ungacacisa inkulumo eyodwa enengqondo, ngakho-ke lapho uzama ukusetha ezinye izimpikiswano, kuzovela iphutha esikrinini.
Ukuhlanganisa kanye / noma / hhayi uma
Kuwo wonke amafomula anemibandela ase-Excel, asizange sihlabezele kuphela uma. Lesi sici sichaza omunye umbhali wethu ngokufundiswa okugcwele kusixhumanisi esingezansi.
Funda kabanzi: Kusetshenziswa i-Operactor "uma" e-Microsoft Excel
Imvamisa, noma, noma ayisetshenziswanga inqwaba nge-UMA ukuthola amanani achazwe ngesandla futhi angempela. Cabanga ngesibonelo kuphela futhi, ngoba ukuqoshwa kweminye imisebenzi sekuyijwayele wena kanye nesimemezelo sabo ngaphakathi uma kungekho nzima.
- Ukuze uqale, memezela = uma () bese wenza kusebenze isikhombisi ngaphakathi kwabazali.
- Bhala ngokushesha futhi () futhi ungakhohlwa ngalaba amabakaki kuphela, khona-ke ungazivaleli zonke ngemuva kokuthi ifomula ihlanganiswa.
- Ngoba futhi banikeze izimpikiswano eziningana okufanele zizanelise iqiniso.
- Ngemuva kwamabakaki wabeka ";", okusho ukuvalwa kwengxabano yokuqala.
- Bhala inani elifanele liboniswe ngeqiniso, futhi uma kungumbhalo, qiniseka ukuthi ulifaka izingcaphuno.
- Phinda isihlukanisi sokuphikisana futhi bese ucacisa inani lamanga.
- Ngemuva kokuchofoza kukhiye wokufaka, ifomula ngokushesha libonisa umphumela. Kulesi sikrini esilandelayo, kungabonakala ukuthi zonke izinkulumo ziyanelisa futhi ngenxa yalokho, uma inani elishiwo iqiniso liyavela.