Guqula inombolo ukuya kumbhalo bese ubuya ku-Microsoft Excel

Omunye wemisebenzi ejwayelekile ebhekene nabasebenzisi behlelo lwe-Excel ukuguqulwa kwezinkulumo zamanani ukufometha ifomu futhi ngokuphambene nalokho. Lo mbuzo kaningi kukuphoqa ukuba uchithe isikhathi esiningi kwisinqumo uma umsebenzisi engazi i-algorithm ecacile yezenzo. Ake sibone indlela yokuxazulula izinkinga zombili ngezindlela ezihlukahlukene.

Guqula inombolo ukuya ekubukeni kombhalo

Wonke amaseli e-Excel anesakhiwo esithile esitshela uhlelo ukuthi ubheke kanjani inkulumo. Isibonelo, ngisho noma amadijithali abhalwe kuwo, kodwa ifomethi isethelwe umbhalo, isicelo sizobaphatha njengombhalo ocacile futhi ngeke ukwazi ukwenza izibalo zezibalo ngaleyo datha. Ukuze i-Excel ibone izinombolo ngokufana nenombolo, kumele ifakwe kwishidi leshidi ngefomethi ejwayelekile noma yenombolo.

Ukuqala, cabangela izinketho ezehlukene zokuxazulula inkinga yokuguqula izinombolo zibe ifomu yombhalo.

Indlela 1: Ukufometha nge-menu yemongo

Ngokuvamile, abasebenzisi benza ukufometha kwezinkulumo zezinombolo kumbhalo ngokusebenzisa imenyu yesimo.

  1. Khetha lezo zakhi zeshidi ofuna ukuguqula idatha kulo mbhalo. Njengoba ungabona, kuthebhu "Ikhaya" kubha yamathuluzi ebhodini "Inombolo" Inkambu ekhethekile ibonisa ulwazi ukuthi lezi zakhi zinefomethi evamile, okusho ukuthi izinombolo ezibhalwe kuzo zibonakala njengenombolo.

  2. Chofoza inkinobho yesokudla yegundane ekukhethweni futhi kwimenyu evuliwe ukhethe isikhundla "Fometha amaseli ...".

  3. Ewindini lokufometha elivula, iya kuthebhu "Inombolo"uma bevulekile kwenye indawo. Ebhokisini lesethingi "Amafomu Amanani" khetha isikhundla "Umbhalo". Ukuze ulondoloze izinguquko chofoza "Kulungile " phansi kwefasitela.

  4. Njengoba ubona, ngemuva kwalezi zinto, ulwazi luboniswa ensimini ekhethekile ukuthi amaseli aguqulelwe ekubukeni kombhalo.

  5. Kodwa uma sizama ukubala isamba semali, sizovela esitokeni esingezansi. Lokhu kusho ukuthi ukuguqulwa akuphelelanga. Lena enye ye-chips Excel. Uhlelo aluvumeli ukuqedela ukuguqulwa kwedatha ngendlela enembile kakhulu.

  6. Ukuqedela ukuguqulwa, sidinga ngokuchofoza ngokuphindaphinda kabili inkinobho yegundane lesokunxele ukuze ubeke isikhombisi ngakwesinye isigaba sobubanzi ngokwehlukana bese ucindezela ukhiye Ngena. Ukuze wenze lula umsebenzi, esikhundleni sokuchofoza kabili, ungasebenzisa ukhiye womsebenzi. F2.

  7. Ngemuva kokusebenzisa le nqubo nazo zonke amaseli esifundeni, idatha kuzo kuzobonakala ukuthi lolu hlelo luyizinkulumo, futhi ngenxa yalokho, isamba semali sizoba yizero. Ngaphezu kwalokho, njengoba ubona, ikhoneni elingenhla elingakwesokunxele lamaseli lizobe limibala eluhlaza. Lokhu kuyinkomba engacacile ukuthi izakhi lapho izinombolo zitholakala khona ziguqulwa ekubonisweni kombhalo. Nakuba lesi sici akusiwo ngaso sonke isikhathi futhi kwezinye izimo asikho uphawu olunjalo.

