Vat formula ku Excel

Chimodzi mwazomwe zimawonetsera zomwe ndizofunikira kuthana ndi owerengera ndalama, ogwira ntchito zapa msonkho komanso mabizinesi apadera ndi msonkho wowonjezera. Chifukwa chake, nkhani yowerengera yake imakhala yofunika kwa iwo, komanso kuwerengera zizindikiro zina zokhudzana ndi izo. Mutha kupanga cholembera ichi kuti mupeze ndalama imodzi pogwiritsa ntchito chowerengera wamba. Koma, ngati mukufuna kuwerengera VAT muyezo wa ndalama, ndiye kuti zimapangitsa kuti zikhale zovuta kwambiri zowerengera imodzi. Kuphatikiza apo, makina owerengeka siabwino kugwiritsa ntchito.

Mwamwayi, excel, mutha kufuula bwino kwambiri pazotsatira zofunika pazinthu zomwe zalembedwa, zomwe zalembedwa patebulo. Tiyeni tiwone momwe mungachitire.

Ndondomeko Zowerengera

Musanafike mwachindunji ku kuwerengera, tiyeni tipeze zomwe msonkho wanenedwa. Misonkho yowonjezeredwa ndi msonkho wosawoneka bwino, zomwe zimalipira katundu ndi ntchito zomwe zimagulitsidwa. Koma olipira enieni ndi ogula, popeza phindu la malipiro limaphatikizidwa kale pamtengo wogulitsa kapena ntchito.

Mu Russian Federation pakadali pano pali misonkho mu 18%, koma m'maiko ena padziko lapansi zitha kusiyanasiyana. Mwachitsanzo, ku Austria, Great Britain, Ukraine ndi Belaruus, ndizofanana ndi 20%, ku Germany - 19%, ku Kazakhstan - 12%. Koma pa kuwerengera tidzagwiritsa ntchito mtengo wamsonkho ku Russia. Komabe, mwakusintha chiwongola dzanja, algorithy a algorithts omwe adzawerengedwe pansipa angagwiritsidwenso ntchito kwa dziko lina lililonse lapansi, lomwe limagwiritsa ntchito msonkho wamtunduwu.

Pankhani imeneyi, ntchito zoterezi zimayikidwa kuti aziwerengera ndalama, antchito a ntchito za msonkho ndi akabwanja m'njira zosiyanasiyana:

Kuwerengetsa kwa ma vat pa mtengo wopanda msonkho;
Kuwerengera kwa VAT kuchokera pamtengo womwe msonkho waphatikizidwa kale;
Kuwerengetsa ndalamazo popanda VAT kuchokera ku mtengo womwe msonkho waphatikizidwa kale;
Kuwerengera kwa kuchuluka kwa VAT kuchokera pamtengo wopanda msonkho.

Mwa kuwerengera deta pa bwino, tidzapitilizanso ntchito.

Njira 1: Kuwerengera kwa Vat kuchokera pamsonkho

Choyamba, tiyeni tipeze momwe mungawerengere ku Vat kuchokera pamunsi. Sizophweka. Kuti muchite ntchito imeneyi, muyenera kuchulukitsa msonkho kwa msonkho, womwe ndi 18% ku Russia, kapena nambala 0.18. Chifukwa chake, tili ndi njira:

"VAT" = "Tsoka" X 18%

Pazabwino, njira yowerengera imatenga fomu yotsatirayi

= nambala * 0.18

Mwachilengedwe, nambala ya "nambala ya" yochulukitsa ndi mawu a msonkho wa msonkho kapena ulalo wa selo yomwe chiwerengerochi chimapezeka. Tiyeni tigwiritse ntchito izi pochita izi pokonzekera tebulo linalake. Ili ndi mizati itatu. Choyamba ndi malingaliro odziwika a malo amphongo. M'chiwiri chomwe mukufuna kudziwa. Chingwe chachitatu chidzakhala kuchuluka kwa katundu pamodzi ndi msonkho. Sizovuta kungoyerekeza, zitha kuwerengeredwa powonjezera kuchuluka kwa mzati woyamba ndi wachiwiri.

