OkwamanjeI-Excel isiyithuluzi elibalulekile lanoma yimuphi uchwepheshe ofuna ukwenza ngokugcwele imisebenzi yakhe nokuhlaziya idatha. Phakathi kwemisebenzi eminingi eyinikezayo lolu hlelo, kukhona inketho yokuhlanganisa amanani, okubaluleke kakhulu lapho usebenza ngezibalo ezinembile. Kulesi sihloko, sizohlola ngokuningiliziwe ukuthi singazungeza kanjani ku-Excel kanye nezinketho ezahlukene ezitholakalayo ukuze siqinisekise ukugoqa ngokuya ngezidingo zethu zobuchwepheshe.
1. Isingeniso sokusondeza ku-Excel: okuyisisekelo nezinhlelo zokusebenza
Ukuzungezisa kuwumsebenzi obalulekile ku-Excel osivumela ukuthi silungise amanani ezinombolo abe nenani elifunekayo lezindawo zamadesimali. Kulesi sigaba, sizohlola izinto eziyisisekelo zokuhlanganisa ku-Excel kanye nezinhlelo zayo ezihlukahlukene kuzilungiselelo zobuchwepheshe nezezemfundo. Sizofunda ukusebenzisa lo msebenzi. ngempumelelo ukuthuthukisa izibalo zethu kanye nokwethula ulwazi olunembile.
Okokuqala, kubalulekile ukuqonda ukuthi ukuzungeza kusebenza kanjani ku-Excel. Umsebenzi wokuzungezisa usetshenziselwa ukuzungeza inombolo enani elishiwo lezindawo zamadesimali. Isibonelo, uma sifuna ukuzungeza inombolo 3.1459 ezindaweni ezimbili zamadesimali, i-Excel izosinikeza inani eliyindilinga elingu-3.15. Lokhu kungaba usizo ikakhulukazi lapho sisebenza ngezinombolo ezinkulu noma lapho sifuna ukwenza izibalo zethu zilawuleke.
Ngaphezu kokusetshenziswa kwayo okuyisisekelo, ukuzungeza ku-Excel nakho kungasetshenziswa ezimeni ezahlukahlukene. Isibonelo, ukuzungezisa kuvame ukusetshenziswa ku-accounting ukulungisa amanani ohlobo lwemali ezindaweni ezimbili zamadesimali. Kungase futhi kube usizo ekuhlaziyeni idatha, lapho imiphumela ngokuvamile idinga ukwethulwa ngenani elithile lamadijithi abalulekile. Ukwazi izinhlelo zokusebenza ezahlukahlukene zokusondeza kuzosivumela ukuthi sisisebenzise ngokugcwele lesi sici emisebenzini yethu yansuku zonke.
2. I-syntax eyisisekelo yokuqoqa amanani ku-Excel
Kuyithuluzi eliwusizo kakhulu lokuthola imiphumela enembile nejabulisa ngobuhle kumaspredishithi ethu. I-Excel isinikeza izindlela ezahlukene zokuzungeza amanani ngokuzenzakalelayo, nokho, kubalulekile ukwazi i-syntax eyisisekelo ukuze ukwazi ukulungisa nokwenza ngendlela oyifisayo le miphumela ngokwezidingo zethu.
Indlela evame kakhulu yokuqoqa amanani ku-excel umsebenzi ongu-round. Lo msebenzi uthatha njengempikiswano inombolo esifuna ukuyizungeza kanye nenani lezindawo zamadesimali esifuna ukuzungeza umphumela kuzo. Isibonelo, uma sinenombolo 12.3456 futhi sifuna ukuyizungezisa ezindaweni ezimbili zamadesimali, singasebenzisa ifomula. =UMUZINGO(12.3456,2)Lo mphumela uzobuyisela u-12.35, njengoba idesimali yesithathu inkulu noma ilingana no-5.
Ngaphezu komsebenzi we-ROUND, i-Excel iphinde inikeze eminye imisebenzi ehlobene efana ne-ROUNDUP kanye ne-ROUNDDOWN. Le misebenzi isivumela ukuthi sifinyeze inombolo siye phezulu noma phansi, ngokulandelana. Isibonelo, uma sinenombolo engu-12.3456 futhi sifuna ukuyihlanganisa ifike ezindaweni ezimbili zamadesimali, singasebenzisa ifomula. =UMBHINGO(12.3456,2)Lo mphumela uzobuyisela u-12.35, njengoba idesimali yesithathu inkulu noma ilingana no-5, futhi sifuna ukuhlanganisa.
3. Ungawusebenzisa kanjani umsebenzi we-ROUND ku-Excel
Umsebenzi we-ROUND ku-Excel uyithuluzi eliwusizo kakhulu lokulungisa amanani eseli enani elithile ledesimali. Kungaba usizo ikakhulukazi ezimeni lapho sidinga khona umphumela onembe kakhudlwana ekusebenzeni kwethu kwezibalo. Lapha sizokukhombisa ukuthi kanjani. Igxathu emvakwe gxathu Ungawusebenzisa kanjani lo msebenzi kumaspredishithi akho:
1. Khetha iseli ofuna ukusebenzisa kuyo umsebenzi we-ROUND.
2. Thayipha umbhalo olandelayo kubha yefomula: =REDONDEAR(
3. Okulandelayo, faka inombolo noma iseli ofuna ukuyizungeza. Isibonelo, uma ufuna ukuzungeza inani kuseli A1, ungathayipha A1.
4. Cacisa inani lezindawo zamadesimali ofuna ukuzungeza inani kuzo. Isibonelo, uma ufuna ukuzungeza ezindaweni ezimbili zamadesimali, ungathayipha ,2) ekupheleni kwefomula.
5. Cindezela inkinobho ethi Enter bese iseli lizoveza inani eliyindilinga ngokuya ngemingcele ethile.
Khumbula ukuthi ungasebenzisa futhi umsebenzi we-ROUND ngokuhlanganisa neminye imisebenzi ye-Excel, njenge-SUM noma i-SUBTRACTION. Lokhu kukuvumela ukuthi wenze izibalo eziyinkimbinkimbi ngamavelu ayindilinga. Linga ngamavelu ahlukene namadesimali ukuze uthole imiphumela oyifunayo kumaspredishithi akho.
4. Ukuhlanganisa ku-Excel: Isinyathelo Ngesinyathelo Imiyalelo
Ukuhlanganisa ku-Excel, kunezindlela ezimbalwa zokwenza. Ngezansi kunemiyalelo yesinyathelo nesinyathelo yokwenza lolu hlobo lokusondeza kusipredishithi sakho.
1. Sebenzisa umsebenzi we-ROUNDCEILING: Lo msebenzi uzungeza inombolo ukuya ekuphindaphindeni kwayo okuseduze kwenombolo eshiwo. Ukuze uhlanganise, kufanele ucacise inombolo kanye nokuphindaphinda ofuna ukukufinyeza. Isibonelo, uma ufuna ukuhlanganisa ukuphindaphinda okuseduze kokungu-10, ungasebenzisa ifomula ethi =ROUNDCEILING(A1,10).
2. Sebenzisa umsebenzi othi RUND: Uma nje ufuna ukuhlanganisa inombolo ephelele eseduze, ungasebenzisa umsebenzi othi RUND. Lo msebenzi uzofinyeza inombolo ifike enombolweni ephelele eseduze, kungakhathaliseki ukuthi ingakanani idesimali. Ifomula izoba =ROUND(A1,0).
5. Ukusondeza phansi ku-Excel: izibonelo ezingokoqobo
Ukufinyeza ku-Excel, kunezindlela ezahlukahlukene ezingasetshenziswa kuye ngezidingo zomsebenzisi. Ngezansi, sizokwethula izibonelo ezingokoqobo nezicacile zokuthi ungawusebenzisa kanjani lo msebenzi kusipredishithi.
Ukusebenzisa umsebenzi we-FLOOR
Indlela elula yokuhlehlisa ukusebenzisa uhlelo FLOOR I-Excel. Lo msebenzi ukuvumela ukuthi ufinyeze inombolo uze ufike kunani eliphansi elilandelayo. Ukuyisebenzisa, khetha iseli lapho ofuna ukufaka khona umphumela bese ufaka ifomula elandelayo:
=ISIZASI(inombolo, [ukubaluleka])
Kuphi inombolo yinani ofuna ukulizungeza futhi ukubaluleka inombolo yedesimali ofuna ukwehlisa kuyo. Isibonelo, uma sifuna ukuzungeza inombolo u-3.76 phansi kwenombolo ephelele eseduze, le fomula elandelayo izosetshenziswa:
=ISITEZI(3.76, 1)
Ukusebenzisa umsebenzi we-TRUNC
Enye indlela ewusizo yokufinyeza ku-Excel ukusebenzisa umsebenzi TRUNCAR. Lo msebenzi ususa ingxenye yedesimali yenombolo ngaphandle kokuyisondeza.
Ukuze usebenzise lo msebenzi, mane ukhethe iseli lapho ofuna ukubonisa khona umphumela bese ubhala ifomula:
=TRUNC(inombolo, [amadesimali])
Kuphi inombolo yinani ofuna ukulinciphisa futhi amadesimali inombolo yezindawo zamadesimali ofuna ukuzisusa. Isibonelo, uma sifuna ukunqamula inombolo engu-4.72 ukuze sibonise kuphela izindawo zedesimali ezimbili zokuqala, le fomula elandelayo izosetshenziswa:
=TRUNC(4.72, 2)
Isebenzisa ukufometha ngokwezifiso
Ngokungeziwe kule misebenzi eshiwo ngenhla, kungenzeka futhi ukufinyezwa ku-Excel usebenzisa ukufometha ngokwezifiso. Ukuze wenze lokhu, khetha iseli lapho ofuna ukubonisa khona umphumela, chofoza kwesokudla, bese ukhetha "Fometha Amaseli."
Okulandelayo, chofoza ithebhu "Inombolo" bese ukhetha inketho ethi "Custom". Enkambini ethi "Uhlobo", faka ifomethi elandelayo:
0
Le fomethi izofinyeza inombolo ifike enambeni ephelele eseduze. Isibonelo, uma sifuna ukwehlisa inombolo engu-6.9, izovezwa njengo-6.
6. Ukuzungezisa inombolo ethile yezindawo zamadesimali ku-Excel
Omunye wemisebenzi evamile ku-Excel ukusondeza inombolo enambeni ethile yezindawo zamadesimali. Kwesinye isikhathi, kuyadingeka ukwehlisa ukunemba kwamanani ukuze uwenze kube lula ukuwabuka noma ukwenza izibalo. Kulesi sihloko, uzofunda ukuthi ungazungeza kanjani izinombolo ku-Excel usebenzisa izindlela nemisebenzi ehlukene.
1. Ukuzungezisa ngomsebenzi we-ROUND: Umsebenzi we-ROUND ungomunye wemisebenzi evame ukusetshenziswa kakhulu yokuhlanganisa izinombolo ku-Excel. Ngalo msebenzi, ungacacisa inani lezindawo zamadesimali ofuna ukuzungeza kuzo. Isibonelo, uma unenombolo 12.3456 futhi ufuna ukuyizungezisa ezindaweni ezimbili zamadesimali, sebenzisa ifomula elandelayo: =ROUND(12.3456, 2). Umphumela uzoba ngu-12.35.
2. Ukusondeza phezulu noma phansi: Ngezinye izikhathi, udinga ukuzungezisa inombolo phezulu noma phansi, kungakhathaliseki ukuthi iphoyinti ledesimali likhulu noma lingaphansi kuka-5. Ukuze wenze lokhu, ungasebenzisa imisebenzi ethi ROUNDUP kanye ne-ROUNDDOWN, ngokulandelanayo. Isibonelo, uma unenombolo engu-8.3 futhi ufuna ukuyihlanganisa, usebenzisa ifomula: =ROUNDUP(8.3, 0)Umphumela uzoba ngu-9. Ngokufanayo, uma ufuna ukukusondeza phansi, usebenzisa ifomula: =ROUNDDOWN(8.3, 0). Umphumela uzoba ngu-8.
7. Ungasondeza kanjani enombolweni eseduze ku-Excel
Ukusondeza enombolweni eseduze ku-Excel kuwumsebenzi ovame ukusetshenziswa lapho usebenza nedatha yezinombolo futhi ufuna ukuyenza ibe lula ibe yinani elilawulekayo. Ngenhlanhla, i-Excel inikeza umsebenzi othile wale njongo. Ngezansi, ngizochaza ukuthi isetshenziswa kanjani:
1. Okokuqala, khetha iseli lapho ofuna ukufaka khona ukuzungezisa bese uchofoza kuyo ukuze uyigqamise.
2. Okulandelayo, iya kubha yefomula ye-Excel bese uthayipha okuthi "=" kulandele igama lomsebenzi wokuzungezisa, kuleli cala elithi "ROUND." Isibonelo, uma ufuna ukuzungeza inombolo kuseli A1, ifomula kufanele iqale ngokuthi "=ROUND(A1").
3. Okulandelayo, thayipha ukhefana, "," bese ukhetha inombolo yezindawo zamadesimali ofuna ukuzungeza kuzo. Isibonelo, uma ufuna ukuzungeza ezindaweni ezimbili zamadesimali, thayipha "2." Ifomula ephelele izobukeka kanje: "=UMUZINGO(A1,2)."
8. Ukuzungeza Okunemibandela ku-Excel: Indlela Yokusebenzisa Umsebenzi we-RAND
Ku-Excel, umsebenzi we-RAND usetshenziselwa ukukhiqiza izinombolo ezingahleliwe phakathi kuka-0 no-1. Kodwa kuthiwani uma ufuna ukwenza izinombolo ezingahleliwe ezingaziphindwayo zika-5? Kulapho kufinyelelwa khona okunemibandela ku-Excel. Usebenzisa le nqubo, ungakwazi ukuzungeza izinombolo ezikhiqizwe umsebenzi we-RAND kuziphindaphinda eziseduze zoku-5.
Okulandelayo, ngizokukhombisa ukuthi usetshenziswa kanjani umsebenzi we-RAND kanye nokuzungeza okunemibandela ku-Excel isinyathelo ngesinyathelo:
1. Kuseli elingenalutho, thayipha “=RAND().” Le fomula izokhiqiza inombolo engahleliwe phakathi kuka-0 no-1.
2. Okulandelayo, khetha iseli lapho ofake khona ifomula bese uchofoza kwesokudla. Kumenyu yokudonsela phansi, khetha "Fometha Amaseli."
3. Efasiteleni Lefomethi Amaseli, khetha ithebhu "Inombolo". Ohlwini lwesigaba, khetha okuthi "Custom."
4. Enkambini ethi “Uhlobo”, thayipha okuthi “0;-0;;@” bese uchofoza okuthi “KULUNGILE.”
Uma usulandele lezi zinyathelo, iseli lizobonisa inombolo engahleliwe efinyelelwe ekuphindaphindeni okuseduze kuka-5. Uma ufuna ukukhiqiza izinombolo ezingahleliwe, vele ukopishe ifomula kwamanye amaseli.
Khumbula ukuthi ukuzungezisa okunemibandela ku-Excel kungaba usizo ezimeni lapho udinga ukukhiqiza izinombolo ezingahleliwe ezihambisana nezikhawu noma amaphethini athile. Linga amafomula ahlukene futhi uthole isixazululo esingcono kakhulu sesimo sakho!
9. Amathiphu namasu okuqoqa amanani ku-Excel
Lapho usebenza ngamavelu ezinombolo ku-Excel, kuvamile ukuzithola udinga ukuzungeza lawo manani ukuze uthole imiphumela enembe kakhudlwana. Kulesi sigaba, sizokunikeza amathiphu namaqhinga lokho kuzokusiza ukuhlanganisa amanani ku-Excel kalula nangempumelelo.
Ukuqala, enye yezindlela ezivame kakhulu zokuqoqa amanani ku-Excel umsebenzi we-ROUND. Lo msebenzi usivumela ukuthi sifinyeze inani enambeni ethile yezindawo zamadesimali. Isibonelo, uma sifuna ukuzungeza inombolo 3.14159 ukuya ezindaweni zamadesimali ezi-2, singasebenzisa ifomula. ROUND(3.14159, 2). Leli nani lizofinyezwa libe ngu-3.14.
Elinye iqhinga eliwusizo lokuqoqa amanani ku-Excel ukusetshenziswa kwe-FLOOR kanye nemisebenzi ye-CEILING. Umsebenzi we-FLOOR usivumela ukuthi sifinyeze inombolo siyehle siye kunamba ephelele eseduze noma sehle siye ekuphindaphindeni okuseduze kokubaluleka. Ngakolunye uhlangothi, umsebenzi we-CEILING uzungeza inombolo ifike kunamba ephelele eseduze noma ifike ekuphindaphindeni okuseduze kokubaluleka. Le misebenzi iwusizo ikakhulukazi uma sidinga ukulungisa amanani ngokuya ngemibandela ethile yokusondeza.
10. Ukubaluleka kokusetha ifomethi elungile ngemva kokusondeza ku-Excel
Lapho usebenza nedatha yezinombolo ku-Excel, kuvamile ukuthi udinge ukuzungeza imiphumela yamafomula noma imisebenzi. Nokho, kubalulekile ngokulinganayo ukusungula ukufometha okufanele ngemva kokufinyezwa ukuze uqinisekise ukunemba kwedatha nokwethulwa. Kulesi sigaba, sizohlola ukubaluleka kwalesi sinyathelo nokuthi singasifinyelela kanjani ngendlela efanele. ngempumelelo.
Uma usuqoqe eyakho idatha ku-excel, kungakhathaliseki ukuthi usebenzisa umsebenzi we-ROUND nanoma iyiphi enye ifomula, kubalulekile ukuthi ulungise ukufometha kweseli ukuze ubonise ngokunembile inombolo eyindilinga. Ukuze wenze lokhu, khetha amaseli aqukethe idatha eyindilinga bese usebenzisa ifomethi yenombolo efanele. Ngokwesibonelo, uma idatha yakho bamele amanani emali, ungakhetha ifomethi yemali.
Kubalulekile ukuqaphela ukuthi ngokusungula ifomethi efanele ngemuva kokuqoqa, ungagwema ukungaqondi kahle namaphutha lapho wethula imiphumela abanye abantu. Ngaphezu kwalokho, ukufometha okulungile nakho kuthuthukisa ukufundeka nokuqonda kwedatha ye wenaIsibonelo, uma usebenza ngamanani amancane wedesimali, ukubeka ifomethi yenombolo yedesimali enanini elithile lezindawo zamadesimali kungakusiza ubonise idatha yakho ngokucacile nangokunembile.
11. Izinhlelo zokusebenza ezithuthukisiwe zokusondeza ku-Excel: izibalo zezezimali nezibalo
Ukuzungezisa kuwumsebenzi obalulekile ku-Excel, ikakhulukazi uma kuziwa ekubalweni kwezezimali nezibalo. Kulesi sigaba, sizohlola ezinye izinhlelo zokusebenza ezithuthukile zokusondeza ku-Excel nokuthi kungasiza kanjani ekuphatheni idatha yezinombolo enembayo.
Enye yezinhlelo ezivame kakhulu zokuhlanganisa ku-Excel isekubalweni kwezezimali. Lapho usebenza ngezibalo zezimali, kubalulekile ukuqinisekisa ukuthi imiphumela inembile futhi ifinyezwa ngendlela efanele. Isibonelo, uma sibala inzalo noma izinkokhelo zemalimboleko yanyanga zonke, ukufinyezwa okufanele kungenza umehluko. I-Excel inikeza imisebenzi embalwa yokuhlanganisa, efana ne-ROUNDUP, i-ROUNDUP, ne-ROUNDDOWN, phakathi kokunye, ekuvumela ukuthi ulungise imiphumela ukuze ihambisane nezidingo zakho ezithile.
Ukuzungezisa nakho kubalulekile ekuhlaziyeni izibalo. Ezimweni eziningi, idatha eqoqiwe ingase iqukathe amadesimali noma amanani anembe kakhulu angadingeki ekuhlaziyeni. Ukusebenzisa ukusondeza okufanele kungenza idatha ibe lula futhi yenze kube lula ukuyitolika. Isibonelo, uma ukhiqiza amagrafu noma amashadi, kuyancomeka ukuthi uzungezise amanani ukuze ugweme imfuhlumfuhlu ebonakalayo futhi uthuthukise ukuqonda kwemiphumela. I-Excel ihlinzeka ngemisebenzi efana ne-ROUNDUP kanye ne-ROUNDDOWN esiza kulezi zimo ngokulungisa amanani abe ukuphindaphinda okuthile noma ukugoqa phezulu noma phansi, ngokulandelana.
12. Amaphutha ajwayelekile uma usondeza ku-Excel nokuthi ungawagwema kanjani
Uma usebenza ngezinombolo ku-Excel, kuvamile ukuzungeza amanani ukuze uthole imiphumela ehlanzekile, elula ukuyichaza. Kodwa-ke, ukusondeza ku-Excel kungaholela emaphutheni uma kungenziwanga kahle. Ngezansi kunezibonelo ezithile.
- Ukusondeza okungalungile: Elinye lamaphutha ajwayelekile uma kufinyezwa ku-Excel kwenzeka uma usebenzisa umsebenzi we-ROUND ngokungalungile. Kubalulekile ukuqonda ukuthi lo msebenzi usebenza kanjani nokuthi ungakhetha kanjani izindawo zedesimali ezilungile ukuze ugweme amaphutha. Kunconywa ukusebenzisa umsebenzi we-ROUND onenombolo oyifunayo yezindawo zamadesimali ukuze uqinisekise ukuthi amanani afinyezwa ngendlela efanele.
- Iphutha lokunemba: Elinye iphutha elivamile ukulahlekelwa ukunemba lapho usondeza ku-Excel. Lokhu kwenzeka uma usebenzisa izinombolo ezinezindawo zamadesimali eziningi futhi uzizungelezele ezindaweni ezimbalwa zamadesimali. I-Excel ingase inciphise amanani futhi ingawazungezi ngendlela efanele. Ukuze ugweme leli phutha, kunconywa ukusebenzisa ifomethi efanelekile yamanani bese usetha ukunemba okufunayo ngaphambi kokufinyezwa.
- Ukuzungezisa okungalungile kwemisebenzi: Uma usebenzisa ukusondeza ku-Excel ukwenza izibalo ngemisebenzi, kubalulekile ukuqonda ukuthi le misebenzi iziphatha kanjani izinombolo eziyindilinga. Eminye imisebenzi ingathinteka ngokusondeza futhi ingase inikeze imiphumela engalungile. Kulezi zimo, kunconywa ukuzungeza amanani kuphela ekupheleni kwazo zonke izibalo ukugwema izinkinga ezinembayo.
Kafushane, kubalulekile ukuqaphela lawa maphutha ajwayelekile lapho usondeza ku-Excel futhi uthathe izinyathelo zokuwagwema. Ukusebenzisa umsebenzi we-ROUND ngendlela efanele, ukugwema ukulahleka kokunemba, nokuqonda ukuthi ukuzungeza kuyithinta kanjani imisebenzi kuyizinyathelo ezibalulekile zokuthola imiphumela enembile nethembekile ku-Excel.
13. Ungawenza kanjani ngokuzenzakalelayo ukuzungeza ku-Excel ngamamakhro angokwezifiso namafomula
Ukuzungezisa ngokuzenzakalelayo ku-Excel kungaba umsebenzi owusizo kakhulu futhi ongokoqobo, ikakhulukazi uma usebenza ngamavolumu amakhulu wedatha. Ngenhlanhla, i-Excel inikeza izinketho ezimbalwa zokwenza le nqubo ngokuzenzakalelayo, njengokusebenzisa ama-macros namafomula angokwezifiso. Ngezansi, sizochaza ngezinyathelo ezidingekayo ukuze kwenziwe lokhu kuzenzakalela.
1. Ukusebenzisa amafomula angokwezifiso: I-Excel ikuvumela ukuthi udale amafomula angokwezifiso ukuze uzungeze izinombolo ngokwezidingo zakho ezithile. Isibonelo, uma ufuna ukuzungeza inombolo enombolweni ephelele eseduze, ungasebenzisa ifomula =ROUNDDOWN(A1,0), lapho u-A1 kuyiseli eliqukethe inombolo esifuna ukuyizungeza. Uma sifuna ukuzungeza ukuphindaphinda okuseduze kuka-0.5, singasebenzisa ifomula =UMUZINGO(A1*2,0)/2Lawa mafomula angasetshenziswa kumaseli adingekayo mathupha, kodwa angasetshenziswa futhi ngokuhambisana namamakhro ukuze kusebenze inqubo ngokuzenzakalelayo.
2. Ukudala ama-Macros: I-macro iwukulandelana kwemiyalelo noma imiyalelo engaqoshwa futhi kamuva idlalwe ku-Excel. Ukwenza ukuzungezisa ngokuzenzakalelayo, singakha i-macro eyenza imisebenzi edingekayo kumaseli akhethiwe. Isibonelo, singarekhoda imakhro esebenzisa ifomula yokuqoqa eshiwo ngenhla ku-a ububanzi beseli ethize. Singabe sesinikeza isinqamuleli sekhibhodi noma inkinobho kumamakhro ukuze siyiqalise ngokushesha noma kunini. Ngale ndlela, ukuzungeza kuzokwenziwa ngokuzenzakalelayo ngaso sonke isikhathi lapho sisebenzisa i-macro.
14. Umehluko omkhulu phakathi kwemisebenzi ethi ROUND, ROUNDDOWN, kanye ne-TRUNCATE ku-Excel
Ku-Excel, kuvamile ukuhlangabezana nesidingo sokuhlanganisa izinombolo noma ukunciphisa amanani. Ukwenza le misebenzi, i-Excel inikeza imisebenzi emithathu eyinhloko: RUND, ROUNDDOWN, kanye ne-TRUNCATE. Nakuba zifeza injongo efanayo, kunomehluko oyinhloko phakathi kwazo okubalulekile ukukhumbula.
- ZUZA: Lo msebenzi uzungeza inombolo enombolweni ephelele eseduze. Uma idesimali ilingana noma inkulu kuno-0.5, inombolo ifinyezwa ibe inombolo ephezulu elandelayo; uma ingaphansi kuka-0.5, ifinyezwa ibe inombolo ephansi elandelayo.
- RUND.MINUS: Ngokungafani ne-ROUND, lo msebenzi uhlezi uzungeza inombolo kuze kufike kunamba eseduze. Okusho ukuthi, uma kunedesimali engaphansi kuka-0.5, izokhishwa kungakhathaliseki ukuthi ingaphezulu noma ingaphansi kuka-0.5.
- TUMISA: I-TRUNCATE ivele isuse ingxenye yedesimali yenombolo, ngaphandle kokufinyezwa. Lokhu kusho ukuthi inombolo enqanyuliwe izohlala ingaphansi noma ilingana neyokuqala.
Kubalulekile ukukhumbula lo mehluko lapho usebenzisa lezi imisebenzi ku-Excel, njengoba zingathinta imiphumela yokubala. Isibonelo, uma ukuqoqa okuqondile kuyadingeka, i-ROUNDDOWN akuwona umsebenzi ofanele. Ngakolunye uhlangothi, uma ufuna ukususa amadesimali ngaphandle kokuzungeza, i-TRUNC iyindlela engcono kakhulu.
Sengiphetha, ukusondeza ku-Excel kuyithuluzi eliyisisekelo lokuqinisekisa ukunemba nokwethembeka ekubalweni kwezinombolo okwenziwe. eshidini ukubala. Ngemisebenzi engu-ROUND, ROUNDUP, kanye ne-ROUNDDOWN, abasebenzisi bangalungisa amanani abe nenani elifunekayo lezindawo zamadesimali futhi baqinisekise imiphumela engaguquki nenembile.
Kubalulekile ukugcina imithetho yokuqoqa engqondweni futhi uqonde ukuthi izinombolo eziphozithivu nezinegethivu, kanye namanani akhuphukayo naphansi, kuthinta kanjani ukufinyezwa. Lokhu kuzosivumela ukuthi senze izinqumo ezinolwazi mayelana nendlela yokuhlanganisa kahle idatha.
Ukwengeza, i-Excel inikeza ithuba lokusebenzisa ukuzungezisa okunemibandela, okusivumela ukuthi sibeke indlela ethile yokuhlanganisa izinombolo ngokwezidingo zethu. Lesi sici siwusizo ikakhulukazi uma usebenza namasethi amakhulu edatha futhi sidinga ukuguquguquka okukhulu kwinqubo yokuqoqa.
Kafushane, ukufunda ukuzungeza ku-Excel kusinika inzuzo enkulu lapho sisebenza ngezinombolo futhi senza izibalo ezinembile. Ukwenza kahle le misebenzi kuzosisiza ukuthi sigweme amaphutha futhi sethule ulwazi ngokucacile nangokuqondakalayo.
Ngingu-Sebastián Vidal, unjiniyela wekhompyutha ozifelayo ngobuchwepheshe kanye ne-DIY. Ngaphezu kwalokho, ngingumdali we tecnobits.com, lapho ngabelana khona ngezifundo zokwenza ubuchwepheshe bufinyeleleke kakhudlwana futhi buqonde wonke umuntu.