Isifundo: Ungashintsha kanjani ifomethi ku-Excel

Indlela 2: amathuluzi amateyipu

Ungaphinda uguqule inombolo ibe yombono wombhalo usebenzisa amathuluzi ku-tape, ikakhulukazi, usebenzisa insimu ukubonisa ifomethi exoxwe ngenhla.

  1. Khetha izakhi, idatha ofuna ukuyiguqula ekubukeni kombhalo. Ukuba ngaphakathi kuthebhu "Ikhaya" Chofoza kusithonjana ngesimo senxantathu ngakwesokudla kwensimu lapho kuboniswa khona ifomethi. Itholakala ebhokisini lamathuluzi. "Inombolo".

  2. Kuhlu oluvuliwe lwezinketho zokufometha, khetha into "Umbhalo".

  3. Ngaphezu kwalokho, njengendlela yangaphambilini, sibeka ngokuzenzakalelayo isikhombisi kusigaba ngasinye ebangeni ngokuchofoza kabili inkinobho yegundane lesokunxele noma ucindezela ukhiye F2bese uchofoza Ngena.

Idatha ishintshelwe kwinguqulo yombhalo.

Indlela 3: sebenzisa umsebenzi

Enye indlela yokuguqula idatha yezinombolo ukuhlola idatha ku-Excel ukusebenzisa umsebenzi okhethekile, obizwa ngokuthi - Umbhalo. Le ndlela ifanelekile, okokuqala, uma ufuna ukudlulisela izinombolo njengombhalo okholomu ohlukile. Ngaphezu kwalokho, kuzosindisa isikhathi ekuguqulweni uma inani lemininingwane likhulu kakhulu. Ngemva kwakho konke, vumelani ukuthi ukuhamba ngesinye isilwane ebangeni lamakhulu noma izinkulungwane zemigqa akuyona indlela engcono kakhulu yokuphuma.

  1. Setha isikhombisi esithombeni sokuqala ebangeni lapho umphumela wokuguqulwa uzoboniswa khona. Chofoza kusithonjana "Faka umsebenzi"okuyinto eseduze ne-bar yefomula.

  2. Iwindi iqala Amakhosi omsebenzi. Esikhathini "Umbhalo" khetha into "TEXT". Emva kwalokho chofoza inkinobho "Kulungile".

  3. Iwindi lempikiswano ye-Operator ivuleka Umbhalo. Lo msebenzi une-syntax elandelayo:

    = TEXT (inani; ifomethi)

    Iwindi evulekile inezinsimu ezimbili ezihambisana nezimpikiswano ezinikeziwe: "Value" futhi "Fometha".

    Ensimini "Value" Kumelwe ucacise inombolo ezoguqulwa noma ireferensi yeseli lapho itholakala khona. Esikhathini sethu, lokhu kuyoba isixhumanisi se-element yokuqala yebanga lezinombolo ezicutshungulwayo.

    Ensimini "Fometha" Udinga ukucacisa inketho yokubonisa umphumela. Isibonelo, uma singena "0", inguqulo yombhalo yomkhiqizo izoboniswa ngaphandle kwezindawo zedesimali, noma ngabe zisekhodi yomthombo. Uma senza "0,0", umphumela uzoboniswa ngendawo eyodwa yedesimali, uma "0,00"khona-ke ngamabili, njll.

    Ngemuva kokuthi yonke imingcele edingekayo ifakiwe, chofoza inkinobho. "Kulungile".

  4. Njengoba ubona, ukubaluleka kwento yokuqala ebangeni elicacisiwe kuboniswa esitokweni esiyikhethile esigabeni sokuqala salesi siqondiso. Ukuze udlulisele amanye amanani, udinga ukukopisha ifomula ibe yizici eziseduze zeshidi. Setha isikhombisi ekhoneni elingezansi elingezansi lesici esinefomula. I-cursor iguqulwa kumaka wokugcwalisa obukeka njengesiphambano esincane. Cisha inkinobho yegundane lesokunxele bese uhudulela kumaseli angenalutho ahambisana nobubanzi lapho idatha yomthombo ikhona khona.

  5. Manje uchungechunge lonke lugcwele idatha edingekayo. Kodwa akusikho konke. Eqinisweni, zonke izakhi zohlu olusha ziqukethe amafomula. Khetha le ndawo futhi uchofoze kwisithonjana. "Kopisha"elitholakala kuthebhu "Ikhaya" ebha yamathuluzi ebhande "Ibhodi lokunamathisela".

  6. Ngaphezu kwalokho, uma sifuna ukugcina imigqa yombili (yokuqala nokuguqulwa), asikhiphi ukukhethwa kusuka esifundeni equkethe amafomula. Chofoza kuso nge inkinobho yegundane kwesokudla. Uhlu lwesenzo lomongo luqalisiwe. Khetha isikhundla kuso "Namathisela Okukhethekile". Phakathi kokukhethwa kwesenzo ohlwini ovulayo, khetha "Amanani namafomethi wezinombolo".

    Uma umsebenzisi efuna ukufaka idatha yefomethi yangempela, khona-ke esikhundleni sesenzo esicacisiwe, udinga ukuyikhetha bese uyifaka ngendlela efanayo nangenhla.

  7. Noma kunjalo, umbhalo uzofakwa ebangeni elikhethiwe. Uma ngabe ukhethe ukungena endaweni yomthombo, amaseli aqukethe amafomula angasuswa. Ukuze wenze lokhu, ukhethe, chofoza ngakwesokudla bese ukhetha isikhundla "Sula okuqukethwe".

