Indlela yokubala amaphesenti enombolo ku-Excel. Indlela yokubala isigxobo ku-Excel

Izenzo ezinesithakazelo zivame ukwenziwa kuMicrosoft Excel, zilula futhi zisebenza. Ukuze wenze lokhu, uhlelo lusebenzisa amafomula akhethekile nemisebenzi. Kulesi sihloko, sizocubungula ngokuningiliziwe zonke izindlela zokuthola iphesenti lenombolo.

Ukubalwa kwesabelo senombolo ebekiwe

Kwesinye isikhathi udinga ukwazi ukuthi yini enye ingxenye eyodwa kwenye. Kulokhu, ifomula elilandelayo lisetshenziselwa: share (%) = Inombolo 1 / Inombolo 2 * 100%. Inombolo 1 iyona eyokuqala, inombolo 2 lapho inani lezinombolo litholakala 1. Cabanga ngalesi senzo sezibalo esibonelweni. Cabanga nje ukuthi kuyadingeka ukuthola ingxenye yenombolo yenombolo 18 phakathi kwenombolo 42. Kuyadingeka ukwenza i-algorithm yezinyathelo ezimbili:

1. Khetha iseli elingenalutho bese ubhala ifomula kwizinombolo ezibekiwe lapho. Ngaphambi kwefomula, kuyadingeka ukusayina ukulingana, ngaphandle kwalokho ukubalwa okuzenzakalelayo ngeke kwenzeke.

okukodwa

1. Cindezela ukhiye we- "Enter", inani lokubala elinamaphesenti noma ngenombolo evamile lizovela esitokisini.

2.

Uma umphumela waba yinombolo, futhi ungathandi, udinga ukushintsha ifomethi yamaseli. Lokhu kungenziwa kusetshenziswa isigaba esifanele kumathuluzi we-Excel.

1. Chofoza endaweni yenkinobho yegundane efanele. Imenyu izovulwa, lapho udinga khona ukukhetha into ethi "Ifomethi Yeseli".

3.

Ungathola futhi le nketho kuthebhu yasekhaya. Lapho itholakala engxenyeni ethi "Cell" (isigatshana "ifomethi").

okune

1. Imenyu izovela esikrinini ngezinketho zokushintsha ifomethi. Kuthebhu "Yenombolo", kukhona uhlu lwamafomethi wenombolo - udinga ukukhetha "amaphesenti". Ngokuzenzakalelayo, izibonakaliso ezi-2 ngemuva kokuthi i-semicolon isethiwe, kepha ingalungiswa ngezinkinobho zomcibisholo. Ekupheleni kwesilungiselelo, chofoza u- "KULUNGILE". Manje ekongeni elikhethiwe kuzohlala kuyinto idatha ngefomethi yamaphesenti.

isihlanu

Sisebenzisa ulwazi olutholwe esibonelweni esiyinkimbinkimbi ngokwengeziwe. Isibonelo, udinga ukunquma isabelo sohlobo ngalunye lomkhiqizo kwimali evamile. Ukwenza lo msebenzi, sizokwenza itafula lapho ucacisa khona intengo yeyunithi yezimpahla eziningana, ukuthengisa kanye nemali engenayo. Kuyadingeka futhi ukubala imali yokugcina usebenzisa umsebenzi wezibalo. Ekupheleni kwetafula, dala ikholomu ukuthola imali ephelele enamaseli ngefomethi yamaphesenti. Kuyadingeka ukubheka ukubalwa kwalesi sinyathelo senkomba ngesinyathelo:

1. Khetha iseli lokuqala lamahhala kwikholamu yokugcina futhi sifaka ifomula yokubala yokwabelana enkundleni. Inombolo 1 izothola imali evela ekuthengisweni komkhiqizo owodwa, kanti okwesibili yisamba semali engenayo yonke.

6.

1. Cindezela ukhiye we- "Enter", isabelo samaphesenti sizovela esitokisini.

7.

Okulandelayo, udinga ukugcwalisa yonke ikholomu ngedatha enjalo. Akudingekile ukwethula ifomula ngesandla ngaso sonke isikhathi - shintsha ukugcwaliswa ngokuguqulwa okuncane kwenkulumo.

