Ukukhipha isithakazelo kwinombolo ngesikhathi sokubala izibalo akuyona into engavamile. Isibonelo, ezinkampanini zokuhweba zithatha iphesenti ye-VAT emalini yonke ukuze kubekwe intengo yezimpahla ngaphandle kwe-VAT. Lokhu kwenziwa yizinhlaka ezihlukahlukene zokulawula. Masibuye sibone ukuthi singasusa kanjani iphesenti kusukela kwinombolo ku-Microsoft Excel.
Ukususwa kwephesenti ku-excel
Okokuqala, ake sibone ukuthi amaphesenti asuswa kanjani enombolweni yonke. Ukuze ususe iphesenti kusukela enombolweni, udinga ngokushesha ukuthi unamanani amanani angakanani azokwenza amaphesenti athile ale namba. Ukuze wenze lokhu, phinda inombolo yokuqala ngenani lephesenti. Khona-ke, umphumela ususwe kusuka kwinombolo yokuqala.
Ngendlela ye-formula e-Excel, izobukeka kanje: "= (inombolo) - (inombolo) * (amaphesenti inani)%".
Sibonisa ukukhishwa kwesithakazelo esibonelweni esithile. Ake sithi sidinga ukususa 12% kusuka enombolweni 48. Chofoza kunoma isiphi iseli leshidi, noma wenze ukungena kubha yefomula: "= 48-48 * 12%."
Ukuze wenze isibalo futhi ubone umphumela, chofoza inkinobho ENTER ekhibhodi.
Ukukhipha isithakazelo etafuleni
Manje ake sibone ukuthi singasusa kanjani iphesenti yedatha esevele efakwe etafuleni.
Uma sifuna ukukhipha amaphesenti athile kuwo wonke amaseli ekholomu ethile, ke, okokuqala, siba selili elingenalutho etafuleni. Sifaka kuso uphawu "=". Okulandelayo, chofoza kuseli, iphesenti yalo okumelwe lisuswe. Ngemuva kwalokho, faka uphawu "-", bese uchofoza esitokisini esifanayo, esacindezelwe ngaphambili. Sifaka uphawu "*", futhi kusukela kohlobo lwekhibhodi inani lemaphesenti okufanele lisuswe. Ekupheleni kufaka uphawu "%".
Sichofoza inkinobho ye-ENTER, emva kwalokho, izibalo zenziwe, futhi umphumela uyaphuma esitokisini lapho sibhala khona ifomula.
Ukuze ifomula likopishwe kumaseli asele ale kholomu, futhi, ngokufanele, iphesenti lisusiwe kusuka eminye imigqa, siba ekhoneni elingezansi elingakwesokudla selinye lapho sekuvele khona ifomula ebalwa. Chofoza inkinobho yesokunxele kugundane bese uyihudula kuze kube sekupheleni kwetafula. Ngakho-ke, sizobona ezinombolweni zeseli ngayinye ezimelela inani lemali elingaphansi kwekhasi elinqunyiwe.
Ngakho-ke, sibheke amacala amabili amakhulu okukhipha amaphesenti ukusuka kwinombolo ku-Microsoft Excel: njengokubalwa okulula, kanye nokusebenza etafuleni. Njengoba ubona, inqubo yokukhipha isithakazelo ayiyona inkimbinkimbi kakhulu, futhi ukuyisebenzisa kumatafula kusiza ekunciphiseni umsebenzi kubo.