Kule nqubo yokuguqulwa kungacatshangwa njengeqediwe.

Isifundo: I-Excel Function Wizard

Ukuguqulwa kombhalo kuya kwinombolo

Manje ake sibone ukuthi yiziphi izindlela ongazenza umsebenzi ongenayo, okuwukuthi ukuguqula kanjani umbhalo kwinombolo ku-Excel.

Indlela 1: Guqula ukusebenzisa isithonjana sephutha

Indlela elula futhi esheshayo ukuguqula inguqulo yombhalo usebenzisa isithonjana esikhethekile esibika iphutha. Lesi sithonjana sinesimiso sokumaketha esibhalwe isithonjana esifane nedayimane. Kubonakala uma ukhetha amaseli anamabala aluhlaza ekona elingenhla elingakwesokunxele, esixoxe ngakho ekuqaleni. Lo maka awubonisi ukuthi idatha esitokisini ayiyona iphutha. Kodwa izinombolo ezisesitokisini ezinokubonakala kwemibhalo ziphakamisa izinsolo zohlelo ukuthi idatha ingafakwa ngokungalungile. Ngakho-ke, uma kunjalo, ubaphawula ukuze umsebenzisi akhohlwe. Kodwa, ngeshwa, i-Excel ayinikezi njalo amamaki anjalo, ngisho noma izinombolo zisendaweni yombhalo, ngakho-ke indlela echazwe ngezansi ayifaneleki kuwo wonke amacala.

  1. Khetha iseli equkethe inkomba eluhlaza yephutha elingenzeka. Chofoza kusithonjana esibonakalayo.

  2. Uhla lwezenzo luvulwa. Khetha inani kulo "Guqulela enombolweni.

  3. Kule nto ekhethiwe, idatha izoshintshwa ngokushesha ibe ifomu lezinombolo.

Uma kungenjalo nje kuphela kwezindinganiso ezinjalo zokuguqula ukuguqulwa, kodwa isethi, inqubo yokuguqulwa ingasheshiswa.

  1. Khetha lonke uhla lapho idatha yombhalo. Njengoba ubona, i-pictogram ibonakale eyodwa yendawo yonke, hhayi iseli ngalinye ngokwehlukana. Chofoza kuso.

  2. Uhlu esivele lujwayele kithi luvuleka. Njengesikhathi sokugcina, khetha isikhundla "Guqulela kwinombolo".

