Lapho usebenza ngemininingwane ye-tabular, kuvame ukudingeka ukubala iphesenti yenombolo, noma ubale iphesenti yenani eliphelele. Lesi sici sinikezwa i-Microsoft Excel. Kodwa, ngeshwa, akuwona wonke umsebenzisi okwazi ukusebenzisa amathuluzi wokusebenza nesithakazelo kulolu hlelo lokusebenza. Ake sithole ukuthi singakanani ukubala iphesenti ku-Microsoft Excel.
Ukubalwa kwephesenti
Okokuqala, ake sithole ukuthi singakanani ukuthilala iphesenti yenombolo eyodwa kwesinye. Ifomula ejwayelekile yokubala kanje: "= (inombolo) / (total_sum) * 100%.
Ngakho-ke, ukuze sibonise izibalo ngokusebenza, sithola ukuthi zingaki amaphesenti inani elingu-9 kusuka ku-17 Okokuqala, sisuke esitokisini lapho umphumela uzoboniswa khona. Qinisekisa ukuthi unake ukuthi yiyiphi ifomethi efakwe kuthebhu yaseKhaya eqenjini lezinombolo zamathuluzi. Uma ifomethi ihlukile kumaphesenti, kufanele sabe ipharamitha "Inzalo" ensimini.
Emva kwalokho, bhala inkulumo elandelayo esitokisini: "= 9/17 * 100%".
Kodwa-ke, njengoba sesimise ifomethi yephesenti yeseli, kwengeza inani "* 100%" akudingekile. Kwanele ukubhala "= 9/17".
Ukuze ubone umphumela, chofoza inkinobho yokungena kwikhibhodi. Ngenxa yalokho, sithola u-52.94%.
Manje ake sibheke ukuthi isithakazelo singabalwa kanjani ngokusebenza ngemininingwane yamathebhu kumaseli. Ake sithi kudingeka sibone ukuthi yiliphi iphesenti isabelo sokuthengiswa kohlobo oluthile lomkhiqizo kusukela esamba semali eshiwo esitokisini esithile. Ukwenza lokhu, ngokuhambisana negama lomkhiqizo, chofoza iseli elingenalutho, bese usetha ifomethi yephesenti kukho. Faka uphawu "=". Okulandelayo, chofoza kuseli ebonisa ukubaluleka kokusetshenziswa kohlobo oluthile lomkhiqizo. Bese ubeka uphawu "/". Bese, chofoza esitokisini ngenani lemali yokuthengisa yonke imikhiqizo. Ngakho-ke, esitokisini ukubonisa umphumela, sinomthelela.
Ukubona ukubaluleka kokubala, chofoza inkinobho yokungenisa.
Kodwa, ngale ndlela, sithole incazelo yesabelo sephesenti ngomugqa owodwa kuphela. Ingabe kuyadingeka ngempela ukwethula izibalo ezinjalo emgqeni ngamunye olandelayo? Hhayi ngempela. Sidinga ukukopisha leli fomu kwamanye amaseli. Kodwa, kusukela kulokhu ukubhekisela kweseli ngenani eliphelele kumele kube njalo ukuze kungabikho ukufuduka kwebala, kufomula sibeka uphawu "$" phambi kwezixhumanisi zomugqa nekholomu. Ngemuva kwalokho, ukubhekisela kweseli kusuka esihlokweni kuphenduka ngokuphelele.
Okulandelayo, siba ekhoneni elingaphansi kwesokudla leseli, inani laso selibalwe, futhi, ebambe inkinobho yegundane, donsela phansi esitokisini, lapho inani eliphelele lihlanganisiwe. Njengoba ungabona, ifomula likopishwa kuwo wonke amanye amaseli etafula. Umphumela obonakala ngokushesha wezibalo.
Ungakwazi ukubala iphesenti yezingxenye ezihlukene zetafula, ngisho noma inani eliphelele lingaboniswa esitokisini esithile. Ukuze senze lokhu, ngemuva kokufometha iseli ukuze sibonise umphumela kwifomethi yephesenti, faka uphawu "=" kuyo. Okulandelayo, chofoza esitokisini isabelo sakho esidinga ukuthola. Sifaka isibonakaliso "/", bese sishayela ngaphakathi kwekhibhodi inani eliphelele lapho iphesenti ibalwa khona. Ukuvula isixhumanisi singene ngokuphelele, kulokhu, akudingekile.
Khona-ke, njengesikhathi sokugcina, sichofoza inkinobho ye-ENTER, futhi ngokuhudula sikopisha ifomula kumaseli atholakala ngezansi.
Ukubalwa kwenani lentandokazi
Manje sithola ukuthi singakanani ukuthi sinani inani lenani lephesenti yalo. Ifomula evamile yesibalo iyoba kanje: "iphesenti_volumu% * inani_yonke." Ngakho-ke, uma sidinga ukubala ukuthi iyiphi inombolo engu-7% wezingu-70, bese ufaka nje inkulumo ethi "= 7% * 70" esitokisini. Njengoba, ngenxa yalokho, sithola inombolo, hhayi iphesenti, kulokhu akudingekile ukusetha ifomethi yephesenti. Kumele kube yi-generic noma inombolo.
Ukuze ubuke umphumela, cindezela inkinobho ENTER.
Lo modeli ulungele kakhulu ukusebenzisa ngokusebenzisana namatafula. Isibonelo, sidinga kusuka kwingeniso yento ngayinye ukubala inani le-VAT, okuyinto eRussia engu-18%. Ukwenza lokhu, siba esitokisini esingenalutho emgqeni negama lezimpahla. Leli seli lizobe liyingxenye yezinto ezibonakalayo zekholomu lapho izimali ze-VAT zizokhonjiswa khona. Fometha le seli ngesakhiwo sephesenti. Sifaka kuso uphawu "=". Sithinta ikhibhodi inombolo engu-18%, bese ufaka uphawu "*". Okulandelayo, chofoza esitokisini okungenani inani lemali ekudayiseni le nto. Ifomula ilungile. Kulokhu, akufanele ushintshe ifomethi yeseli kumaphesenti, noma wenze izixhumanisi ngokuphelele.
Ukuze ubone umphumela wokuchofoza ukubala ku-ENTER ukhiye.
Kopisha ifomula kwamanye amaseli ngokuhudula phansi. Ithebula nedatha ngemali ye-VAT ilungile.
Njengoba ubona, i-Microsoft Excel inikeza ikhono lokusebenza kahle ngamanani wepesenti. Kulesi simo, umsebenzisi angakwazi ukubala kokubili inani lenani elithile ngamaphesenti kanye nenani lemali yesithakazelo. I-Excel ingasetshenziswa ukusebenza ngamaphesenti, njenge-calculator ejwayelekile, kodwa ungayisebenzisa futhi ukwenza umsebenzi wokubala inzalo kumatafula. Lokhu kukuvumela ukuthi ulondoloze ngokuphawulekayo isikhathi sabasebenzisi besihlelo ngesikhathi sokubala.
