Indlela Yokubala Amaphesenti ku-Excel

‍ Ubuwazi ukuthi i-Excel ⁢ingaba⁢ithuluzi eliwusizo kakhulu lokubala amaphesenti? Kungakhathaliseki ukuthi udinga ukunquma iphesenti lenani ngokuphathelene nengqikithi, noma uma ufuna ukubala ukunyuka kwamaphesenti noma ukwehla phakathi kwamanani amabili, lolu hlelo lwesipredishithi lukunikeza inhlobonhlobo yamafomula kanye ⁣ nemisebenzi eyenza umsebenzi ube lula. Kulesi sihloko, sizofunda isinyathelo ngesinyathelo kanjani bala amaphesenti ku-Excel, kusukela kumafomula ayisisekelo kuya kwaphambili kakhulu.

Okokuqala, kufanele sikhumbule ukuthi iphesenti inombolo emele ingxenye yengqikithi maqondana ne-100. Ku-Excel, singenza izibalo zephesenti sisebenzisa amafomula nemisebenzi ehlukahlukene eklanyelwe le njongo. Enye yamafomula ayisisekelo futhi asetshenziswa kabanzi yileyo ye iphesenti lenani ngokuphathelene nengqikithi. Ngale fomula, singakwazi ukunquma ngokushesha ukuthi isibalo esisodwa simelela malini ngokuphathelene nesinye.

Enye ifomula ewusizo kakhulu ku-Excel yi- ukubalwa kwamaphesenti okukhula noma ukwehla phakathi kwamanani amabili.⁤ Le fomula isivumela ukuthi sazi ukuthi inani elilodwa lenyuke noma lehle kangakanani ngokuhlobene nelinye, elivezwe ngamaphesenti. Leli thuluzi liwusizo ikakhulukazi ekuhlaziyeni idatha yezezimali noma ekuqhathaniseni ukukhula.

Ukwenza lezi zibalo ku-Excel, kubalulekile ukwazi nokusebenzisa imisebenzi ehlukene ekhona. Singasebenzisa umsebenzi PORCENTAJE ⁣ ukubala iphesenti lomfanekiso ngokuphathelene nengqikithi, noma umsebenzi PERCENTAGE.INCREMENT ukubala ukunyuka kwamaphesenti phakathi kwamanani amabili. Ngaphezu kwalokho, i-Excel iphinde inikeze nezinye izici ezithuthukisiwe njenge SI o ISILINGANISO,⁣ ahlanganiswe namafomula afanelekile, vumela a ukubala okunembile nangempumelelo kwamaphesenti.

Ngamafuphi, i-Excel iyithuluzi elinamandla nelisebenza ngezindlela eziningi calcular porcentajes. Ngamafomula nemisebenzi efanele, singakwazi ukunquma ngokushesha iphesenti lesibalo kwingqikithi, sibale ukukhuphuka kwamaphesenti noma ukwehla phakathi kwamanani amabili, futhi senze ukuhlaziya idatha ngempumelelo. Kulesi sihloko, sizohlola ngayinye yalezi zibalo ngokuningiliziwe, sikunikeze amathuluzi owadingayo ukuze usebenzise ngokugcwele amandla okubala amaphesenti e-Excel.

1. Izici ezibalulekile ze-Excel zokubala amaphesenti

I-Excel iyithuluzi lesipredishithi elisetshenziswa kakhulu elinikeza izici eziningi ezibalulekile zokubala amaphesenti. Omunye wemisebenzi ye-Excel ewusizo kakhulu yokubala amaphesenti umsebenzi we-PERCENTAGE.. Ngalesi sici, ungenza izibalo ezisheshayo nezinembile ukuze uthole ukukhuphuka kwamaphesenti noma ukuncipha. Ngaphandle kwalokho, I-Excel ikuvumela ukuba wenze izibalo zephesenti zazo zombili izinombolo ngazinye nobubanzi bedatha kalula. Ngamafomula alula, ungathola amaphesenti adingekayo ekuhlaziyweni kwedatha, ukulandelela ukuthengisa nanoma yimuphi omunye umsebenzi lapho amaphesenti abalulekile.

