Izibalo zenzuzo zingenye yezenzo ezidume kakhulu ezenziwa ku-Excel. Lokhu kungaba ukuphindaphinda inombolo ngephesenti elithile, kunqume ukwabelana (ku%) kwenombolo ethile, njll. Nokho, noma ngabe umsebenzisi azi kanjani izibalo ephepheni, akakwazi ukuziphinda njalo ohlelweni. . Ngakho-ke, manje, sizohlaziya ngokuningiliziwe ukuthi inzalo ibalwa kanjani ku-Excel.
Okuqukethwe
Okokuqala, ake sihlaziye isimo esivame kakhulu lapho sidinga ukunquma ingxenye yenombolo eyodwa (njengephesenti) kwenye. Okulandelayo ifomula yezibalo yokwenza lo msebenzi:
Yabelana (%) = Inombolo 1/Inombolo 2*100%, lapho:
- Inombolo 1 - empeleni, inani lethu lezinombolo zangempela
- Inombolo 2 inombolo yokugcina lapho sifuna ukuthola isabelo
Isibonelo, ake sizame ukubala ukuthi iyini ingxenye yenombolo engu-15 enombolweni engu-37. Sidinga umphumela njengephesenti. Kulokhu, inani elithi "Inombolo 1" lingu-15, futhi "Inombolo 2" ingu-37.
- Khetha iseli lapho sidinga khona ukwenza izibalo. Sibhala uphawu “olulinganayo” (“=") bese kuba nefomula yokubala enezinombolo zethu:
=15/37*100%
. - Ngemuva kokuthi sithayiphe ifomula, sicindezela ukhiye we-Enter kukhibhodi, futhi umphumela uzoboniswa ngokushesha kuseli ekhethiwe.
Kwabanye abasebenzisi, kuseli eliwumphumela, esikhundleni senani lephesenti, inombolo elula ingase iboniswe, futhi ngezinye izikhathi ngenani elikhulu lamadijithi ngemva kwephoyinti ledesimali.
Into ewukuthi ifomethi yeseli yokubonisa umphumela ayilungiselelwe. Masilungise lokhu:
- Sichofoza kwesokudla kuseli ngomphumela (akunandaba ngaphambi kokuba sibhale ifomula kuyo futhi sithole umphumela noma ngemva kwalokho), ohlwini lwemiyalo evelayo, chofoza into ethi “Fometha Amaseli…”.
- Efasiteleni lokufometha, sizozithola sikuthebhu "Inombolo". Lapha, ngamafomethi ezinombolo, chofoza kulayini "Amaphesenti" futhi engxenyeni engakwesokudla yefasitela ubonise inombolo oyifunayo yezindawo zamadesimali. Inketho evame kakhulu "2", esiyibeke esibonelweni sethu. Ngemva kwalokho, cindezela inkinobho OK.
- Kwenziwe, manje sizothola inani eliqondile lephesenti kuseli, elalidingeka ekuqaleni.
Ngendlela, lapho ifomethi yokubonisa kuseli isethwe njengephesenti, akudingekile nhlobo ukubhala "* 100%“. Kuyoba okwanele ukwenza ukuhlukaniswa okulula kwezinombolo: =15/37
.
Ake sizame ukusebenzisa ulwazi esilutholile ekusebenzeni. Ake sithi sinetafula elinokuthengiswa kwezinto ezihlukahlukene, futhi sidinga ukubala isabelo somkhiqizo ngamunye emalini engenayo isiyonke. Ukuze kube lula, kungcono ukubonisa idatha kukholamu ehlukile. Futhi, kufanele sibe sesibale kusengaphambili inani lemali engenayo yazo zonke izinto, esizohlukanisa ngazo ukuthengiswa komkhiqizo ngamunye.
Ngakho-ke, ake sehlele phansi emsebenzini owenziwayo:
- Khetha iseli lokuqala lekholomu (ngaphandle kwesihloko sethebula). Njengenjwayelo, ukubhalwa kwanoma iyiphi ifomula kuqala ngophawu “=“. Okulandelayo, sibhala ifomula yokubala iphesenti, efana nesibonelo esicatshangelwe ngenhla, sishintsha kuphela amanani ezinombolo ezithile ngamakheli eseli angafakwa ngesandla, noma ukuwangeza kufomula ngokuchofoza kwegundane. Esimweni sethu, esitokisini E2 udinga ukubhala inkulumo elandelayo:
=D2/D16
. Qaphela: ungakhohlwa ukulungisa kusengaphambili ifomethi yeseli yekholomu ewumphumela ngokukhetha ukubonisa njengamaphesenti. - Cindezela u-Enter ukuze uthole umphumela kuseli enikeziwe.
- Manje sidinga ukwenza izibalo ezifanayo zemigqa esele yekholomu. Ngenhlanhla, amakhono e-Excel akuvumela ukuthi ugweme ukufaka ifomula ngesandla seseli ngalinye, futhi le nqubo ingenziwa ngokuzenzakalelayo ngokukopisha (ukwelula) ifomula kwamanye amaseli. Nokho, kukhona i-nuance encane lapha. Kuhlelo, ngokuzenzakalelayo, lapho ukopisha amafomula, amakheli eselula alungiswa ngokuya nge-offset. Uma kuziwa ekuthengisweni kwento ngayinye ngayinye, kufanele kube njalo, kodwa izixhumanisi zeseli nesamba semali engenayo kufanele zihlale zingashintshile. Ukuyilungisa (uyenze ngokuphelele), udinga ukwengeza uphawu "$“. Noma, ukuze ungathayiphe ngesandla lolu phawu, ngokugqamisa ikheli leseli kufomula, ungavele ucindezele ukhiye. F4. Uma usuqedile, cindezela u-Enter.
- Manje kusele ukwelula ifomula kwamanye amaseli. Ukuze wenze lokhu, hambisa ikhesa ekhoneni elingezansi kwesokudla seseli ngomphumela, i-pointer kufanele iguqule umumo ibe isiphambano, ngemva kwalokho, yelula ifomula phansi ngokubamba inkinobho yegundane kwesokunxele.
- Yilokho kuphela. Njengoba besifuna, amaseli ekholomu yokugcina agcwaliswe ngesabelo sokuthengiswa komkhiqizo ngamunye kwisamba semali engenayo.
Yiqiniso, ezibalweni akudingekile ukubala imali yokugcina engenayo kusengaphambili futhi ubonise umphumela kuseli elihlukile. Yonke into ingabalwa ngokushesha kusetshenziswa ifomula eyodwa, eyeseli E2 bukeka kanje: =D2/СУММ(D2:D15)
.
Kulokhu, ngokushesha sibale isamba semali engenayo kufomula yokubala isabelo sisebenzisa umsebenzi ISUM. Funda mayelana nendlela yokuyisebenzisa esihlokweni sethu - "".
Njengokukhetha kokuqala, sidinga ukulungisa isibalo sokuthengiswa kokugcina, noma kunjalo, njengoba iseli elihlukile elinenani elifunekayo alibambi iqhaza ekubalweni, sidinga ukubeka phansi izimpawu "$” ngaphambi kokuqokwa kwemigqa namakholomu kumakheli eseli obubanzi besamba: =D2/СУММ($D$2:$D$15)
.
Ukuthola iphesenti lenombolo
Manje ake sizame ukubala iphesenti lenombolo njengenani eliphelele, okungukuthi njengenombolo ehlukile.
Ifomula yezibalo yokubala imi kanje:
Inombolo 2 = Amaphesenti (%) * Inombolo 1, lapho:
- Inombolo 1 inombolo yokuqala, iphesenti ofuna ukubala
- Iphesenti - ngokulandelana, inani lephesenti ngokwalo
- Inombolo 2 iyinani lokugcina lenombolo okufanele litholakale.
Isibonelo, ake sithole ukuthi iyiphi inombolo engu-15% kwangu-90.
- Sikhetha iseli lapho sizobonisa khona umphumela bese sibhala ifomula ngenhla, sifaka amanani ethu kulo:
=15%*90
.Qaphela: Njengoba umphumela kufanele ube ngamagama aphelele (okungukuthi njengenombolo), ifomethi yeseli ithi “okuvamile” noma “izinombolo” (hhayi “iphesenti”). - Cindezela inkinobho ethi Enter ukuze uthole umphumela kuseli ekhethiwe.
Ulwazi olunjalo lusiza ukuxazulula izinkinga eziningi zezibalo, ezomnotho, zomzimba nezinye. Ake sithi sinetafula elinokuthengiswa kwezicathulo (ngababili) ngekota engu-1, futhi sihlela ukuthengisa u-10% ngaphezulu ngekota elandelayo. Kuyadingeka ukunquma ukuthi mangaki amapheya ento ngayinye ahambisana nalawa 10%.
Ukuze uqedele umsebenzi, landela lezi zinyathelo:
- Ukuze kube lula, sakha ikholomu entsha, kumaseli lapho sizobonisa khona imiphumela yokubala. Khetha iseli lokuqala lekholomu (ubala izihloko) bese ubhala ifomula ngenhla kuyo, esikhundleni senani lenombolo efanayo nekheli leseli:
=10%*B2
. - Ngemva kwalokho, cindezela inkinobho ethi Enter, futhi umphumela uzovela ngokushesha esitokisini ngefomula.
- Uma sifuna ukususa amadijithi ngemuva kwephuzu ledesimali, ngoba esimweni sethu inani lamapheya ezicathulo lingabalwa kuphela njengama-integers, siya kufomethi yeseli (sixoxile ngokuthi singakwenza kanjani lokhu ngenhla), lapho sikhetha khona. ifomethi yezinombolo engenazo izindawo zedesimali.
- Manje ungakwazi ukunweba ifomula kumaseli asele kukholamu.
Ezimweni lapho sidinga ukuthola amaphesenti ahlukene ezinombolweni ezahlukene, ngokufanele, sidinga ukudala ikholomu ehlukile hhayi nje yokubonisa imiphumela, kodwa namanani amaphesenti.
- Ake sithi ithebula lethu liqukethe ikholomu enjalo “E” (Inani %).
- Sibhala ifomula efanayo kuseli lokuqala lekholomu engumphumela, manje kuphela lapho sishintsha inani lephesenti elithile ekhelini leseli ngenani lephesenti eliqukethwe kulo:
=E2*B2
. - Ngokuchofoza u-Enter sithola umphumela kuseli enikeziwe. Kuhlala kuphela ukukwelula emigqeni engezansi.
Isiphetho
Ngenkathi usebenza ngamatafula, ngokuvamile kuyadingeka ukwenza izibalo ngamaphesenti. Ngenhlanhla, ukusebenza kohlelo lwe-Excel kukuvumela ukuthi uzenze kalula, futhi uma sikhuluma ngohlobo olufanayo lwezibalo ematafuleni amakhulu, inqubo ingenziwa ngokuzenzakalelayo, ezosindisa isikhathi esiningi.