Yonke idatha ehleliwe izoguqulwa ekubukeni okucacisiwe.

Indlela 2: Ukuguqulwa usebenzisa iwindi lokufometha

Kanye nokuguqula idatha kusuka ekubukeni kwezinombolo kumbhalo, ku-Excel kukhona ithuba lokuguqula emuva ngokusebenzisa iwindi lokufometha.

  1. Khetha ibanga eliqukethe izinombolo kumbhalo wombhalo. Chofoza inkinobho yesokudla yegundane. Emenyu yomongo, khetha isikhundla "Fometha amaseli ...".

  2. Isebenzisa iwindi lesifomethi. Njengesikhathi sangaphambilini, iya kuthebhu "Inombolo". Eqenjini "Amafomu Amanani" kudingeka sikhethe amanani azoguqula umbhalo ube yinombolo. Lokhu kufaka izinto "Jikelele" futhi "Numeric". Noma yikuphi okukhethayo, lolu hlelo luzobona izinombolo zingene esitokeni njengezinombolo. Yenza ukhethe bese uchofoza inkinobho. Uma ukhetha inani "Numeric"khona-ke engxenyeni efanele yefasitela kuzokwazi ukulungisa ukumelelwa kwenombolo: setha inombolo yezindawo zedesimali ngemuva kwephuzu elidumile, wabeka abadilizi phakathi kwamadijithi. Ngemva kokusetha kwenziwa, chofoza inkinobho. "Kulungile".

  3. Manje, njengokungathi ukuguqula inombolo ibe yombhalo, sidinga ukuchofoza kuwo wonke amangqamuzana, sibeka isikhombisi kuzo ngamunye bese sicindezela Ngena.

Ngemva kokwenza lezi zenzo, wonke amanani webanga elikhethiwe aguqulwa efomini elifunayo.

Indlela 3: Ukuguqulwa usebenzisa amathuluzi we-tape

Ungaguqula idatha yombhalo ibe idatha yedatha usebenzisa insimu ekhethekile ebhokisini yethuluzi.

  1. Khetha ibanga okufanele liguqulwe. Iya kuthebhu "Ikhaya" kwi-tape. Chofoza ensimini ngokukhetha ifomethi eqenjini "Inombolo". Khetha into "Numeric" noma "Jikelele".

  2. Okulandelayo sichofoza kuwo wonke amaseli wesifunda esiguqulwe besebenzisa okhiye F2 futhi Ngena.

Amanani ebangeni azoguqulwa kusuka embhalweni kuya ezinombolo.

Indlela 4: usebenzisa ifomula

Ungasebenzisa amafomula akhethekile ukuguqula amagugu wombhalo kumanani ezinombolo. Cabanga ukuthi ungakwenza kanjani lokhu ngokusebenza.

  1. Esitokisini esingenalutho, esitholakala kuleso sigaba sokuqala okufanele sishintshwe, faka uphawu "olulinganayo" (=) futhi kukhishwe kabili (-). Okulandelayo, ucacise ikheli lento yokuqala yebanga lokuguqulwa. Ngakho, ukuphindaphinda kabili ngenani kwenzeka. "-1". Njengoba wazi, ukuphindaphinda kwe- "minus" nge "minus" kunika "plus". Okusho ukuthi, esitokisini esilitshe, sithola inani elifanayo ekuqaleni, kodwa ngesimo senombolo. Le nqubo ibizwa ngokuthi ukungaboni kahle kokubili kanambambili.

  2. Sicindezela ukhiye Ngenaemva kwalokho sithola inani eliguqulwe lokuguqulwa. Ukuze usebenzise le fomula kuwo wonke amanye amaseli ebangeni, sisebenzisa uphawu lokugcwalisa, esasilisebenzise ngaphambili umsebenzi Umbhalo.

  3. Manje sinebanga eligcwele amanani namafomula. Khetha bese uchofoza inkinobho. "Kopisha" kuthebhu "Ikhaya" noma sebenzisa isinqamuleli Ctrl + C.

  4. Khetha indawo yomthombo bese uchofoza kuso nge inkinobho yegundane kwesokudla. Uhlu olwenziwe kulesi simo luza amaphuzu "Namathisela Okukhethekile" futhi "Amanani namafomethi wezinombolo".

  5. Yonke idatha ifakwa efomini esiyidingayo. Manje ungakwazi ukususa ibanga lokuhamba lapho ifomula elibi elibanjwe kabili litholakala khona. Ukuze wenze lokhu, khetha le ndawo, chofoza ngakwesokudla imenyu yesimo bese ukhetha isikhundla kuso. "Sula okuqukethwe".