Esinye ⁤isici esibalulekile se-Excel ekubaleni amaphesenti ⁤is ithuluzi lokufometha elinemibandela. Ngaleli thuluzi, ungakwazi ukugqamisa ngokuzenzakalela amaseli ahlangabezana nemibandela ethile, ngokusekelwe kumaphesenti athile. Lokhu kukuvumela ukuthi ubuke ngokushesha futhi ngendlela enembile ulwazi olufanele. Isibonelo, ungagqamisa wonke amaseli aqukethe amaphesenti angaphansi kwevelu ethile noma wonke amaseli angaphezu kwephesenti elithile. Lokhu kwenza kube lula ukuhlonza amaphethini namathrendi kudatha, okungaba usizo olukhulu ekwenzeni izinqumo ezibalulekile.

Ngaphezu kwezici namathuluzi ashiwo ngenhla, ‍ I-Excel iphinde inikeze anhlobonhlobo amafomethi ezinombolo ngokwezifiso. okwenza ukusebenza ngamaphesenti kube lula nakakhulu Ungasebenzisa amafomethi wephesenti kudatha ukuze uwabonise njengamaphesenti angempela esikhundleni samadesimali. ⁢Lokhu kwenza kube lula⁤ ukuhumusha izinombolo ngokubukeka futhi kugweme ukudideka.⁢ Ukwengeza, I-Excel ikuvumela ukuthi uguqule ngokushesha amanani wamaphesenti, okuwusizo ikakhulukazi lapho uphatha amasethi amakhulu edatha. Lokhu kuyenza ibe ithuluzi elibalulekile lanoma yimuphi uchwepheshe odinga ukwenza ukuhlaziya izinombolo futhi athole imiphumela enembayo ngendlela yamaphesenti.

2. Amafomula nemisebenzi ewusizo yokubala amaphesenti ku-Excel

Ku-Excel, ukubala amaphesenti kuwumsebenzi ovamile futhi odingekayo ezinhlotsheni eziningi zokuhlaziya idatha. Ngenhlanhla,⁤ I-Excel inikeza izinhlobonhlobo eziningi amafomula awusizo kanye nemisebenzi ukwenza lezi zibalo ngempumeleloLapha sethula amanye amafomula nemisebenzi ewusizo ongayisebenzisa ukuze ubale amaphesenti ku-Excel.

Enye yamafomula ayisisekelo kakhulu wokubala amaphesenti ku-Excel ifomula yephesenti elula. Le fomula isetshenziselwa ukubala iphesenti lenombolo uma kuqhathaniswa nenye inombolo Ukuze usebenzise le fomula, mane uhlukanise inombolo ofuna ukuyibala ngesamba bese uphindaphinda umphumela ngo-100. Isibonelo, uma ufuna ukubala iphesenti. yokuthengiswa kwanyanga zonke maqondana nezindali zonyaka, ungasebenzisa ifomula =Nyanga zonke/Ngonyaka*100.

Omunye umsebenzi owusizo wokubala amaphesenti ku-Excel umsebenzi we-PERCENTAGE. Lolu hlelo lokusebenza lukuvumela ukuthi uthole iphesenti lenombolo maqondana nenye inombolo ngaphandle kokubala okwenziwa ngesandla Ukusebenzisa lolu hlelo, mane nje ufake uhlelo =PERCENTAGE(inombolo, isamba) ⁤lapho "inombolo" kuyinani ofuna ukubala khona iphesenti futhi "ingqikithi" iyinani eliphelele okuzosuselwa kulo ukubala kwephesenti.

3.⁢ Avezwa kanjani amaphesenti njengamafrakshini noma⁤ amadesimali ku-Excel

Ukuze uveze amaphesenti njengamafrakshini ku-Excel, ungasebenzisa umsebenzi othi “FRACTION”. Lo msebenzi ukuvumela ukuthi uguqule iphesenti libe ingxenyena ethile enefomethi efanelekile, isibonelo, uma unenani elingu-50% futhi ufuna ukuliveza njengengxenye ku-Excel, uvele ufake ifomula elandelayo kuseli oyifunayo. =ISIQEPHU(50%). Umphumela uzoba ngu-1/2, okuyi-fraction elingana no-50%.