Gome la kuwerengera VAT mu Microsoft Excel

Sankhani selo yoyamba ya wokamba nkhaniyo ndi zomwe mukufuna. Timayika chikwangwanicho Monga mukuwonera, adilesi yake imalowa pomwepo komwe timawerengera. Pambuyo pake, m'chipinda chokhazikika, mumakhazikitsa chizindikiro chochulukitsa (*). Kenako, yendetsani kuchokera pa kiyibodi kukula kwa "18%" kapena "0.18". Pamapeto pake, njirayi ya Yesu idatenga mtundu uwu:
= A3 * 18%
M'malo mwanu, zidzakhala chimodzimodzi pokhapokha chifukwa cha chinthu choyamba. M'malo mwa "A3", pakhoza kukhala malo ena ogwirizanitsa, kutengera komwe wogwiritsa ntchito watumiza deta yomwe ili ndi msonkho.

Pambuyo pake, kuwonetsa zotsatira zomalizidwa mu khungu, dinani kiyi ya Enter pa kiyibodi. Kuwerengera kofunikira kumapangidwa nthawi yomweyo ndi pulogalamuyo.

Zotsatira za kuwerengera VAT mu Microsoft Excel

Monga mukuwonera, zotsatira zake zimachokera ndi zizindikiro zinayi. Koma, monga mukudziwa, chibwibwi chachuma chitha kukhala ndi zizindikiro ziwiri zokha (Penny). Kotero kuti zotsatira zathu zili zolondola, muyenera kuzungulira mpaka zizindikiro ziwiri. Pangani kuti mugwiritse ntchito mawonekedwe a cell. Pofuna kuti musabwerenso patsamba lino, mtundu wa maselo onse omwe akufuna kuti aikidwe ndalama nthawi imodzi.
Sankhani gulu lonse la tebulo lopangidwa kuti liziyika zidziwitso za manambala. Dinani batani lamanja. Zosankha zamitunduyo zayambitsidwa. Sankhani chinthucho "mitundu ya mitundu" mkati mwake.

Kusintha kwa mtundu wa maselo mu Microsoft Excel

Pambuyo pake, zenera lopanga limayambitsidwa. Pitani mu "nambala" tabu ngati itatsegulidwa mu tabu ina iliyonse. Mu "mitundu ya manambala", mumasinthiratu kupita ku "nomeric" udindo. Kenako, timayang'ana kumbali yoyenera yazenera pawindo "chiwerengero cha zizindikiro za derimal" chinayima nambala ya "2". Mtengo uwu uyenera kukhala wosasunthika, koma ngati kuli koyenera kuyang'ana ndikusintha ngati nambala ina iliyonse ikuwonetsedwa pamenepo, osati 2. Dinani batani la "Ok" pansi pazenera.

Mutha kuphatikizanso ndalama mu mawonekedwe a manambala. Pankhaniyi, kuchuluka kwa manambala kumawonetsedwanso ndi zizindikiro ziwiri. Kuti tichite izi, timakonzanso kusinthaku mu "mitundu ya manambala" mu "maudindo". Monga momwe zidayambiranso, timayang'ana "zizindikiro za decomal" mumunda "2". Timasamalanso kuti chizindikiro cha Ruble chidayikidwa mu gawo la "Mayina", ngati, inde, simukugwira ntchito ndi ndalama zina. Pambuyo pake, dinani batani la "OK".

Ngati mungagwiritse ntchito njira pogwiritsa ntchito mtundu wa manambala, ndiye kuti manambala onse amasinthidwa kukhala zizindikiro ziwiri ndi zizindikiro ziwiri.

Mukamagwiritsa ntchito mtundu wa ndalama, kusinthika komwe komweko kudzachitika, koma chizindikiro cha ndalama zomwe zasankhidwa zidzawonjezeredwa pazikhalidwe.

Zambiri zimasinthidwa kukhala mtundu wa ndalama mu Microsoft Excel

