Vat formula muri excel

Kimwe mu bipimo byinshi bikenerwa bikenewe guhangana nabacungamari, abakozi bashinzwe imisoro n'abiyemezamirimo bigenga ni umusoro ku gaciro. Kubwibyo, ikibazo cyo kubara cyacyo kibareba, kimwe no kubara ibindi bipimo bifitanye isano nayo. Urashobora gukora iyi calculatrice kumafaranga imwe ukoresheje calculatrice isanzwe. Ariko, niba ukeneye kubara vat mu ndangagaciro nyinshi zamafaranga, noneho bizagira ikibazo cyane na calculatrice imwe. Byongeye kandi, imashini ibarwa ntabwo inoze gukoresha.

Kubwamahirwe, muri extl, urashobora kwihutisha cyane kubara ibisubizo bisabwa kumakuru yinkomoko, iri kurutonde. Reka tumenye uko twabikora.

Uburyo bwo kubara

Mbere yo gukomeza kubara, reka tumenye icyo kwishyura imisoro. Umusoro ku nyongeragaciro ni umusoro utaziguye, wishyura ibicuruzwa n'ibicuruzwa bitarenze umubare wibicuruzwa byagurishijwe. Ariko abaheruka kuba abaguzi, kubera ko agaciro k'ubwishyurwa imisoro bimaze gushyirwa mubiciro byabicuruzwa cyangwa serivisi byaguzwe.

Muri Federasiyo y'Uburusiya muri iki gihe hari igipimo cy'umusoro ku kigero cya 18%, ariko mu bindi bihugu by'isi bishobora gutandukana. Urugero, muri Otirishiya, Ubwongereza, Ukraine na Biyelorusiya, bingana na 20%, mu Budage - 19%, muri Hongiriya - 12%. Ariko kubara tuzakoresha igipimo cy'umusoro bijyanye n'Uburusiya. Ariko, muguhindura igipimo cyinyungu, ayo magambo yibarwa azagaragazwa hepfo arashobora kandi gukoreshwa mubindi bihugu byisi, ikoresha ubu bwoko bwo gusoresha.

Ni muri urwo rwego, imirimo y'ibanze ishyikirizwa abacungamari, abakozi ba serivisi z'imisoro na ba rwiyemezamirimo mu bihe bitandukanye:

• Kubara twihindagurira ku giciro nta misoro;
• Kubara vat kuva ku giciro umusoro umaze kubamo;
• Kubara amafaranga nta vatari mubiciro bimaze kubamo;
• Kubara amafaranga hamwe na vat kuva ikiguzi nta misoro.

Mugukora imibare ibanziriza Excele, tuzakomeza kandi dukora.

Uburyo 1: Kubara TVA uhereye kumusoro

Mbere ya byose, reka tumenye uburyo bwo kubara vat bava mumisoro. Biroroshye rwose. Gukora iki gikorwa, ugomba kugwiza igipimo cy'umusoro ku gipimo cy'imisoro, gifite 18% mu Burusiya, cyangwa nimero 0.18. Rero, dufite formula:

"Vat" = "Umusoro Wimisoro" x 18%

Kuri excel, formulaire yo kubara izafata ifishi ikurikira

= umubare * 0.18

Mubisanzwe, "umubare" kugwiza umubare nimvugo yumubare wumusoro cyangwa ihuriro ryikanguzi aho iyi shusho iherereye. Reka tugerageze gushyira mubikorwa ubwo bumenyi mubikorwa byameza. Igizwe ninkingi eshatu. Iya mbere ni indangagaciro zizwi cyane. Mubya kabiri indangagaciro wifuza ko dukwiye kubara. Inkingi ya gatatu izaba umubare wibicuruzwa hamwe nigiciro cyimisoro. Ntabwo bigoye gukeka, birashobora kubarwa wongeyeho amakuru yinkingi yambere na kabiri.

1. Hitamo selile yambere yumuvugizi hamwe namakuru asabwa. Dushyize ikimenyetso "=" muriyo, hanyuma ukande ku kagari kumurongo umwe uhereye ku nkingi shingiro. Nkuko mubibona, adresse ye yahise yinjizwa muri kiriya kintu turimo kubara. Nyuma yibyo, muri selile yo gutura, washyizeho ikimenyetso cyo kugwiza excel (*). Ibikurikira, gutwara kuva kuri clavier ubunini bwa "18%" cyangwa "0.18". Ku iherezo, formula kuva kururugero yafashe ubu bwoko:

   = A3 * 18%

   Mubibazo byawe, bizaba bimwe usibye ikintu cya mbere. Aho kugira ngo "a3", hashobora kubaho ibindi bihuza, bitewe aho umukoresha yashyizeho amakuru akubiyemo imisoro.



