Formula muExcel yekubvisa VAT

Kazhinji, vashandisi vanoshanda muExcel spreadsheet edhita vanofanirwa kuita maitiro akadai sekubvisa VAT. Ehe, chiito ichi chinogona kuitwa uchishandisa yakajairwa karukureta, asi kana iwe uchida kuita kuverenga kwakadaro kakawanda, zvino zvinokurudzirwa kushandisa mabasa akavakirwa mupepeti. Muchinyorwa ichi, tichaongorora zvakadzama nzira dzese dzinokutendera kuti uite kubviswa kweVAT mugwaro respredishiti.

Formula yekuverenga VAT kubva pachigadziko chemutero

Pakutanga, isu tichaona nzira yekuverenga VAT kubva kune mutero base. Zviri nyore kushandisa nzira iyi. Izvo zvinodiwa kuti mutero uwedzere huwandu hwegumi nemasere muzana. Isu tinowana iyo inotevera formula: "VAT" = "Basi remutero" * 18%. Mumupepeti wespredishiti, fomula inotaridzika seizvi: =nhamba*0,18.

Iyo inoshanduka "Nhamba" ndiyo nhamba yenhamba yemutero. Panzvimbo yenhamba, unogona kutsanangura kurongeka kwesero umo chiratidzo pachayo chiripo.

Ngatitarisei muenzaniso chaiwo. Tine makoramu matatu. Iyo 1st column ine zviratidzo zvemutero base. Muchikamu chechipiri pane zviratidzo zvinodiwa zvinoda kuverengwa. Iyo 2rd column ine huwandu hwekugadzirwa pamwe neVAT. Iko kuverenga kuchaitwa nekuwedzera kukosha kweiyo 3st uye 1nd makoramu.

Detailed mirairo inoita seizvi:

1. Isu tinosarudza 1st sero nemashoko anodiwa. Isa chiratidzo "=", uye wobva wadzvanya bhatani rekuruboshwe pamunda uri mumutsara mumwechete wekoramu yekutanga. Izvo zvinorongeka zvinopinzwa mufomula. Wedzera chiratidzo "*" kune yakaverengerwa ndima. Tichishandisa keyboard, tinonyora "18%" kana "0,18". Nekuda kweizvozvo, tinowana iyo inotevera formula: =A3*18%.

2. Dzvanya kiyi ye "Enter" pa keyboard kuratidza mhedzisiro musero rakasarudzwa. Mupepeti wespredishiti achaita masvomhu ese anodiwa.

3. Ziva kuti iyo yakazara inoratidzwa ne4 decimals. Iko kukosha kwemari kunofanirwa kuve nemabhii maviri edesimali chete. Kuti zvawanikwa zvitaridzike zvakanaka, zvinofanirwa kutenderedzwa kusvika kunzvimbo mbiri dzedesimali. Iyi nzira inoshandiswa nekushanda kwekugadzirisa. Kuti zvive nyore, isu tichafometa ese maseru umo chiratidzo chakafanana chicharatidzwa. Isu tinosarudza huwandu hwemasero akadaro nekubata pasi bhatani rekuruboshwe. Tinya-kurudyi kwese kwese kwakasarudzwa. Pane diki yakakosha menyu yakaonekwa pachiratidziro. Isu tinowana chinhu chine zita rekuti "Cell Format ...", uye tinya pairi nebhatani rekuruboshwe.

4. Hwindo rakaratidzwa pachiratidziro chespredishiti, richikubvumidza kuti uite maitiro ekufomatidza. Tinoenda kune chikamu che "Nhamba". Isu tinowana rondedzero yemirairo "Numeric mafomati:" uye sarudza chinhu "Numeric" pano. Isu tinoisa kukosha "2" kumutsara une zita "Nhamba yenzvimbo dzedesimali". Kuti ushandise shanduko dzese, tinya bhatani rekuti "Zvakanaka" riri pazasi petafura yemupepeti interface.

