Lapho usebenza nedatha ye-tabular, uvame kudingeka ukubala amaphesenti enani, noma ukubala amaphesenti esamba. Lesi sici sinikezwa yi-Microsoft Excel. Kepha, ngeshwa, akuwona wonke umsebenzisi ongasebenzisa amathuluzi wokusebenza ngamaphesenti kulolu hlelo lokusebenza. Ake sibheke ukuthi singalwa kanjani amaphesenti ku-Microsoft Excel.
Ukubalwa kwamaphesenti enamba
Okokuqala, asithole ukuthi singawabala kanjani amaphesenti enombolo eyodwa ukusuka kwenye. Ifomula yokubala ejwayelekile imi ngalendlela elandelayo: "= (inombolo) / (inani_sum) * 100%.
Ngakho-ke, ukuze sikhombise ukubalwa kokuzijwayeza, sithola ukuthi mangaki amaphesenti angama-9 asuka ku-17. Okokuqala, singena esitokisini lapho umphumela uzokhonjiswa khona. Qiniseka ukuthi unaka ifomethi echazwe kuthebhu "Yasekhaya" eqenjini lamathuluzi "Inombolo". Uma ifomethi ihlukile kumaphesenti, khona-ke qiniseka ukusetha ipharamitha engu- "Amaphesenti" enkambu.
Ngemuva kwalokho, sibhala esitokisini le nkulumo elandelayo: "= 9/17 * 100%".
Kodwa-ke, njengoba sibeka ifomethi yeseli, ukufaka inani "* 100%" akudingekile. Kwanele ngokukhawulelwa ekubhaleni "= 9/17".
Ukubona umphumela, cindezela inkinobho ethi Enter kwikhibhodi. Njengomphumela, sithola ama-52.94%.
Manje ake sibheke ukuthi amaphesenti angabalwa kanjani ngokusebenza nedatha ye-tabular kumaseli. Ake sithi sidinga ukubala ukuthi angakanani amaphesenti isabelo sokuthengiswa kohlobo oluthile lomkhiqizo esilinganisweni esiveziwe esitokisini esihlukile. Ukuze wenze lokhu, emgqeni negama lomkhiqizo, chofoza kuseli elingenalutho, bese usetha ifomethi yamaphesenti kuyo. Sibeka isibonakaliso "=". Okulandelayo, sichofoza kuseli ekhombisa inani lokuthengisa lohlobo oluthile lomkhiqizo. Ngemuva kwalokho, beka uphawu "/". Ngemuva kwalokho, sichofoza kuseli ngenani eliphelele lokuthengisa lwazo zonke izimpahla. Ngakho-ke, esitokisini sokukhipha umphumela, sinefomula.
Ukuze ubone inani lezibalo, chofoza ku-Enter inkinobho.
Kepha, ngale ndlela, sithole incazelo yesabelo samaphesenti umugqa owodwa kuphela. Ngabe kuyadingeka ngempela ukwethula ukubala okufanayo kulayini ngamunye olandelayo? Akunasidingo. Sidinga ukukopisha le formula kwamanye amaseli. Kepha, njengoba kule ndaba isixhumanisi esitokisini nenani eliphelele kufanele sibe njalo ukuze kungabikho ukukhetha, sibeka uphawu "$" phambi kwezixhumanisi zomugqa nekholamu yalo. Ngemuva kwalokho, ireferensi yeseli kusuka kusihlobo iphenduka ibe ngokuphelele
Okulandelayo, simi ekhoneni elingezansi kwesokudla seseli, inani laso selivele libaliwe, futhi, sibambe inkinobho yegundane, silidonsela phansi esitokisini lapho kutholakala khona inani eliphelele. Njengoba ubona, ifomula ikopishelwa kuwo wonke amanye amaseli etafula. Umphumela wokubala ubonakala ngokushesha.
Ungbala amaphesenti wezakhi ngazinye zetafula, noma ngabe inani eliphelele aliboniswanga kuseli elihlukile. Ukuze wenze lokhu, ngemuva kokufometha iseli ukubonisa umphumela ngefomethi yephesenti, faka uphawu "=" kuwo Okulandelayo, chofoza esitokisini ofuna ukuthola impendulo yaso. Sibeka isibonakaliso "/", bese sishayela isamba esiphelele lapho iphesenti libalwa ukusuka kukhibhodi. Guqula isixhumanisi sibe ngokuphelele, kulokhu, akudingekile.
Ngemuva kwalokho, njengesikhathi sokugcina, chofoza inkinobho ENTER, futhi ngokuhudula bese uphonsa, kopisha ifomula kumaseli angezansi.
Ukubalwa kwamaphesenti
Manje thola ukuthi ungabala kanjani inani lemali ephelele njengephesenti layo. Ifomula ejwayelekile yokubala izoba nefomu elilandelayo: "amaphesenti_value% * inani_ inani". Ngakho-ke, uma sidinga ukubala ukuthi yiliphi inani elingu-7% wama-70, khona-ke simane sifaka igama elithi "= 7% * 70" esitokisini. Njengoba, ekugcineni, sithola inombolo, hhayi amaphesenti, khona-ke kuleli cala awudingi ukusetha ifomethi. Kufanele kube ngokujwayelekile noma ngokwezinombolo.
Ukubuka umphumela, cindezela inkinobho ENTER.
Le modeli ilula kakhulu ukuyisebenzisela ukusebenza namatafula. Isibonelo, sidinga ukubala inani le-VAT, okuthi kulo i-Russia ibe ngu-18%, kusukela ekuveleni kwento ngayinye yezimpahla. Ukuze wenze lokhu, sima esitokisini esingenalutho emgqeni negama lomkhiqizo. Lesi seli lizoba ngenye yezakhi zekholamu, ezokhombisa inani le-VAT. Fometha leli seli ngefomethi yamaphesenti. Sifaka isibonakaliso "=" kuyo. Sithayipha inombolo engu-18% kukhibhodi, bese sifaka uphawu lokuthi "*". Okulandelayo, sichofoza kuseli lapho inani lemali evela ekuthengisweni kwaleli gama lomkhiqizo litholakala. Ifomula isilungile. Kulokhu, akufanele uguqule ifomethi yeseli ibe ngamaphesenti, noma wenze izixhumanisi ziphelele.
Ukuze ubone umphumela wokubala, chofoza kukhiye we-ENTER.
Kopisha ifomula kwamanye amaseli ngokuhudula phansi. Ithebula elinemininingwane enanini le-VAT selilungile.
Njengoba ukwazi ukubona, iMicrosoft Excel inikezela ngamakhono wokusebenza kahle ngamaphesenti. Kulokhu, umsebenzisi angakwazi ukubala izingxenye ezimbili zenani elithile ngamaphesenti, kanye nenani lamaphesenti. I-Excel ingasetshenziselwa ukusebenza ngamaphesenti, njengesibali esijwayelekile, kepha ungayisebenzisa futhi ukwenza umsebenzi wokubala amaphesenti ematafuleni. Lokhu kukuvumela ukuthi ulondoloze kakhulu isikhathi sabasebenzisi bohlelo kuzibalo.