2. Nyuma yibyo, kugirango werekane ibisubizo byuzuye muri kasho, kanda urufunguzo rwinjira kuri clavier. Ibisabwa bisabwa bizahita bikozwe na gahunda.



3. Nkuko mubibona, ibisubizo bivanwa nibimenyetso bine byangirika. Ariko, nkuko mubizi, uhuza amafaranga hamwe birashobora kugira ibimenyetso bibiri gusa (igiceri). Kugira ngo ibisubizo byacu aribyo, ugomba kuzenguruka ibimenyetso bibiri bya cumi. Bikore ukoresheje imiterere. Kugirango tutagarukira kuri iki kibazo nyuma, gabanya selile zose zigenewe gushyiramo indangagaciro icyarimwe.

   Hitamo urutonde rwameza yagenewe gushyira indangagaciro. Kanda buto yimbeba iburyo. Ibikubiyemo byatangijwe. Hitamo ikintu "imiterere ingirabuzimafatizo" muri yo.



4. Nyuma yibyo, idirishya ryatangijwe. Himura muri "Umubare" niba wafunguye izindi tab zose. Muri "imiterere ya numero", washyizeho switch kuri "numero". Ibikurikira, turagenzura ko mugice cyiza cyidirishya muri "umubare wibimenyetso icumi" byahagaze umubare "2". Agaciro kagomba kuba gasuzuguro, ariko mugihe gikwiye kugenzura no kubihindura niba hari umubare ugaragara aho, kandi ntabwo ari 2. Kanda kuri buto ya "OK" hepfo yidirishya.

   

   Urashobora kandi gushiramo amafaranga muburyo bwumubare. Muri iki kibazo, imibare nayo izerekanwa nibimenyetso bibiri byacika. Kugira ngo dukore ibi, twongeye gutondekanya switch muri "Imiterere yumubare" muri "amafaranga". Nkuko byavuzwe haruguru, tureba "umubare wibimenyetso icumi" mumurima "2". Twitondera kandi ko ikimenyetso rusange cyashyizwe mu murima "Igenamigambi", niba, byanze bikunze, mutagomba kuba byiza gukorana nindi mafaranga. Nyuma yibyo, kanda kuri buto "OK".



5. Niba ukoresheje amahitamo ukoresheje imiterere yumubare, umubare wose uhinduka indangagaciro hamwe nibimenyetso bibiri.

   

   Mugihe ukoresheje format ya cash, impinduka rwose zizabaho, ariko ikimenyetso cyamafaranga yatoranijwe azongerwaho indangagaciro.



6. Ariko, mugihe twabaze umusoro ku gaciro wongeyeho gusa agaciro kamwe k'imisoro. Noneho dukeneye kubikora kubindi bihugu byose. Birumvikana, urashobora kwinjiza formulaire imwe ya genalogiya nkuko twabikoze bwa mbere, ariko kubara muri Excel biratandukanye kubibara bisanzwe muri make birashobora kwihutisha cyane ishyirwa mubikorwa ryibikorwa bimwe. Kugirango ukore ibi, kopi yo gukoporora ukoresheje ikimenyetso cyuzuye.

   Dushiraho indanga kumutwe wo hepfo yicyo kintu cyurupapuro aho formula isanzwe irimo. Muri iki gihe, indanga igomba guhinduka kumusaraba muto. Ubu ni ikimenyetso cyuzuye. Kanda buto yimbeba yibumoso hanyuma uyikwegera hepfo yimeza.



7. Nkuko mubibona, nyuma yo gukora iki gikorwa, agaciro kasabwa kazabarwa kubera indangagaciro zose zimisoro, ziboneka mumeza yacu. Rero, twabaze icyerekezo cyamafaranga arindwi agaciro byihuse kuruta uko byakorwa kuri calculatrice cyangwa, cyane cyane, intoki kurupapuro rwimpapuro.