5. Imwe sarudzo ndeye kushandisa iyo mari fomati. Iyo zvakare inobvumidza iwe kuratidza iyo yakazara ne 2 decimals. Tinoenda kune chikamu che "Nhamba". Isu tinowana rondedzero yemirairo "Nhamba mafomati:" uye sarudza chinhu "Mari" pano. Isu tinoisa kukosha "2" kumutsara une zita "Nhamba yenzvimbo dzedesimali". Mu "Designation" parameter, tinoisa ruble. Pano unogona kuseta zvachose chero mari. Kuti ushandise shanduko dzese, tinya pakanzi "OK".

6. Mhedzisiro yeshanduko nefomati yenhamba:

7. Mhedzisiro yeshanduko ine currency format:

8. Isu tinotevedzera fomuro kune akasara masero. Fambisa chinongedzo kukona yekurudyi kwesero neformula. Iyo pointer yakatora chimiro chechidiki plus chiratidzo chemumvuri wakasviba. Nekubatsirwa kwebhatani reruboshwe rakatsikirirwa, tinotambanudza fomu kusvika kumagumo etafura.

9. Ready! Isu takatambanudza fomula kune ese maseru eiyo column.

10. Inoramba ichiita maitiro ekuverenga huwandu hwemutengo pamwe chete neVAT. Isu tinodzvanya LMB pane yekutanga sero yekoramu "Mari ine VAT". Pinda iyo "=" chiratidzo, tinya pa 1st ndima ye "Taxation base" column. Isu tinotyaira muchiratidzo che "+", tobva tadzvanya LMB pandima yekutanga yekoramu yechipiri. Nekuda kweizvozvo, tinowana iyo inotevera formula: = A3+V3.

11. Dzvanya kiyi ye "Enter" kuratidza mhedzisiro musero rakasarudzwa. Mupepeti wespredishiti achaita masvomhu ese anodiwa.

12. Saizvozvo, isu tinokopa fomuro kune akasara maseru. Fambisa chinongedzo kukona yekurudyi kwesero neformula. Iyo pointer yakatora chimiro chechidiki plus chiratidzo chemumvuri wakasviba. Nekubatsirwa kwebhatani reruboshwe rakatsikirirwa, tinotambanudza fomu kusvika kumagumo etafura.

Mamwe mafomula ane chekuita nekubviswa kweVAT

Kune akati wandei mamwe mafomula anotendera iwe kuti uite fomula yekubvisa VAT. Pakarepo, tinocherechedza kuti kutevedzana kwezviito kwakafanana nemuenzaniso uri pamusoro apa. Nemamwe maitiro, ndiro chete yepakutanga pachayo inoshanduka, uye zviito zvose zvine chokuita nekushandura chimiro uye kutambanudza fomu kune mamwe masero anoramba akafanana.

Iyo formula yekuverenga huwandu hweVAT pamari iyo mutero watosanganisirwa inotaridzika seizvi: "VAT" = "Mari ine VAT" / 118% x 18%. Mumupepeti wespredishiti, fomula inotaridzika seizvi: =nhamba/118%*18%.

Iyo formula yekuverenga mutero wemutero kubva kune mutero base inoita seizvi: "Mari ine VAT" = "Base remutero" x 118%. Mumupepeti wespredishiti, fomula inotaridzika seizvi: =nhamba*118%.

Iyo formula yekuverenga base yemitero kubva pamari nemutero inoita seizvi: "Base remutero" = "Mari ine VAT" / 118%. Mumupepeti wespredishiti, fomula inotaridzika seizvi: =nhamba/118%.

Mhedziso uye mhedziso pamaitiro ekubvisa VAT mumupepeti wespredishiti

Iyo spreadsheet mupepeti inobvumidza iwe kukurumidza kupedzisa iyo VAT yekubvisa maitiro. Iyo purogiramu inokutendera kuti ushandise zvachose chero fomula iripo kuverenga ichi chiratidzo. Chinhu chikuru ndechekukwanisa kushandura sero fomati uye kushanda nemazvo nemutsara wekupinda mafomula.