Ungabala kanjani iphesenti lenombolo ku-Excel. Ungabala kanjani ukwabelana ku-excel

Izenzo ngamaphesenti zivame ukwenziwa ku-Microsoft Excel, kulula kakhulu futhi kuyasebenziseka. Ukwenza lokhu, uhlelo lusebenzisa amafomula akhethekile nemisebenzi. Kulesi sihloko, sizocubungula ngokuningiliziwe zonke izindlela zokuthola iphesenti lenombolo.

Ukubalwa kwesheya kusuka enombolweni ethile

Ngezinye izikhathi kuyadingeka ukuthola ukuthi iyini ingxenye yenombolo kwenye. Ukuze wenze lokhu, sebenzisa ifomula elandelayo: Yabelana (%) = Inombolo 1/Inombolo 2*100%. Inombolo 1 ingeyokuqala, iNombolo 2 iyona okutholakala kuyo ingxenyenamba yenombolo 1. Ake sicabangele lokhu kusebenza kwezibalo ngesibonelo. Cabanga ukuthi udinga ukuthola ingxenyenamba yenombolo 18 enombolweni engu-42. Udinga ukwenza i-algorithm yezinyathelo ezimbili:

1. Khetha iseli elingenalutho bese ubhala ifomula lapho ngezinombolo ezinikeziwe. Kudingeka uphawu olulinganayo ngaphambi kwefomula, ngaphandle kwalokho ukubala okuzenzakalelayo ngeke kwenzeke.

2. Cindezela inkinobho ethi "Enter", iseli izobonisa inani lesibalo njengephesenti noma inombolo evamile.

Kubalulekile! Akudingekile ukubhala ingxenye ethi “*100” kufomula. Ingxenyana inganqunywa ngokumane uhlukanise inombolo eyodwa nenye.

Uma umphumela uyinombolo, hhayi iphesenti, udinga ukushintsha ifomethi yamaseli. Lokhu kungenziwa ngokusebenzisa isigaba esifanele kumathuluzi e-Excel.

1. Chofoza iseli ngenkinobho yegundane elingakwesokudla. Imenyu izovuleka lapho udinga khona ukukhetha into ethi "Fometha Amaseli".

Ungathola le nketho kuthebhu ethi Ikhaya. Lapho itholakala esigabeni esithi “Amaseli” (isigatshana “Ifomethi”).

2. Imenyu enezinketho zokushintsha ifomethi izovela esibukweni. Kuthebhu "Inombolo" kukhona uhlu lwamafomethi ezinombolo - udinga ukukhetha "Amaphesenti". Ngokuzenzakalelayo, izindawo zedesimali ezi-2 zisethiwe, kodwa lokhu kungalungiswa ngezinkinobho zemicibisholo. Ngemva kokuqeda izilungiselelo, chofoza "OK". Manje iseli elikhethiwe lizohlala liqukethe idatha ngefomethi yephesenti.

Masisebenzise ulwazi esilutholile esibonelweni esiyinkimbinkimbi. Isibonelo, udinga ukunquma isabelo sohlobo ngalunye lomkhiqizo enanini lemali engenayo. Ukuze sifeze lo msebenzi, sizohlanganisa ithebula lapho sibonisa khona inani leyunithi lemikhiqizo embalwa, amanani okuthengisa kanye nemali engenayo. Udinga futhi ukubala isamba semali engenayo usebenzisa umsebenzi we-SUM. Ekupheleni kwethebula, sizodala ikholomu yamasheya enani lemali engenayo ngamaseli ngefomethi yamaphesenti. Kuyadingeka ukucabangela ukubalwa kwalesi sibonakaliso isinyathelo ngesinyathelo:

1. Khetha iseli yokuqala yamahhala kukholamu yokugcina bese ufaka ifomula yokubala ukwabelana endaweni. Inombolo 1 izoba yimali engenayo evela ekuthengisweni komkhiqizo owodwa, kanti okwesibili - isamba semali engenayo.

2. Cindezela inkinobho ethi "Enter", iphesenti lizovela kuseli.

Okulandelayo, udinga ukugcwalisa ikholomu yonke idatha enjalo. Akudingekile ukufaka ifomula mathupha ngaso sonke isikhathi - senza ngokuzenzakalelayo ukugcwalisa ngokuguqulwa okuncane kwesisho.

1. Ingxenye eyodwa yefomula iyashintsha isuka emgqeni iye emgqeni, enye ihlala injalo. Masiqinisekise ukuthi uma umsebenzi udluliselwa kwelinye iseli, kushintshwa i-agumenti eyodwa kuphela. Kumelwe uchofoze iseli eligcwalisiwe bese ufaka izimpawu zedola phambi kohlamvu nenombolo ekubekweni kwenkambu yemali engenayo isiyonke ngebha yefomula. Inkulumo kufanele ibukeke kanje: =D2 / $D$ 10.
2. Okulandelayo, khetha wonke amaseli kukholomu ukuya kumugqa othi “Ingqikithi” ngokubamba ikhona elingezansi kwesokudla kuseli lokuqala. Ulayini ngamunye uqukethe ulwazi mayelana nesabelo sezimpahla emalini engenayo isiyonke.