1. Ingxenye eyodwa yefomula iyahlukahluka kusuka entanjeni kuya entanjeni, enye ihlala ingashintshiwe. Senza lokho lapho sidlulisela umsebenzi kwelinye iseli, kwathathelwa indawo ingxabano eyodwa kuphela. Kufanele uchofoze esitokisini esigcwele bese ufaka izimpawu zedola phambi kwencwadi namadijithi ekuqondeni kwe-General Revenue field ngokusebenzisa intambo yefomula. Inkulumo kufanele ibukeke into efana nale: = D2 / $ D $ 10.
2. Okulandelayo, sabela wonke amaseli kukholamu kwintambo "isiyonke" ngokubamba ekhoneni elingezansi kwesokudla esitokisini sokuqala. Umugqa ngamunye uvela imininingwane mayelana nokwabelana ngezimpahla ezizonke imali.

isishiyagalombili

1. Ungathola isabelo kwingeniso yokugcina ngaphandle kokubala imali engenayo. Sisebenzisa umsebenzi wezibalo - le nkulumo izothathelwa indawo ngengxabano yesibili.
2. Masenze ifomula entsha: = Imali engenayo yohlobo olulodwa lwezimpahla / amanani (uhla lwemali engenayo yazo zonke izimpahla). Ngokusho kwezibalo eziphelele, sithola inombolo efanayo nalapho sisebenzisa indlela edlule:

isishiyagalolunye

Ukubala amaphesenti enombolo ebekiwe

Ukusebenza kabusha kwe-Reverse - Ukwabiwa kwamaphesenti enombolo ngefomethi yenombolo ejwayelekile nakho kudingeka. Sizokuthola ukuthi singawenza kanjani ukubalwa okunjalo. Ifomula yokubala yile: Number 2 = amaphesenti (%) * Inombolo Kuyadingeka ukwazi ukuthi malini angama-23% angama-739 - futhi.

1. Khetha iseli yamahhala futhi ulenze ifomula ngemininingwane eyaziwayo.

Okuthenyalwayo

1. Chofoza u- "ENTER", umphumela wokubala uvele eshidini.

ishumi nanye

Isibonelo esinedatha, ungasebenzisa ithebula elidaliwe elivele lisunguliwe. Cabanga nje ukuthi ngezinhlelo zenyanga ezayo ukuthengisa ngamayunithi angu-15% womkhiqizo ngamunye. Kuyadingeka ukuthola ukuthi yini umthamo wokukhiqizwa kwezinhlobo ezahlukene zemikhiqizo ihambelana ne-15%.

1. Dala ikholomu entsha bese wethula kwifomethi yokuqala yeselula yamahhala ehambelana nedatha eyaziwayo.

Okuqophele imali

1. Cindezela ukhiye we- "ENTER" bese uthola umphumela.
2. Siphatha ifomula kuwo wonke amaseli wekholomu asebenzisa umaki wokugcwalisa.

13

Susa izimpawu zedesimali ngokushintsha ifomethi yeseli. Silwa wonke amaseli ngemiphumela, vula imenyu yefomethi bese ukhetha u- "Numeric". Kuyadingeka ukunciphisa inani lezimpawu zedesimali ku-zero bese uqhafaza u- "KULUNGILE", ngemuva kwalokho kuzoba nezinombolo kuphela kukholamu.

ishumi nane

Ukwengeza nokususa inzalo

Kususelwa kumafomula ashiwo, kungenzeka ukwenza izenzo ezilula zezibalo ngamaphesenti.

Cabanga ngalezi zenzo ezibonelweni - engeza ku-530-no-31%, bese uthatha amaphesenti afanayo enombolo yokuqala. Kuyadingeka ukukhetha iseli yamahhala bese ufaka ifomula, bese ucindezela u- "ENTER".

ishumi nanhlanu

Sisebenzisa ifomula esibonelweni: Ukuthengisa kwezimpahla kukhule, futhi kuyadingeka ukuthola ukuthi mingaki eminye imikhiqizo ethengisiwe kwimikhiqizo yezinto ezahlukene.

1. Kwikholamu edalwe ngokukhethekile, sikhetha iseli eliphezulu futhi senze ifomula kuyo. Izinombolo 1 no-2 ukuthengisa okudala nokusha.

ishumi nesithupha

1. Chofoza u- "Faka" bese uthola umphumela wokuqala.
2. Silwa wonke amaseli ekholomu ngomaki ophelele - ifomula ikopishwa ngokuxoshwa.

17.

Ukugcina

Kulula kakhulu ukusebenza ngamaphesenti e-Excel, ngoba amafomula ahambisana nezenzo eziningi ezijwayelekile kusukela ekuqhubekeni kwezibalo. Kodwa-ke, kulula kakhulu ukubala intshisekelo kulolu hlelo, ngoba kungenzeka ukushintsha izibalo.

Umlayezo wokuthi ubala kanjani amaphesenti enombolo ku-Excel. Ungabala kanjani isabelo esise-Excel kwavela kuqala kubuchwepheshe bolwazi.