Ngendlela, ukuguqula amanani ngale ndlela, akudingekile ukusebenzisa ukuphindaphinda kabili kuphela "-1". Ungasebenzisa noma yikuphi ukusebenza kwe-arithmetic okungaholeli ekuguqulweni kwamagugu (ukuhlanganisa noma ukukhipha kwezinga, ukwenziwa kokwakhiwa kwezinga lokuqala, njll)

Isifundo: Indlela yokwenza ngokuzenzekelayo ku-Excel

Indlela 5: Ukusebenzisa ukufakwa okukhethekile.

Indlela elandelayo yokusebenza ifana kakhulu neyaphambilini kanye nokwahlukana okuwukuthi akudingi ukwakha ikholomu eyengeziwe yokuyisebenzisa.

  1. Faka idijithi kunoma iyiphi iseli elingenalutho kushidi "1". Bese ukhetha futhi uchofoze kwisithonjana esivamile. "Kopisha" kwi-tape.

  2. Khetha indawo eshidi ofuna ukuyiguqula. Chofoza kuso nge inkinobho yegundane kwesokudla. Emenyu evula, chofoza kabili entweni "Namathisela Okukhethekile".

  3. Esikhathini efakwe efasiteleni efakiwe, setha inkinobho ebhodini "Ukusebenza" esimweni "Yandisa". Ukulandela lokhu, chofoza inkinobho "Kulungile".

  4. Ngemuva kwalesi senzo, zonke izindinganiso zendawo ekhethiwe zizoguqulwa zibe izinombolo. Manje, uma ufisa, ungasusa inombolo "1"esasisebenzisela ukuguqulwa.

Indlela 6: Sebenzisa Ithuluzi Lombhalo Wombhalo

Enye indlela yokuguqula umbhalo ube ifomu lezinombolo ukusebenzisa ithuluzi. "Amakholomu wombhalo". Kunengqondo ukuyisebenzisa uma esikhundleni se-comma ichashazi lisetshenzisiwe njengehlukanisi yedesimali, futhi i-apostrophe isetshenziselwa ukwahlukana kwamadijithi kunesikhala. Lokhu okuhlukile kufakwa ku-Excel yolimi lwesiNgisi njengamanani, kodwa ngolimi lwesiRussia version yalolu hlelo wonke amanani aqukethe izinhlamvu ezingenhla abonakala njengombhalo. Yiqiniso, ungakwazi ukuphazamisa idatha ngesandla, kodwa uma kuningi, kuzothatha isikhathi esithile esibalulekile, ikakhulukazi njengoba kungenzeka ukuthi isisombululo esikhulu kakhulu kunenkinga.

  1. Khetha ishidi leshidi, okuqukethwe ofuna ukuguqula. Iya kuthebhu "Idatha". On amathuluzi we-tape ku-block "Ukusebenza nedatha" chofoza kusithonjana "Umbhalo ngamakholomu".

  2. Iqala I-Wizard yombhalo. Ewindini lokuqala, phawula ukuthi ukushintshwa kwefomethi yedatha kusethelwe "Unlimited". Ngokuzenzakalelayo, kufanele kube kulesi sikhundla, kodwa ngeke kube yinto engafanele ukuhlola isimo. Bese uchofoza inkinobho. "Okulandelayo".

  3. Ewindini lesibili sishiya konke okungaguquki bese uchofoza inkinobho. "Okulandelayo."

  4. Kodwa emva kokuvula iwindi lesithathu Amasevisi wombhalo udinga ukucindezela inkinobho "Imininingwane".

  5. Iwindi lamalungiselelo okungeniswa kwamathekthi angeziwe avula. Ensimini "Umhlukanisi wengxenye yonke kanye nengxenye" setha iphuzu, nasensimini "Umhlukanisi" - apostrophe. Bese ukhetha okukodwa ku-inkinobho. "Kulungile".

  6. Buyela ewindini lesithathu Amasevisi wombhalo bese uchofoza inkinobho "Yenzelwe".

  7. Njengoba ubona, ngemuva kokwenza lezi zenzo, izinombolo zithatha isakhiwo esasijwayele inguqulo yesiRussia, okusho ukuthi ngesikhathi esifanayo baguqulwa kusuka kudatha yombhalo baba idatha yezinombolo.