Koma, pamene tidawerengera mtengo wowonjezerera ndalama imodzi yokha yamisonkho. Tsopano tiyenera kuchita izi pazochuluka zina zonse. Zachidziwikire, mutha kulowa nawo gawo lomwelo momwe tidachitira kwa nthawi yoyamba, koma kuwerengera ku Excel kusiyanasiyana kuchokera ku kuwerengetsa kwa chizolowezi chambiri chifukwa pulogalamuyi imatha kufufuta kwambiri pazomwezo. Kuti muchite izi, gwiritsani ntchito kukopera pogwiritsa ntchito cholembera.
Timakhazikitsa cholozera ku mbali yapansi ya chinthucho chomwe foloko ili kale. Pankhaniyi, zonena ziyenera kusinthidwa kukhala mtanda waung'ono. Ichi ndi cholembera. Dinani batani lamanzere ndikukoka pansi patebulo.

Monga mukuwonera, mukatha kuchita izi, mtengo wofunikira udzawerengedwa chifukwa cha zinthu zonse za msonkho, zomwe zimapezeka pagome lathu. Chifukwa chake, tidawerengera chizindikiro cha ndalama zisanu ndi ziwiri mwachangu kwambiri kuposa momwe zimachitikira pa Calculator kapena, makamaka, pamapepala pepala.

Vat pazomwe zimapangidwa ndi Microsoft Excel

Tsopano tifunika kuwerengera ndalama zonse pamodzi ndi msonkho. Kuti tichite izi, tikuwonetsa chinthu choyamba chopanda kanthu mu "ndalama ndi vat". Timayika chikwangwani "=", dinani seloni yoyamba ya "msonkho" kuti ukhale chizindikiro cha "+" ndikudina foni yoyamba ya mzere wa VAT. Kwa ife, mawu otsatirawa adawonekera mu chinthu chomwe chikuwonetsa zotsatira zake:
= A3 + B3
Koma, zoona, nthawi zonse, adilesi ya maselo imasiyana. Chifukwa chake, mukamachita ntchito yofananira, mudzafunika kuloweza magwiridwe anu omwe amafananira.

Formula ya kuwerengera ndalama ndi VAT mu Microsoft Excel

Kenako, dinani batani la Lowetsani pa kiyibodi kuti mupeze zotsatira zomalizidwa. Chifukwa chake, mtengo wa mtengo umodzi pamodzi ndi msonkho wa mtengo woyamba umawerengeredwa.

Zotsatira za kuwerengera ndalamazo ndi VAT mu Microsoft Excel

Pofuna kuwerengera ndalamazo ndi mtengo wowonjezera msonkho ndi mfundo zina, timagwiritsa ntchito cholembera, monga tachitira kale kuwerengera koyambirira.

Kuchuluka kwa VAT pazinthu zonse kumawerengeredwa mu Microsoft Excel

Chifukwa chake, tidawerengera zofunikira za mfundo zisanu ndi ziwirizo zamisonkho. Zimatenga nthawi yambiri pa cholembera.

Phunziro: Momwe mungasinthire mtundu wa maselo mu Excel

Njira 2: Kuwerengera Misonkho Kuchokera Ndi Vat

Koma pali zochitika zomwe kuchuluka kwa vat kuchokera ku kuchuluka kwake kuyenera kuwerengedwa kwa msonkho kuchokera pazomwe mungalembetse kale. Kenako njira yowerengera imawoneka motere:

"VAT" = "Ndalama ndi VAT" / 118% x 18%

Tiyeni tiwone momwe kuwerengera uku kungapangidwire kudzera pazida za Excel. Mu pulogalamuyi, njira yowerengera idzakhala ndi mawonekedwe awa:

= nambala / 118% * 18%

Monga mkangano, nambala yakuti "nambala yakuti" ndiye mtengo wodziwika bwino wa mtengo wa zinthu pamodzi ndi msonkho.

