Kuchotsa peresenti kuchokera pa manambala pakuwerengetsera masamu sikovuta kwambiri. Mwachitsanzo, m'mabizinesi azamalonda, kuchuluka kwa VAT kumachotsedwa pamalipiro kuti akhazikitse mtengo wa zinthuzo popanda VAT. Maulamuliro osiyanasiyana amachita chimodzimodzi. Tivomereze kuti tiwone momwe tingachotsereko kuchuluka kwa Microsoft Excel.
Kuchotsa peresenti ku Excel
Choyamba, tiyeni tiwone momwe maperesenti amachotsedwera kuchokera manambala onse. Kuti muchotse kuchuluka kuchokera manambala, muyenera kuzindikira nthawi yomweyo, kuchuluka kwake, kukhala gawo lina la manambala omwe apatsidwa. Kuti muchite izi, kuchulukitsa nambala yoyambayo ndi peresenti. Kenako, zotsatirazi zimachotsedwa pa nambala yoyambayo.
Mu mitundu ya Excel, ziziwoneka motere: "= (nambala) - (nambala) * (%_value)%."
Sonyezani kuchotsera kwa peresenti pazitsanzo zinazake. Tingoyerekeza kuti tikuyenera kuchotsa 12% kuchokera pa 48. Timadina tsamba lililonse patsamba
Kuti muwerengere ndikuwona zotsatira, dinani batani la ENTER pa kiyibodi.
Kuchotsa peresenti pagome
Tsopano tiyeni tiwone momwe mungachotsere peresenti kuchokera kuzosankha zomwe zalembedwa kale pagome.
M'malo mwake tikufuna kuchotsa peresenti inayake kuchokera ku maselo onse a gulu lina, choyamba, titha kufika pagawo lopanda kanthu la tebulo. Timayika chikwangwani "=" mmenemo. Kenako, dinani khungu, kuchuluka komwe mukufuna kuchotsa. Pambuyo pake, ikani chikwangwani cha "-", ndikubweretsanso patsamba limodzi lomwe lidasindikizidwa kale. Timayika chikwangwani cha "*", ndipo kuchokera pa kiyibodi timayimira mtengo wofunikira womwe umayenera kuchotsedwa. Pamapeto, ikani chikwangwani "%".
Timadina batani la ENTER, pambuyo pake mawerengeredwe amachitika, ndipo zotsatira zake zimawonekera mu cell momwe tidalemba formula.
Kuti fomuloli ikhale yofanana ndi maselo ena onse otsala, ndipo mwakutero, peresentiyo idachotsedwa pamizere ina, timakhala pakona yakumbuyo kachipinda komwe kuli njira yokhazikitsidwa kale. Timakanikiza batani lakumanzere pa mbewa, ndikuyikoka mpaka kumapeto kwa tebulo. Chifukwa chake, tiwona mu manambala aliwonse omwe amaimira kuchuluka koyambira kuchotsera omwe akhazikitsidwa.
Chifukwa chake, tidasanthula milandu iwiri yayikulu yochotsa peresenti kuchokera ku Microsoft Excel: monga kuwerengera kosavuta, komanso ngati ntchito pagome. Monga mukuwonera, njira yochotsera chidwi siikhala yovuta kwambiri, ndipo kugwiritsidwa ntchito kwake pama tebulo kumathandizira kuti ntchitoyo ikhale yosavuta.