Indlela 7: Ukusebenzisa ama-Macros

Uma uvame ukuguqula izindawo ezinkulu zedatha kusukela embhalweni kuya kufomethi yezinombolo, ngakho-ke kunengqondo ngale njongo ukubhala i-macro ekhethekile ezosetshenziswa uma kunesidingo. Kodwa ukuze wenze lokhu, okokuqala, udinga ukufaka ama-macros nephaneli yonjiniyela ku-version yakho ye-Excel, uma lokhu kungakenziwa.

  1. Iya kuthebhu "Unjiniyela". Chofoza kusithonjana ku-tape "Visual Basic"okubanjwe eqenjini "Ikhodi".

  2. Igijima umhleli ojwayelekile we-macro. Sishayela noma sikukopishe le nkulumo elandelayo kuyo:


    I-Sub Text_in ()
    Ukukhetha.NumberFormat = "Okujwayelekile"
    Ukukhetha.Value = Ukukhetha.Value
    Qedela ngaphansi

    Ngemuva kwalokho, vala umhleli ngokucindezela inkinobho yokuvala evamile ekhoneni elingenhla eliphezulu lewindi.

  3. Khetha i-fragment eshadini elidinga ukuguqulwa. Chofoza kusithonjana Macroselitholakala kuthebhu "Unjiniyela" eqenjini "Ikhodi".

  4. Iwindi lama macros elirekhodiwe kuhlelo lwakho lwelo hlelo luvulwa. Thola i-macro negama "Umbhalo"ukhethe bese uchofoza inkinobho Qalisa.

  5. Njengoba ubona, ngokushesha uguqula inkulumo yombhalo ibe ifomethi yenombolo.

Isifundo: Indlela yokudala i-macro ku-Excel

Njengoba ubona, kunezinketho ezimbalwa zokuguqula izinombolo ku-Excel, ezirekhodiwe kunombolo yezinombolo, ekufomeni kwombhalo nakwehlukile. Ukukhetha indlela ethile kuxhomeke ezicini eziningi. Okokuqala, lo msebenzi. Ngemuva kwakho konke, isibonelo, ukuguqula masinyane imibhalo yombhalo nabathumeli bezinye izizwe zibe yizinombolo eyodwa kuphela ngokusebenzisa ithuluzi "Amakholomu wombhalo". Isici sesibili esithonya ukukhethwa kokukhethwa kukho yivolumu kanye nemvamisa yokuguqulwa okwenziwe. Isibonelo, uma uvame ukusebenzisa ukuguqulwa okunjalo, kunengqondo ukubhala i-macro. Futhi into yesithathu yi-convenience ngayinye yomsebenzisi.

Okuthunyelwe Popular

https://termotools.com zu.termotools.com © I-Excel 2024