Mwachitsanzo kuwerengera, tengani tebulo lonselo. Pokhapokha tsopano pokhapokha zitadzazidwa ndi mzere "kuchuluka ndi VAT", ndi zikhulupiriro za mizamu "ndi" msonkho "ndi" msonkho "tikuyenera kuwerengera. Tikuganiza kuti maselo a maselo amakonzedwa kale mu ndalama kapena manambala a manambala awiri, chifukwa chake sitidzachita izi.

Timakhazikitsa cholozera mu khungu loyamba la mzati ndi deta yofunikira. Timalowetsa formula pomwepo (= nambala / 118% * 18%) momwemonso zomwe zidagwiritsidwa ntchito njira yapitayo. Ndiye kuti, pambuyo pa chizindikirocho, timayika cholumikizira cha selo lomwe likugwirizana ndi mtengo womwe uli ndi msonkho womwe umakhala ndi mawu akuti "/ 118% * 18%" popanda mawu. Kwa ife, zidapezeka kuti zotsatirazi:
= C3 / 118% * 18%
Polowetsedwa, kutengera mlandu ndi malo omwe mungalembetse pepala la Extloel, cholumikizira chokhacho chikhoza kusinthidwa.

Formula formula fomula ya VAT mu Microsoft Excel

Pambuyo pake, dinani batani la Lowetsani. Zotsatira zimawerengedwa. Kupitilira apo, monga momwe zapitazo, pogwiritsa ntchito cholembera, kopetsani njira ina ya mzati wa mzati. Monga mukuwonera, zonse zofunikira zimawerengeredwa.

Vat pazinthu zonse za Colun zimapangidwa kuti zikhale zopambana za Microsoft

Tsopano tikuyenera kuwerengetsa ndalamazo popanda malipiro a msonkho, ndiye kuti, malo amisonkho. Mosiyana ndi njira yapita, chizindikirochi sichiwerengedwa ndi kuwonjezera, koma pogwiritsa ntchito kusokoneza. Chifukwa cha ichi muyenera kuchokera pamtengo wa mtengo wa msonkho womwe.
Chifukwa chake, timakhazikitsa cholozera m'chipinda choyambirira cha msonkho wa msonkho. Pambuyo pa "=" chizindikiro, timatulutsa kuchotsera deta kuchokera ku selo loyamba la Vat kuchuluka kwa mtengo wa mtengo woyamba wa Vat. Mwachidule, ichi ndi mawu apa:
= C3-b3
Kuwonetsa zotsatira, musaiwale kukanikiza fungulo la Enter.

Kuwerengera malo a msonkho ku Microsoft Excel

Pambuyo pake, mwachizolowezi pogwiritsa ntchito cholembera chodzaza, koperani ulalo wa zinthu zina za mzati.

Kuchuluka popanda VAT pazomwe zimawerengedwa mu Microsoft Excel

Ntchitoyi imatha kulingaliridwa.

Njira 3: Kuwerengera Misonkho kuchokera pamunsi

Nthawi zambiri kuwerengera ndalamazo pamodzi ndi mtengo wamsonkho, kukhala ndi mtengo wa msonkho. Izi sizikufunika kuwerengera ndalama zomwe mungalandire msonkho. Njira yowerengera imayimiriridwa mu mawonekedwe awa:

"Kuchulukana ndi VAT" = "Tsoka" Maso "+" Tsoka "X 18%

Mutha kusintha mtundu:

"Kuchuluka ndi VAT" = "Tsoka" X 118%

Kupambana, kumawoneka ngati chonchi:

= nambala * 118%

Mtsutso "wonenepa" ndi maziko a msonkho.

Mwachitsanzo, tengani tebulo lonselo, lokha lokha lokha lokha lokha, popeza silifunikira kuwerengera uku. Miyezo yotchuka ipezeka mu batiri lamsonkho, ndipo mukufuna - mu mzere "kuchuluka ndi VAT".

