Lembani chiwerengero ndi chiwerengero mu Microsoft Excel

Mukamachita zowerengera zosiyanasiyana, nthawi zina zimafunika kuchulukitsa nambala ndi peresenti. Mwachitsanzo, chiwerengerochi chimagwiritsidwa ntchito poyesa kuchuluka kwa ndalama zopezera malonda muzondomeko, ndi chiwerengero chodziwika cha kuonjezera. Mwamwayi, izi sizili zovuta kwa aliyense wogwiritsa ntchito. Tiyeni tiwone momwe tingawonjezere chiwerengero mwa kuchuluka kwa Microsoft Excel.

Yambani chiwerengero ndi chiwerengero

Ndipotu, chiwerengero ndi zana la chiwerengerocho. Ndikokuti, pamene akunena, mwachitsanzo, asanu owonjezeka ndi 13% ali ofanana ndi kuchulukitsa 5 ndi nambala 0.13. Mu Excel, mawu awa akhoza kulembedwa monga "= 5 * 13%". Kuti muwerenge mawuwa muyenera kulemba mu ndondomeko, kapena mu selo iliyonse pa pepala.

Kuti muwone zotsatira mu selo losankhidwa, ingoyanikizani ENTER batani pamakina a makompyuta.

Mulimonse momwemo, mungathe kukonza kuchulukitsa ndi chiwerengero chapadera cha deta. Kuti tichite izi, timakhala mu selo komwe zotsatira za chiwerengero zidzawonetsedwa. Zingakhale zabwino kuti selo ili likhale mumzere womwewo monga chiwerengero kuti chiwerengere. Koma ichi si chofunikira. Tikuika chizindikiro chofanana ("= =") mu selo ili, ndipo dinani selo yomwe ili ndi chiyambi choyambirira. Kenako, timayika chizindikiro chochulukitsa ("*"), ndipo tilembani pa kibokosilo mtengo wa peresenti yomwe tikufuna kuchulukitsa nambala. Kumapeto kwa kujambula, musaiwale kuika chizindikiro cha peresenti ("%").

Kuti muwonetse zotsatira pa pepala, dinani pa ENTER batani.

Ngati pakufunika, zotsatirazi zingagwiritsidwe ntchito ku maselo ena, pokhapokha potsanzira njirayi. Mwachitsanzo, ngati deta ili pa tebulo, ndikokwanira kuti muime pambali yakumanja ya selo momwe mpangidwewu umayendetsedwa, ndipo ndi batani lamanzere lomwe likugwiritsidwa ntchito, limbani mpaka kumapeto kwa tebulo. Choncho, chiwerengerochi chidzakopedwa ku maselo onse, ndipo simudzasowa kuyendetsa pamanja kuti muwerenge kuchulukitsa kwa manambala mwa peresenti yeniyeni.

Monga momwe mukuonera, pakuwonjezeka kwa chiwerengero ndi chiwerengero cha Microsoft Excel, payenera kukhala mavuto ena osati odziwa ntchito okha, koma ngakhale oyamba kumene. Bukuli lidzakuthandizani kuti muzindikire njirayi.