3. Ungathola isabelo emalini engenayo yokugcina ngaphandle kokubala imali engenayo. Masisebenzise umsebenzi we-SUM - isisho esinayo sizothatha indawo ye-agumenti yesibili.
4. Masidale ifomula entsha: =Imali engenayo yohlobo olulodwa lomkhiqizo/I-SUM(Inani lemali engenayo yayo yonke imikhiqizo). Njengomphumela wezibalo, sithola inombolo efanayo lapho sisebenzisa indlela yangaphambilini:

Ibala iphesenti lenombolo enikeziwe

Ukusebenza okuphambene - ukukhipha iphesenti lenombolo ngefomethi yenombolo evamile - nakho ngokuvamile kuyadingeka. Ake sithole ukuthi singakwenza kanjani ukubala okunjalo. Ifomula yokubala ithi: Inombolo 2 = Amaphesenti (%) * Inombolo 1. Incazelo yale nkulumo: iphesenti inqunywa kuNombolo 1, okuholela kuNombolo 2. Ake sihlole ifomula ngesibonelo sangempela. Kuyadingeka ukuthola ukuthi yimalini - 23% ka-739.

1. Sikhetha iseli yamahhala bese sibhala ifomula kuyo enedatha eyaziwayo.

2. Cindezela okuthi “Enter”, umphumela wokubala uvela eshidini.

Nakani! Kulesi simo, awudingi ukushintsha ifomethi yeseli ngoba ufuna inombolo, hhayi iphesenti.

Ngesibonelo sedatha, ungasebenzisa ithebula eselidaliwe kakade. Cabanga ukuthi ngenyanga ezayo uhlela ukuthengisa amayunithi angu-15% engeziwe omkhiqizo ngamunye. Kuyadingeka ukuthola ukuthi iyiphi ivolumu yokukhiqizwa kwezinhlobo ezahlukene zemikhiqizo ehambelana no-15%.

1. Sakha ikholomu entsha bese sifaka ifomula ehambisana nedatha eyaziwayo kuseli lokuqala lamahhala.

2. Cindezela inkinobho ethi "Enter" bese uthola umphumela.
3. Sidlulisela ifomula kuwo wonke amaseli ekholomu sisebenzisa isibambo sokugcwalisa.

Ungakwazi ukususa izindawo zamadesimali ngokushintsha ifomethi yeseli. Khetha wonke amaseli anemiphumela, vula imenyu yefomethi bese ukhetha Izinombolo. Udinga ukunciphisa inani lezindawo zamadesimali zibe ziro bese uchofoza okuthi “KULUNGILE”, ngemva kwalokho ikholomu izoqukatha izinombolo kuphela.

Ukwengeza nokususa intshisekelo

Ngokusekelwe kumafomula angenhla, ungenza imisebenzi yezibalo elula ngamaphesenti.

Ukubalwa kwesamba senombolo kanye nephesenti layo kungokulandelayo: Inani=Inombolo+(Iphesenti (%)*Inombolo). Ifomula yomehluko ihluka kuphela ngophawu: Umehluko=Inombolo-(Iphesenti (%)*Inombolo).

Cabangela lezi zenzo ngezibonelo - engeza u-530% ukuya ku-31, bese ususa iphesenti elifanayo enombolweni yokuqala. Kufanele ukhethe iseli yamahhala bese ufaka ifomula, bese ucindezela u-“Enter”.

Amathuluzi e-Excel akuvumela ukubala umehluko phakathi kwezinombolo ezimbili ezivezwe njengephesenti. Ifomula yalesi senzo ithi: Umehluko=(Inombolo 2-Inombolo 1)/Inombolo 1*100%. 

Sisebenzisa ifomula esibonelweni: ukuthengiswa kwezimpahla kwenyukile, futhi sidinga ukunquma ukuthi yimaphi amaphesenti amayunithi emikhiqizo yamagama ahlukene athengisiwe.

1. Kukholomu edalwe ngokukhethekile, khetha iseli eliphezulu bese ubhala ifomula kulo. Inombolo 1 kanye no-2 yizindali ezindala nezintsha.

2. Cindezela okuthi “Enter” bese uthola umphumela wokuqala.
3. Khetha wonke amaseli ekholomu anomaka wokuqedela ngokuzenzakalela - ifomula ikopishwa ngokususwa.

Isiphetho

Ukusebenza ngamaphesenti ku-Excel kulula kakhulu, ngoba amafomula ayafana nezenzo ezijwayelekile kwabaningi ezivela esifundweni sezibalo. Nokho, kulula kakhulu ukubala isithakazelo ohlelweni, ngoba kungenzeka ukwenza izibalo ngokuzenzakalelayo.