Sankhani foni yoyamba ya mzatiyo ndi zomwe mukufuna. Tidayikapo chikwangwani "=" ndi kutchula khungu loyamba la batire. Pambuyo pake, timayambitsa mawu opanda mawu "* 118%". Pankhani yathu, mawu adapezeka:
= A3 * 118%
Kuwonetsa zotsatira pa pepalalo, dinani batani la Lower.

Formula yowerengera ndalamayo ndi VAT ya kuchuluka kopanda VAT mu Microsoft Excel

Pambuyo pake, timagwiritsa ntchito cholembera chodzaza ndikupanga njira yomwe idakhazikitsidwa kale pamtundu wonsewo ndi mzati wonsewo ndi zisonyezo zowerengedwa.

Zotsatira za kuwerengera ndalamazo ndi vat kuchokera ku mtengo wopanda VAT mu Microsoft Excel

Chifukwa chake, kuchuluka kwa mtengo wa katundu, kuphatikizapo msonkho, adawerengedwa pazikhalidwe zonse.

Njira 4: kuwerengera kwa msonkho kuchokera ku msonkho

Ndiwosavuta kuwerengetsa misonkho kuchokera pamtengo wophatikizidwa ndi msonkho womwe waphatikizidwa. Komabe, kuwerengetsa kumeneku si kwachilendo, kotero tidzaziganizira.

Njira yowerengera misonkho kuchokera pamtengo, pomwe msonkho waphatikizidwa kale, zikuwoneka kuti:

"Tsoka" = "kuchuluka ndi VAT" / 118%

Kupambana, njirayi imatenga mtundu uwu:

= nambala / 118%

Monga "Nambala" yogawa, mtengo wa mtengo wake umaganizira msonkho.

Kuti tiwerenge, timagwiritsanso ntchito tebulo lomwelo monga m'mbuyomu, nthawi ino, nthawi ino, deta yodziwika bwino idzapezeka mu mzere "kuchuluka ndi batri", ndi batri ya msonkho.

Timatulutsa ma extas a chinthu choyamba cha mzere wa msonkho. Pambuyo pa chikwangwani "=" Lowetsani mgwirizano wa foni yoyamba ya mzati wina. Pambuyo pake, timayambitsa mawu akuti "/ 118%". Kuti mukwaniritse kuwerengera ndi kutulutsa kwa zotsatira za polojekiti, mutha kudina batani la Enter. Pambuyo pake, mtengo woyamba wa mtengo wopanda msonkho udzawerengedwa.

Formula yowerengera misonkho ya VAT mu Microsoft Excel

Kuti mupange kuwerengera muzochitika zotsalazo, monga momwe zidayambira kale, gwiritsani ntchito chikhomo chodzaza.

Zotsatira za kubereka msonkho kwa ndalama zomwe zili ndi VAT mu Microsoft Excel

Tsopano tili ndi tebulo pomwe mtengo wa katundu wopanda msonkho umawerengeredwa nthawi yomweyo maudindo asanu ndi awiri.

Phunziro: Gwirani ntchito ndi njira zambiri

Monga mukuwonera, kudziwa zoyambira zowerengera mtengo wowonjezeredwa msonkho ndi zizindikiro zokhudzana ndi msonkho, kuthana ndi ntchito yowerengera kwawo ndi kosavuta. Kwenikweni, kuwerengera algorithomm yokha, kwenikweni, sikosiyana kwambiri pakuwerengera kwa chowerengera mwachizolowezi. Koma, opaleshoniyo m'ma processor omwe atchulidwawa ali ndi mwayi wosasinthika pa cholembera. Imagona poti kuwerengera kwa zinthu zambiri sizitenga nthawi yayitali kuposa kuwerengera kwa chizindikiro chimodzi. Kupambana, kwa mphindi imodzi, wogwiritsa ntchitoyo amatha kupanga misonkho pazinthu zambiri posintha chida chonchi ngati cholembera chotere, pomwe kuwerengera voliyumu yosavuta itha kutenga nthawi wotchi. Kuphatikiza apo, ku Excel, mutha kukonza kuwerengera powasunga ndi fayilo ina.