Fomula mu Excel yochotsera VAT

Nthawi zambiri, ogwiritsa ntchito mu Excel spreadsheet mkonzi amafunika kuchita izi ngati kuchotsa VAT. Zoonadi, izi zikhoza kuchitidwa pogwiritsa ntchito chowerengera chokhazikika, koma ngati mukufuna kuwerengera nthawi zambiri, ndiye kuti ndibwino kugwiritsa ntchito ntchito zomwe zimapangidwira mkonzi. M'nkhaniyi, tisanthula mwatsatanetsatane njira zonse zomwe zimakupatsani mwayi wotsitsa VAT mu chikalata cha spreadsheet.

Fomula yowerengera VAT kuchokera pamisonkho

Poyamba, tiwona momwe tingawerengere VAT kuchokera pamisonkho. Ndikosavuta kugwiritsa ntchito njirayi. M'pofunika kuchulukitsa misonkho ndi mlingo wa khumi ndi zisanu ndi zitatu peresenti. Timapeza formula iyi: "VAT" = "Basi lamisonkho" * 18%. Mumkonzi wa spreadsheet, fomula ikuwoneka motere: = nambala*0,18.

Kusintha kwa "Nambala" ndi chiwerengero cha chiwerengero cha msonkho. M'malo mwa nambala, mutha kufotokoza kugwirizanitsa kwa selo momwe chizindikirocho chilili.

Tiyeni tione chitsanzo chapadera. Tili ndi mizati itatu. Mzere woyamba uli ndi zizindikiro za msonkho. Mu ndime ya 1 pali zizindikiro zomwe zimayenera kuwerengedwa. Gawo lachitatu lili ndi kuchuluka kwa zomwe zapangidwa pamodzi ndi VAT. Kuwerengera kudzapangidwa powonjezera zikhalidwe za 2st ndi 3nd columns.

Malangizo atsatanetsatane amawoneka motere:

1. Timasankha selo loyamba ndi chidziwitso chofunikira. Lowetsani chizindikiro "=", kenako dinani batani lakumanzere pagawo lomwe lili pamzere womwewo wa gawo loyamba. Ma coordinates amalowetsedwa mu fomula. Onjezani chizindikiro "*" kumunda wowerengeka. Pogwiritsa ntchito kiyibodi, timalemba "1%" kapena "18". Chifukwa chake, timapeza formula iyi: =A3*18%.

2. Dinani batani la "Enter" pa kiyibodi kuti muwonetse zotsatira mu cell yomwe mwasankha. Mkonzi wa spreadsheet adzachita ziwerengero zonse zofunika.

3. Dziwani kuti chiwerengerocho chikuwonetsedwa ndi ma decimals 4. Mtengo wandalama uyenera kukhala ndi zilembo ziwiri zokha. Kuti zotsatira zowonetsedwa ziwoneke zolondola, ziyenera kuzunguliridwa mpaka magawo awiri a decimal. Njirayi imagwiridwa ndi ntchito yojambula. Kuti zitheke, tidzapanga ma cell onse momwe chizindikiro chofananira chidzawonetsedwa. Timasankha mitundu ingapo yama cell otere pogwira batani lakumanzere la mbewa. Dinani kumanja kulikonse munjira yomwe mwasankha. Menyu yaying'ono yapadera yowonekera idawonekera pachiwonetsero. Timapeza chinthu chomwe chili ndi dzina la "Cell Format ...", ndikudina ndi batani lakumanzere.

4. Zenera linawonetsedwa pazithunzi za spreadsheet editor, zomwe zimakulolani kuti muchite ndondomeko yojambula. Timapita ku gawo "Nambala". Timapeza mndandanda wa malamulo "Mawonekedwe a Nambala:" ndikusankha chinthu "Numeric" apa. Timayika mtengo "2" pamzere womwe uli ndi dzina "Nambala ya malo a decimal". Kuti mugwiritse ntchito zosintha zonse, dinani batani la "Chabwino" lomwe lili pansi pa mawonekedwe a tebulo.