Mayelana namadesimali, i-Excel inikeza umsebenzi othi “DECIMAL”. Lo msebenzi uguqula iphesenti libe yidesimali usebenzisa ifomethi efanelekile. Uma unenani elingu-75% futhi ufuna ukuliveza ⁤njengedesimali ku-Excel, kufanele nje ufake⁢ ifomula elandelayo kuseli oyifunayo: =DECIMAL(75%). Umphumela uzoba ngu-0.75, okuyidesimali elingana no-75%.

Enye indlela yokuguqula amaphesenti abe amafrakshini noma amadesimali ku-Excel ukusebenzisa opharetha bezibalo. Uma unephesenti futhi ufuna ukuliguqulela libe yingxenyana, vele uhlukanise iphesenti ngo-100 futhi wenze ingxenyana ibe lula uma kunesidingo. Isibonelo, uma ufuna ukuveza u-25% njengengxenye ku-Excel, ungathayipha ifomula elandelayo kuseli oyifunayo: =25/100.. Ngemva kwalokho, ungenza ingxenyana ibe lula usebenzisa ukusebenza kwezibalo uma kunesidingo. Uma ukhetha ukuveza iphesenti njengedesimali, ungeqa isinyathelo sokwenza ingxenye ibe lula futhi umane uhlukanise ngo-100. Isibonelo, ukuze ubale u-25% njengedesimali, ungabhala ifomula. =25/100 ngqo⁢ kuseli oyifunayo.

4. Ukusebenzisa izici ezithuthukisiwe zokufometha kwamaseli ku-Excel

Ku-Excel, izici ezithuthukisiwe zokufometha kwamaseli zikuvumela ukuba wenze izibalo zephesenti ngendlela efanele futhi enembile. Lezi zici zifaka phakathi ukusetshenziswa kwamafomula ngokwezifiso, imisebenzi, namafomethi.,⁣ lokho kuzokusiza wenze izibalo ezihlukene kanye nokuhlaziya idatha Ngezansi, sizokukhombisa ezinye zezindlela ezivame kakhulu⁢ zokubala amaphesenti ku-Excel nokuthi ungenza kanjani okuningi ngalezi zici ezithuthukisiwe.

1. Bala iphesenti lenombolo: Ukuze ubale iphesenti⁢⁢ inombolo ku-⁢Excel, ungasebenzisa ifomula elandelayo: “=(inombolo*amaphesenti)/100”. Isibonelo, uma ufuna ukubala u-20% wenombolo, ungasebenzisa ifomula ethi “=A1*20/100”, lapho u-A1 kuyiseli eliqukethe inombolo. Ungasebenzisa futhi umsebenzi we-PERCENTAGE, okwenza ukubala kube lula. Ukwenza lokhu, kufanele ubhale “=PERCENTAGE(inombolo,⁢ iphesenti)”.

2. Landelela izinguquko zamaphesenti: Uma udinga ukulandelela izinguquko zamaphesenti ochungechungeni lwamanani, i-Excel inikeza umsebenzi we-PERCENTCHANGE. Lo msebenzi⁣ ikuvumela ukubala amaphesenti ⁢oshintsho phakathi kwamanani amabili. Ngokwesibonelo, ungasebenzisa okuthi “=PERCENT.CHANGE(A1, B1)” ukuze ubale ushintsho lwephesenti phakathi kwevelu kuseli A1 kanye nenani elikuseli B1. Ukwengeza, ungasebenzisa amafomethi angokwezifiso ukuze ugqamise izinguquko ezinhle nezingezinhle, wenze idatha ibe lula ukuyitolika.

3. Qhathanisa amaphesenti: Uma ufuna ukuqhathanisa amaphesenti amaningi ku-Excel, ungasebenzisa ukufometha kwedatha okunemibandela. Lesi sici sikuvumela ukuthi usebenzise amafomethi ahlukene ngokusekelwe kumanani eseli. Isibonelo, ungagqamisa amaphesenti aphezulu kokuluhlaza kanye namaphesenti aphansi ngokubomvu. Ukwengeza, ungasebenzisa umsebenzi we-MAX kanye no-MIN ukuze uthole iphesenti eliphezulu kakhulu neliphansi ochungechungeni lwedatha, ngokulandelanayo. Lokhu kuzokuvumela ukuthi ubone ngokushesha amanani aphakeme futhi wenze ukuqhathanisa okubonakalayo okusebenzayo.

