Ifomula ku-Excel yokudonsa i-VAT

Ngokuvamile, abasebenzisi abasebenza kusihleli sespredishithi se-Excel badinga ukwenza inqubo efana nokudonsa i-VAT. Yiqiniso, lesi senzo singenziwa ngokusebenzisa umshini wokubala ovamile, kodwa uma udinga ukwenza ukubala okunjalo izikhathi eziningi, ngakho-ke kungcono kakhulu ukusebenzisa imisebenzi eyakhelwe kumhleli. Esihlokweni, sizohlaziya ngokuningiliziwe zonke izindlela ezikuvumela ukuthi usebenzise ukudonswa kwe-VAT kudokhumenti yesipredishithi.

Ifomula yokubala i-VAT kusuka kusisekelo sentela

Ekuqaleni, sizonquma ukuthi siyibala kanjani i-VAT esisekelweni sentela. Kulula kakhulu ukusebenzisa le nqubo. Kudingeka ukuphindaphinda isisekelo sentela ngesilinganiso samaphesenti ayishumi nesishiyagalombili. Sithola ifomula elandelayo: “VAT” = “Isisekelo sentela” * 18%. Kumhleli wespredishithi, ifomula ibonakala kanje: =inombolo*0,18.

Okuguquguqukayo "Inombolo" yinani lenombolo lesisekelo sentela. Esikhundleni senombolo, ungacacisa ukuxhumanisa kweseli lapho inkomba ngokwayo itholakala khona.

Ake sibheke isibonelo esithile. Sinezinsika ezintathu. Ikholomu yoku-1 iqukethe izinkomba zesisekelo sentela. Kukholomu yesi-2 kunezinkomba ezifunwayo ezidinga ukubalwa. Ikholomu yesi-3 iqukethe inani lokukhiqiza kanye ne-VAT. Isibalo sizokwenziwa ngokungeza amanani wekholomu yoku-1 neyesi-2.

Imiyalelo enemininingwane ibukeka kanje:

1. Sikhetha iseli 1 ngolwazi oludingekayo. Faka uphawu “=", bese uchofoza inkinobho yegundane kwesokunxele enkundleni esemgqeni ofanayo wekholomu yokuqala. Izixhumanisi zifakwa kufomula. Engeza uphawu “*” endaweni ebaliwe. Sisebenzisa ikhibhodi, sibhala "18%" noma "0,18". Ngenxa yalokho, sithola ifomula elandelayo: =A3*18%.

2. Cindezela inkinobho ethi "Enter" kukhibhodi ukuze ubonise umphumela kuseli ekhethiwe. Umhleli wespredishithi uzokwenza zonke izibalo ezidingekayo.

3. Qaphela ukuthi isamba siboniswa ngamadesimali angu-4. Inani lemali kufanele libe nezinhlamvu zamadesimali ezi-2 kuphela. Ukuze umphumela obonisiwe ubukeke ulungile, kufanele ufinyezwe ezindaweni zedesimali ezi-2. Le nqubo yenziwa ngokusebenza kokufometha. Ukuze kube lula, sizofometha wonke amaseli lapho kuzoboniswa khona inkomba efanayo. Sikhetha ububanzi bamaseli anjalo ngokucindezela inkinobho yegundane engakwesokunxele. Chofoza kwesokudla noma yikuphi ebangeni elikhethiwe. Imenyu encane yokuqukethwe ekhethekile ivele esibukweni. Sithola i-elementi enegama elithi “Ifomethi Yeseli …”, bese uchofoza kuyo ngenkinobho yegundane engakwesokunxele.

4. Iwindi liye lavezwa esikrinini somhleli wespredishithi, elikuvumela ukuba wenze inqubo yokufometha. Sithuthela esigatshaneni "Inombolo". Sithola uhlu lwemiyalo "amafomethi wezinombolo:" bese ukhetha into ethi "Numeric" lapha. Setha inani elithi "2" emugqeni onegama elithi "Inani lezindawo zamadesimali". Ukuze usebenzise zonke izinguquko, chofoza inkinobho ethi "KULUNGILE" etholakala ezansi kusixhumi esibonakalayo somhleli wethebula.