8. Noneho tuzakenera kubara umubare wuzuye wagaciro hamwe numusoro. Kugirango dukore ibi, tugaragaza ikintu cyambere cyubusa muri "amafaranga hamwe na vat". Dushyize ikimenyetso "=", kanda kuri selire ya mbere y "umusoro", shyira ikimenyetso "+", hanyuma ukande kuri selire ya mbere yinkingi yinkingi ya VET. Kutubwacu, imvugo ikurikira yagaragaye mubintu kugirango yerekane ibisubizo:

   = A3 + b3

   Ariko, birumvikana, muri buri kibazo, aderesi ya selile irashobora gutandukana. Kubwibyo, mugihe ukora umurimo usa, uzakenera gusimbuza imikoreshereze yawe yimpapuro zijyanye.



9. Ibikurikira, kanda kuri buto yinjira kuri clavier kugirango ubone ibisubizo byuzuye byibabare. Rero, agaciro k'ikiguzi hamwe n'umusoro ku gaciro ka mbere kibarwa.



10. Kugirango tubare amafaranga hamwe numusoro ku gaciro hamwe nizindi ndangagaciro, dukoresha ikimenyetso cyuzuye, nkuko tumaze gukora kubibara mbere.

Rero, twabaze indangagaciro zisabwa kurigaciro karindwi k'umusoro. Byasaba umwanya munini kuri calculatrice.

Isomo: Nigute ushobora guhindura imiterere yimodoka muri Excel

Uburyo 2: kubara umusoro ku bunini hamwe na vat

Ariko hariho ibibazo mugihe umubare wa vati mumafaranga ugomba kubarwa kugirango ugabanye imisoro kumafaranga uyu musoro ushizemo. Noneho formulation yo kubara izasa nkiyi:

"Vat" = "amafaranga hamwe na vat" / 118% x 18%

Reka turebe uko iyi mibare ishobora gukorwa ukoresheje ibikoresho byoroshye. Muri iyi gahunda, formulaire yo kubara izaba ifite uburyo bukurikira:

= umubare / 118% * 18%

Nkimpaka, "umubare" nigiciro kizwi cyikiguzi cyibicuruzwa hamwe numusoro.

Kurugero rwo kubara, fata kumeza yose. Gusa ubu muriyo bizaba byuzuyemo inkingi "amafaranga hamwe na vat", nindangagaciro zinkingi "vat" n "umusoro" tugomba kubara. Dufata ko selile Akagari kamaze gutondekwa mumafaranga cyangwa imibare hamwe nibimenyetso bibiri byacika, kugirango tutazakora ubu buryo.

1. Dushiraho indanga muri selire yambere yinkingi hamwe namakuru asabwa. Twinjije formula hari (= umubare / 118% * 18%) muburyo bumwe bwakoreshejwe muburyo bwambere. Ni ukuvuga, nyuma yikimenyetso, dushyira ihuriro ku kagari agaciro gahuye kagaciro k'ibicuruzwa hamwe n'umusoro uherereye, hanyuma hamwe na clavier ongeramo imvugo "/ 118% * 18%" idafite amagambo. Ku bitureba, byaje kugaragara ibyakurikiyeho:

   = C3 / 118% * 18%

   Mubisobanuro byagenwe, bitewe nurubanza n'aho byinjiza amakuru ku rupapuro rwa Exel, gusa umurongo wa selire gusa urashobora guhinduka.



2. Nyuma yibyo, kanda kuri buto yintonde. Igisubizo kibarwa. Byongeye kandi, kimwe nuburyo bwambere, ukoresheje gukoresha kuzura ikimenyetso, kopi formula mubindi bigo byinkingi. Nkuko mubibona, indangagaciro zose zisabwa zirabarwa.



3. Ubu dukeneye kubara amafaranga nta mushahara wumusoro, ni ukuvuga umusoro. Bitandukanye nuburyo bwambere, iki kimenyetso ntigishobora kubarwa, ariko mugihe ukoresheje gukuramo. Kubwibi ukeneye uhereye kumafaranga yose adafite umusoro wenyine.

   Rero, twashizeho indanga muri selire ya mbere yinkingi yimisoro. Nyuma ya "=" Ikimenyetso, turimo gukuramo amakuru muri selire ya mbere yinkingi yagaciro kagaciro mubintu byambere byinkingi ya vat. Mu karorero kacu, iyi ni imvugo hano:

   = C3-b3

   Kugaragaza ibisubizo, ntukibagirwe gukanda urufunguzo rwa Enter.



4. Nyuma yibyo, muburyo busanzwe bukoresha ikimenyetso cyuzuye, kopi yindi ngingo kubindi bintu byinkingi.