I-Excel inikeza izici eziningi ezithuthukile zokufometha amaseli ezikuvumela ukuthi wenze izibalo zephesenti. ngempumelelo futhi uthuthukise isethulo yedatha yakho. Ukusebenzisa lezi zici kuzokusiza wenze ukuhlaziya okunembe kakhudlwana futhi wenze izinqumo ezingcono ngokusekelwe kudatha.Khumbula ukusebenzisa amafomula nemisebenzi ukuze ubale amaphesenti, ulandelele izinguquko zamaphesenti, futhi uqhathanise amaphesenti. Futhi, ungakhohlwa ukusebenzisa amafomethi edatha anemibandela ukuze ugqamise amanani abalulekile futhi wenze idatha ihumusheke kalula.

5. Izibalo zephesenti ezinereferensi yeseli ehlobene nephelele ku-Excel

1. Amaphesenti akhuphuka noma ancipha: Uma udinga ukubala ukukhuphuka kwamaphesenti noma ukwehla phakathi kwamanani amabili ku-Excel, ungakwenza ngokushesha futhi kalula usebenzisa amafomula. Ukuze uthole ukukhuphuka kwephesenti, susa inani lokuqala enanini lokugcina, hlukanisa umphumela ngenani lokuqala, bese uphindaphinda ngo-100. Isibonelo, uma unenani lokuqala lika-1000 kanye nenani elingu-1500, ekupheleni kuka-XNUMX, ifomula izoba: (1500-1000)/1000*100. Ngale ndlela, uzothola ukukhuphuka kwephesenti. Uma ufuna ukubala ukwehla kwephesenti, mane uguqule ukuhleleka kwamanani kufomula.

2. Ukubala⁤ a porcentaje de un total: Ngokuvamile, sidinga ukubala⁤ iphesenti elithile yenani eliphelele ku-Excel. Ukuze wenze lokhu, ungasebenzisa ifomula yephesenti ejwayelekile. Okokuqala, hlukanisa inani ⁤ufuna ukubala iphesenti ngenani eliphelele bese uphindaphinda ka-100. Ngokwesibonelo, uma ufuna ukubala u-20% yenani eliphelele⁤ka-500, ifomula izoba ukuthi: (20/100)*500. Ngalokhu, uzothola umphumela wokubala kwephesenti oyifunayo. Le nqubo ingaba usizo ezimweni eziningi zansuku zonke, njengokubala isaphulelo noma ingxenye elinganayo yesabelomali ku-Excel.

3. Amaphesenti asebenzisa izinkomba⁢ zamaseli ahlobene kanye⁢ aphelele: Lapho usebenza ngamaphesenti ku-Excel, kuvamile ukuthi kusetshenziswe amareferensi eseli ukwenza izibalo zibe namandla kakhulu. . Vele ukhethe iseli⁢ lapho ufuna ukubonisa khona umphumela futhi usebenzise ifomula yephesenti⁤ usebenzisa izinkomba zeseli⁢. Ngakolunye uhlangothi, uma ufuna ukulungisa iseli ethile ukuze ingashintshi lapho uhudula ifomula, ungasebenzisa ireferensi yeseli eliphelele. Lokhu kufezwa ngokubeka uphawu lwedola ($) ngaphambi kohlamvu lwekholomu nenombolo yomugqa yeseli ofuna ukulisetha. Lokhu kubaluleke kakhulu uma unetafula elinedatha ⁢futhi ufuna ukusebenzisa ifomula yephesenti elifanayo kumaseli ahlukene ⁢kukholamu. Ngalawa masu, izibalo zephesenti ku-Excel⁢ ziba zisebenza kahle futhi ziguquguquke.

6. Ukusebenzisa amashadi namathebula e-pivot ukuze uhlaziye futhi ubone ngeso lengqondo amaphesenti ku-Excel

Ku-Excel, i- ukusetshenziswa kwamagrafu namathebula e-pivot ⁢iyithuluzi ⁤elinamandla hlaziya futhi ubone ngeso lengqondo amaphesenti idatha evela ku indlela ephumelelayo.‍ Amagrafu namathebula aguqukayo asivumela ukuthi sethule ulwazi ngendlela ecacile neqondakala kakhudlwana, okwenza kube lula ukwenza izinqumo ngokusekelwe kumaphesenti. Kungakhathaliseki ukuthi senza ezezimali, ukuthengisa, nanoma yiluphi olunye uhlobo lokuhlaziya idatha, i-Excel isinika amathuluzi adingekayo ukuze senze lezi zibalo futhi sizethule ngokubuka.

