Ukukhishwa ngamaphesenti kunombolo ngesikhathi sokubala kwezibalo akuyona into engatheni. Isibonelo, ezikhungweni zokuhweba, iphesenti le-VAT lidonswa kwisamba ukuze kubekwe intengo yezimpahla ngaphandle kwe-VAT. Iziphathimandla ezahlukahlukene zokulawula zenza okufanayo. Ake futhi sizothola ukuthi singasusa kanjani amaphesenti kunombolo eku-Microsoft Excel.
Ukukhishwa ngamaphesenti ku-Excel
Okokuqala, ake sibheke ukuthi amaphesenti akhishwa kanjani enanini lilonke. Ukususa iphesenti enombolweni, kufanele unqume ngokushesha ukuthi malini, ngamanani wokulinganisa, okuzoba yipesenti ethile yenombolo enikeziwe. Ukuze wenze lokhu, phindaphinda inombolo yasekuqaleni ngamaphesenti. Ngemuva kwalokho, umphumela ukhishwe kunombolo yasekuqaleni.
Kumafomula we-Excel, kuzobukeka kanjena: "= (inombolo) - (inombolo) * (iphesenti_value)%."
Veza ukukhishwa kwamaphesenti kwisibonelo esithile. Ake sithi sidinga ukususa ama-12% kusuka kuma-48. Sichofoza kunoma isiphi iseli eshidini, noma senze okungenhla kubha yefomula: "= 48-48 * 12%".
Ukuze wenze ukubala futhi ubone umphumela, chofoza inkinobho ethi ENTER kukhibhodi.
Ukukhishwa ngamaphesenti kusuka etafuleni
Manje ake sibheke ukuthi singalisusa kanjani iphesenti kusuka kudatha esivele ibhalwe kutafula.
Uma kwenzeka sifuna ukukhipha iphesenti elithile kuwo wonke amaseli ekholamu ethile, khona-ke, okokuqala, sifika esitokisini esingenalutho kakhulu setafula. Sifaka isibonakaliso "=" kuyo. Okulandelayo, chofoza kuseli, iphesenti ofuna ukukhipha. Ngemuva kwalokho, beka uphawu lokuthi "-", bese uphinde uqhafaza kuseli elifanayo elalihlolwe kulo ngaphambili. Sibeka isibonakaliso se- "*", futhi kusuka kukhibhodi sibhala ngenani lamaphesenti okufanele lisuswe. Ekugcineni, beka uphawu "%".
Sichofoza inkinobho ethi ENTER, ngemuva kwalokho kwenziwa izibalo, bese umphumela ukhonjiswa esitokisini lapho sabhala khona ifomula.
Ukuze ifomula ikopishelwe kumaseli asele kule kholamu, futhi, ngenxa yalokho, amaphesenti akhishwe kwamanye amarowu, siba ekhoneni elingezansi kwesokudla seseli lapho sekuvele ifomula ebaliwe. Sicindezela inkinobho yesobunxele kwigundane, bese siyidonsela phansi ekugcineni kwetafula. Ngakho-ke, sizobona kunombolo ngayinye yamaseli emelela inani langempela lokukhipha iphesenti elisunguliwe.
Ngakho-ke, sihlolisise amacala amabili aphambili okususa amaphesenti kusuka kunamba e-Microsoft Excel: njengokubala okulula, nokusebenza kwetafula. Njengoba ukwazi ukubona, inqubo yokususa inzalo ayiyona inkimbinkimbi kakhulu, futhi ukusetshenziswa kwayo ematafuleni kusiza ukwenza lula umsebenzi kubo.
