Kuchulukitsa Kuchulukitsa kwa Chiwerengero mu Microsoft Excel

Pin
Send
Share
Send

Mukamawerengera kosiyanasiyana, nthawi zina muyenera kuchulukitsa manambala ndi peresenti. Mwachitsanzo, kuwerengera kumeneku kumagwiritsidwa ntchito pozindikira kuchuluka kwa gawo lamalonda pazandalama, ndi gawo lodziwika lazopeza. Tsoka ilo, iyi si ntchito yosavuta kwa wogwiritsa ntchito aliyense. Tiyeni tifotokozere momwe kuchulukitsa nambala ndi peresenti mu Microsoft Excel.

Kuchulukitsa Chiwerengero ndi Peresenti

M'malo mwake, peresenti ndi zana la chiwerengero. Ndiye kuti, akati, mwachitsanzo, kasanu ka 13% - chimodzimodzi 5 peresenti 0.13. Ku Excel, mawu awa akhoza kulembedwa "= 5 * 13%." Pakuwerengera, mawu awa akuyenera kulembedwa mzere wama formula, kapena mu cell iliyonse papepala.

Kuti muwone zotsatira mu cell yosankhidwa, ingololani batani la ENTER pa kiyibodi ya pakompyuta.

Pafupifupi momwemonso, mutha kukonzekera kuchulukitsa ndi kuchuluka kwa manambala a data. Kuti tichite izi, timakhala mu cell momwe zowerengera zikuwonetsedwa. Zingakhale bwino kuti khungu ili lizikhala pamzere womwewo kuti chiwerengero chiziwerengedwa. Koma izi sizofunikira. Tikuyika chikwangwani chofanana ("=") mufoni iyi, ndikudina foni yomwe ili ndi nambala yoyambira. Kenako, timayika chikwangwani chokuchulukitsa ("*"), ndipo timalemba pa kiyibodi mtengo womwe timafuna kuchulukitsa manambala. Pamapeto pa mbiri musayiwale kuyika chikwangwani ("%").

Kuti muwonetse zotsatira patsamba, dinani batani la ENTER.

Ngati ndi kotheka, izi zitha kugwiritsidwa ntchito ku maselo ena pakukopera njira. Mwachitsanzo, ngati deta ili patebulo, ndiye chokwanira kungoyima pakona ya kumunsi kwa cell komwe kakhazikitsidwe kanyimbo komwe, ndikugwira batani la mbewa kumanzere, ndikokera pansi mpaka kumapeto kwa tebulo. Chifukwa chake, fomuloli idzatengedwa ku maselo onse, ndipo simuyenera kuyendetsa pamanja kuti muwerenge kuchuluka kochulukitsa ndi kuchuluka kwake.

Monga mukuwonera, ndikochulukitsa kuchuluka ndi peresenti mu Microsoft Excel, sikuyenera kukhala ndi mavuto apadera osati a ogwiritsa ntchito okhawo, komanso oyamba kumene. Bukuli likuthandizani kudziwa njirayi popanda mavuto.

Pin
Send
Share
Send