Ngoba bala amaphesenti ku-⁤Excel, singasebenzisa amafomula nemisebenzi ehlukahlukene ezosisiza sithole imiphumela esiyifunayo. Enye yezindlela ezivame kakhulu zokubala amaphesenti ukusebenzisa umsebenzi porcentaje. Lo msebenzi usivumela ukuba sibale ngokushesha⁤ iphesenti lenombolo ngokuhlobene⁢ nenye inombolo. Futhi singasebenzisa ifomula yephesenti, ehlanganisa ukuhlukanisa inombolo esifuna ukubala iphesenti ngenani eliphelele bese siphindaphinda ngo-100. Lezi ezinye zezindlela esingabala ngazo amaphesenti ku-Excel .

Uma sesibale amaphesenti, singasebenzisa amagrafu namathebula e-pivot ngoba hlaziya futhi ubone ngeso lengqondo lolu lwazi ngendlela ephumelela kakhudlwana. Amashadi ⁢asivumela ukuthi simelele amaphesenti ngendlela⁢ yamabha, imigqa noma⁣⁣ ophaya, okwenza kube lula ukuhlonza amaphethini namathrendi. Ngakolunye uhlangothi, amathebula e-pivot asivumela ukuthi sihlunge futhi sihlaziye idatha ngokusekelwe kumibandela ehlukene, okusisiza siqonde kangcono amaphesenti nobudlelwano bawo nezinye izici. Lawa mathuluzi awusizo kakhulu kunoma ubani odinga ukuhlaziya futhi ethule amaphesenti ku-Excel.

7. Amathiphu namasu okuxazulula izinkinga ezivamile lapho ubala amaphesenti ku-Excel

.

Ku-Excel, ukubala amaphesenti kuwumsebenzi ovamile kodwa kungaletha izinselele. Lapha ngethula ezinye amathiphu namasu ngoba ukuxazulula izinkinga okuvamile Ongase ubhekane nakho lapho ubala amaphesenti ku-Excel:

1. Fometha kahle amaseli: Ngaphambi kokuba uqale ukubala amaphesenti, qiniseka ukuthi uyawenza fometha amaseli ngendlela efanele. Ungakwenza lokhu ngokukhetha amaseli owafunayo, uchofoze kwesokudla bese ukhetha inketho ethi “Fometha Amaseli”. Bese, khetha isigaba "Iphesenti" ⁢bese uchaza inombolo yezindawo zamadesimali ofuna ukuzibonisa.

2. Sebenzisa ifomula efanele: I-Excel inikeza okuningi amafomula ukubala amaphesenti. Ifomula eyisisekelo ithi =inani/inani*100, lapho “inani” kuyinani ofuna ukuliguqulela libe iphesenti futhi “inani” kuyinani eliphelele okubalwa ngalo amaphesenti. Kodwa-ke, khumbula ukuthi akhona amanye amafomula athuthukile⁢ kuye ngomongo.

3. Gwema amaphutha okusondeza⁤: Enye yezinkinga ezivame kakhulu lapho kubalwa amaphesenti ku-Excel yile amaphutha okusondeza. ⁤Ukuze ugweme lokhu, ungasebenzisa umsebenzi⁤ “ROUND” noma umsebenzi we-“TRUNCATE” ukulungisa imiphumela— ngenani Idesimali ethize. Lokhu kuzokusiza ukuthi uthole imiphumela enembe kakhulu futhi ugweme ukudideka. Futhi, khumbula ukusebenzisa abakaki nabakaki abayisikwele⁤ ngendlela efanele kumafomula ukuze ugweme amaphutha futhi uthole imiphumela elindelekile.

Ngethemba ukuthi lawa macebiso namasu awusizo kuwe ekuxazululeni izinkinga ezivame kakhulu lapho ubala amaphesenti ku-Excel. Khumbula ukuzilolonga nokuhlola amafomula nemisebenzi ehlukene ukuze ujwayelane nawo futhi uthuthukise amakhono akho okusebenzisa i-Excel.