Igikorwa gishobora gufatwa nkigikeshwa.

Uburyo 3: Kubara Indangagaciro ZIKURIKIRA

Akenshi kubara amafaranga hamwe numusoro ku gaciro, ufite agaciro k'umusoro. Ibi ntibikeneye kubara umubare wimisoro yo kwishyura ubwayo. Itondekanya kubara irashobora guhagararirwa muri iyi fomu:

"Amafaranga hamwe na Vat" = "Umusoro w'imisoro" + "Umusoro Wipimi" x 18%

Urashobora koroshya formula:

"Amafaranga hamwe na Vat" = "Umusoro ushinga" x 118%

Muri Excel, bizasa nkibi:

= umubare * 118%

Impaka "Umubare" ni ishingiro risoreshwa.

Kurugero, fata imbonerahamwe imwe, gusa udafite inkingi "vat", kubera ko itazakenerwa niyi mibare. Indangagaciro zizwi zizaba ziri mu nkingi y'imisoro, kandi igihe cyifuzwa - mu nkingi "hamwe na vat".

1. Hitamo selile yambere yinkingi hamwe namakuru asabwa. Dushiraho ikimenyetso "=" no kwerekeza kuri selire ya mbere yinkingi ya bateri yimisoro. Nyuma yibyo, tumenyekanisha imvugo tudafite amagambo "* 118%". Mu rubanza rwacu, imvugo yabonetse:

   = A3 * 118%

   Kugaragaza ibisubizo kurupapuro, kanda kuri buto yinjira.



2. Nyuma yibyo, dukoresha ikimenyetso cyuzuye kandi dukore kopi yamakuru yamenyerejwe kumurongo wose winkingi hamwe nibipimo byabazwe.

Rero, umubare wikiguzi cyibicuruzwa, harimo numusoro, cyabazwe kubwindangagaciro zose.

Uburyo 4: kubara umusoro ku misoro

Birasa cyane kubara umusoro ku giciro hamwe numusoro urimo. Nubwo bimeze bityo ariko, iyi mibare ntabwo isanzwe, natwe tuzabitekereza.

Formula yo kubara umusoro kuva ikiguzi, aho umusoro umaze kubamo, birasa nkibi:

"Umusoro usosiyete" = "amafaranga hamwe na vat" / 118%

Muri Excel, iyi formula izafata ubwoko:

= umubare / 118%

Nkigice "nimero", agaciro kagaciro k'ibicuruzwa kizirikana umusoro.

Kubara, dusaba neza imbonerahamwe imwe nkuburyo bwabanjirije, iki gihe, amakuru azwi azwi cyane mu nkingi "hamwe na vati", hamwe na vat ya bateri yumusaruro.

1. Dutanga impaka yibintu byambere byinkingi shingiro yimisoro. Nyuma yikimenyetso "=" andika imirongo ya selile yambere yindi nkingi. Nyuma yibyo, tumenyekanisha imvugo "/ 118%". Kugirango usohoze hamwe nibisubizo byibisubizo kuri monitor, urashobora gukanda urufunguzo rwa Enter. Nyuma yibyo, agaciro ka mbere k'igiciro kidafite umusoro kibarwa.



2. Kugirango tubare mubice bisigaye, nko mu manza zabanjirije, koresha ikimenyetso cyuzuye.

Noneho twabonye ameza aho ikiguzi cyibicuruzwa kidafite umusoro kibarwa ako kanya imyanya irindwi.

Isomo: Kora hamwe na formulaire muri excel

Nkuko mubibona, uzi ibyingenzi byo kubara umusoro ku gaciro hamwe nibipimo bifitanye isano, kugirango uhangane numurimo wo kubara muri Excel biroroshye. Mubyukuri, kubara algorithm ubwayo, mubyukuri, ntabwo bitandukanye cyane no kubara kuri calculatrice isanzwe. Ariko, imikorere mumitunganyirize ya tabular ifite inyungu zimwe kurenza kubara. Irari mubyukuri ko kubara indangagaciro amagana bitafata igihe kirekire kuruta kubara. Muri excel, mubyukuri kumunota, umukoresha azashobora kubara imisoro kumwanya wijana nukwitabira igishushanyo nkicyo cyuzuzanya, mugihe kubara amakuru nkaya kuri calculatrice yoroshye irashobora gufata igihe isaha. Mubyongeyeho, muri Excel, urashobora gukosora kubara uzigama hamwe na dosiye itandukanye.