5. Njira ina ndiyo kugwiritsa ntchito mtundu wa ndalama. Zimakupatsaninso mwayi wowonetsa zonse ndi 2 decimals. Timapita ku gawo "Nambala". Timapeza mndandanda wa malamulo "Mawonekedwe a Nambala:" ndikusankha chinthu "Ndalama" apa. Timayika mtengo "2" pamzere womwe uli ndi dzina "Nambala ya malo a decimal". Mu gawo la "Designation", timayika ruble. Apa mutha kukhazikitsa ndalama zilizonse. Kuti mugwiritse ntchito zosintha zonse, dinani "Chabwino".

6. Zotsatira za matembenuzidwe okhala ndi mtundu wa manambala:

7. Zotsatira zosinthika ndi mtundu wa ndalama:

8. Timakopera fomula ku maselo otsalawo. Sunthani cholozera pakona yakumanja kwa selo ndi fomula. Cholozeracho chinatenga mawonekedwe ang'onoang'ono kuphatikiza chizindikiro cha mthunzi wakuda. Mothandizidwa ndi batani lakumanzere lokanikiza, timatambasula chilinganizo mpaka kumapeto kwa tebulo.

9. Okonzeka! Tinatambasula chilinganizo ku maselo onse a gawoli.

10. Ndikofunikira kukhazikitsa ndondomeko yowerengera kuchuluka kwa mtengowo pamodzi ndi VAT. Timadina LMB pa selo yoyamba ya "Ndalama yokhala ndi VAT". Lowetsani chizindikiro cha "=", dinani pagawo loyamba la gawo la "Taxation base". Timayendetsa chizindikiro cha "+", kenako dinani LMB pagawo loyamba la gawo lachiwiri. Chifukwa chake, timapeza formula iyi: = A3+V3.

11. Dinani batani la "Enter" kuti muwonetse zotsatira mu cell yomwe mwasankha. Mkonzi wa spreadsheet adzachita ziwerengero zonse zofunika.

12. Mofananamo, timakopera ndondomekoyi ku maselo otsalawo. Sunthani cholozera pakona yakumanja kwa selo ndi fomula. Cholozeracho chinatenga mawonekedwe ang'onoang'ono kuphatikiza chizindikiro cha mthunzi wakuda. Mothandizidwa ndi batani lakumanzere lokanikiza, timatambasula chilinganizo mpaka kumapeto kwa tebulo.

Njira zina zokhudzana ndi kuchotsera VAT

Pali njira zina zingapo zomwe zimakulolani kuti mugwiritse ntchito njira yochotsera VAT. Nthawi yomweyo, tikuwona kuti kutsatizana kwa zochita kuli kofanana ndi chitsanzo pamwambapa. Ndi mafomu ena, mbale yokhayo yokhayo imasintha, ndipo zochita zonse zokhudzana ndi kusintha mawonekedwe ndi kutambasula mawonekedwe ku maselo ena zimakhala zofanana.

Njira yowerengera kuchuluka kwa VAT pamtengo womwe msonkho waphatikizidwa kale ikuwoneka motere: "VAT" = "Ndalama zokhala ndi VAT" / 118% x 18%. Mumkonzi wa spreadsheet, fomula ikuwoneka motere: =nambala/118%*18%.

Njira yowerengera kuchuluka kwa msonkho kuchokera pamisonkho ikuwoneka motere: "Ndalama zokhala ndi VAT" = "Msonkho" x 118%. Mumkonzi wa spreadsheet, fomula ikuwoneka motere: = nambala * 118%.

Njira yowerengera misonkho kuchokera pamtengo ndi msonkho imawoneka motere: "Msonkho" = "Ndalama zokhala ndi VAT" / 118%. Mumkonzi wa spreadsheet, fomula ikuwoneka motere: = chiwerengero/118%.

Mapeto ndi ziganizo pa njira yochotsera VAT mumkonzi wa spreadsheet

Mkonzi wa spreadsheet amakulolani kuti mumalize mwachangu njira yochotsera VAT. Pulogalamuyi imakulolani kuti mugwiritse ntchito njira iliyonse yomwe ilipo kuti muwerengere chizindikirochi. Chinthu chachikulu ndikutha kusintha mawonekedwe a selo ndikugwira ntchito moyenera ndi mzere wolowetsa mafomu.