Momwe mungawonjezere chidwi ndi chiwerengerochi

Anonim

Onjezani chidwi cha chille mu Microsoft Excel

Pa kuwerengera, nthawi zina zimakhala zofunikira kuwonjezera chidwi cha nambala inayake. Mwachitsanzo, kuti mudziwe zisonyezo zomwe zilipo panodi, zomwe zimachuluka peresenti ina yoyerekeza ndi mwezi watha, ndikofunikira kuwonjezera kuchuluka kwa phindu la phindu la phindu la phindu la phindu la phindu la zopindulitsa mwezi watha. Pali zitsanzo zambiri zina pomwe mungafunire kuchitapo kanthu. Tiyeni tiwone momwe mungawonjezere kuchuluka kwa nambala ya Microsoft Excel.

Kugwiritsa Ntchito Zochita mu Cell

Chifukwa chake, ngati mukungodziwa zomwe chiwerengerocho chidzakhala cholingana, pambuyo pa gawo lina la peresenti, kapena mu chingwe, kapena mu chingwe, kuyendetsa bwino molingana ndi template yotsatirayi: "= (nambala) + (nambala) * (mtengo_procerant)%."

Tiyerekeze kuti tikufunika kuwerengetsa nambala yomwe ikupezeka ngati mukuwonjezera 140 makumi awiri peresenti. Timalemba njira yotsatirayi mu khungu lililonse, kapena mu chingwe: "= 140 + 140 * 20%".

Formula yowerengera peresenti mu pulogalamu ya Microsoft Excel

Kenako, dinani batani la Lowetsani pa kiyibodi, ndipo tikuwona zotsatira zake.

Maperesenti owerengeka amabwera ku Microsoft Excel

Kugwiritsa ntchito formula yochita patebulo

Tsopano tiyeni tiwone momwe mungaonjezerare peresenti inayake yomwe ilipo kale patebulo.

Choyamba, sankhani foni pomwe zotsatira zake zingawonetsedwe. Tidayiyika chikwangwani "=". Chotsatira, dinani pa cell yomwe ili ndi deta yomwe kuchuluka kwake kuyenera kuwonjezeredwa. Ikani chizindikiro "+". Apanso, podina pa cell yomwe ili ndi chiwerengero, ikani chizindikiro "*". Kenako, timayala mtengo wampukutira pa kiyibodi yomwe nambala iyenera kuwonjezeka. Musaiwale mutalowetsa mtengo uwu kuti muyike chizindikiro "%".

Formula yowerengera peresenti ya tebulo mu pulogalamu ya Microsoft Excel

Dinani pa batani la Lowetsani pa kiyibodi, pambuyo pake zomwe zimachitika pakuwonetsedwa.

Maperesenti aperewera pa pulogalamu ya Microsoft Excorl ya tebulo

Ngati mukufuna kugawa njirayi pa tebulo lonse patebulopo, ndiye ingokhalani pansi pa cell pomwe zotsatira zake zachokera. Clonjerani iyenera kutembenukira pamtanda. Tadidina batani la mbewa lamanzere, ndipo ndi "chotambalala" kumapeto kwa tebulo.

Kutambasulira fomba ku Microsoft Excel

Monga mukuwonera, zotsatira za kuchulukitsa manambala ku gawo linalake limachokera maselo ena pamphepete.

Zotsatira zotambasulira fomba pansi mu pulogalamu ya Microsoft Excel

Tinadziwa kuti kuwonjezera kuchuluka kwa nambala yomwe ili mu Microsoft Excel silovuta kwambiri. Komabe, ogwiritsa ntchito ambiri sadziwa kuchita, ndikulakwitsa. Mwachitsanzo, cholakwika chofala kwambiri ndikulemba kwa algorithm "= (nambala) + (mtengo) + (nambala) + (mtengo)." Bukuli liyenera kuthandizira kupewa zolakwazi.

Werengani zambiri