5. Enye inketho ukusebenzisa ifomethi yemali. Iphinde ikuvumela ukuthi ubonise inani ngamadesimali angu-2. Sithuthela esigatshaneni "Inombolo". Sithola uhlu lwemiyalo “Amafomethi enombolo:” bese ukhetha into ethi “Uhlobo lwemali” lapha. Setha inani elithi "2" emugqeni onegama elithi "Inani lezindawo zamadesimali". Kupharamitha ethi "Designation", sibeka i-ruble. Lapha ungasetha ngokuphelele noma iyiphi imali. Ukuze usebenzise zonke izinguquko, chofoza "KULUNGILE".

6. Umphumela wokuguqulwa onefomethi yenombolo:

7. Umphumela wokuguqulwa ngefomethi yemali:

8. Sikopisha ifomula kumaseli asele. Hambisa isikhombisi ekhoneni elingezansi kwesokudla seseli ngefomula. Isikhombi sithathe isimo sophawu oluncane lokuhlanganisa lomthunzi omnyama. Ngosizo lwenkinobho yegundane yesokunxele ecindezelwe, selula ifomula kuze kube sekupheleni kwetafula.

9. Ilungile! Selulela ifomula kuwo wonke amaseli ale kholomu.

10. Kusele ukuqalisa inqubo yokubala inani eliphelele lentengo kanye ne-VAT. Sichofoza i-LMB kuseli lokuqala lekholomu “Inani eline-VAT”. Faka uphawu "=", chofoza inkambu yokuqala yekholomu "Isisekelo sentela". Sishayela kuphawu "+", bese uchofoza i-LMB endaweni yokuqala yekholomu yesibili. Ngenxa yalokho, sithola ifomula elandelayo: = A3+V3.

11. Cindezela inkinobho ethi "Enter" ukuze ubonise umphumela kuseli ekhethiwe. Umhleli wespredishithi uzokwenza zonke izibalo ezidingekayo.

12. Ngokufanayo, sikopisha ifomula kumaseli asele. Hambisa isikhombisi ekhoneni elingezansi kwesokudla seseli ngefomula. Isikhombi sithathe isimo sophawu oluncane lokuhlanganisa lomthunzi omnyama. Ngosizo lwenkinobho yegundane yesokunxele ecindezelwe, selula ifomula kuze kube sekupheleni kwetafula.

Amanye amafomula ahlobene nokubanjwa kwe-VAT

Kunamanye amafomula amaningana akuvumela ukuthi usebenzise ifomula yokudonsa i-VAT. Ngokushesha, siyaqaphela ukuthi ukulandelana kwezenzo kuyafana nalesi sibonelo esingenhla. Ngamanye amafomula, ipuleti langempela kuphela elishintshayo, futhi zonke izenzo ezihlobene nokushintsha ifomethi nokwelula ifomula kwamanye amaseli zihlala zifana.

Ifomula yokubala inani le-VAT enanini intela esivele ifakiwe libukeka kanje: “I-VAT” = “Inani eline-VAT” / 118% x 18%. Kumhleli wespredishithi, ifomula ibonakala kanje: =inombolo/118%*18%.

Ifomula yokubala inani lentela kusuka kusisekelo sentela libukeka kanje: “Inani eline-VAT” = “Isisekelo sentela” x 118%. Kumhleli wespredishithi, ifomula ibonakala kanje: =inombolo*118%.

Ifomula yokubala isisekelo sentela enanini elinentela libukeka kanje: “Isisekelo sentela” = “Inani eline-VAT” / 118%. Kumhleli wespredishithi, ifomula ibonakala kanje: =inombolo/118%.

Isiphetho neziphetho ngenqubo yokudonswa kwe-VAT kumhleli wespredishithi

Umhleli wespredishithi ukuvumela ukuthi uqedele ngokushesha inqubo yokudonswa kwe-VAT. Uhlelo lukuvumela ukuthi usebenzise ngokuphelele noma iyiphi ifomula ekhona ukuze ubale le nkomba. Into eyinhloko ukwazi ukushintsha ifomethi yeseli futhi usebenze ngendlela efanele ngomugqa wokufaka amafomula.