Microsoft Excel: Onjezani Peresenti Nambala

Pin
Send
Share
Send

Panthawi yowerengera, nthawi zina pamayenera kuwonjezera kuchuluka kwa chiwerengerocho. Mwachitsanzo, kuti mudziwe zomwe zikuwonetsa phindu pakadali pano, zomwe zidachulukitsa ndi ena poyerekeza ndi mwezi watha, muyenera kuwonjezera izi peresenti ya phindu la mwezi watha. Pali zitsanzo zina zambiri mukafuna kuchita zofananazo. Tiyeni tiwone momwe mungawonjezere chiwerengero ku Microsoft Excel.

Zochita pakompyuta mu cell

Chifukwa chake, ngati mungofunikira kudziwa momwe manambala adzakhalire, mutawonjezera kuchuluka kwina, ndiye kuti muyenera kuyendetsa gawo lililonse la pepalalo, kapena mzere wa formula, mawuwo potengera mawonekedwe awa: "= (nambala) + (nambala) * (peresenti_value )% ".

Tiyerekeze kuti tikuyenera kuwerengetsa kuchuluka komwe timapeza ngati tiwonjezera pa makumi awiri pa zana. Timalemba njira zotsatirazi mu cell iliyonse, kapena mzere wa fomula: "= 140 + 140 * 20%".

Kenako, dinani batani la ENTER pa kiyibodi, kuti muwone zotsatira.

Kugwiritsa ntchito kachitidwe kachitidwe patebulo

Tsopano, tiwone momwe tingaonjezere gawo lina ku deta yomwe ili kale pagome.

Choyamba, sankhani khungu lomwe zotsatira zikuwonetsedwa. Timayika chikwangwani "=" mmenemo. Kenako, dinani pa foni yomwe ili ndi zomwe peresenti imayenera kuwonjezeredwa. Ikani chikwangwani "+". Ndiponso, dinani foni yomwe ili ndi nambalayo, ikani chikwangwani cha "*". Chotsatira, timalemba pa kiyibodi mtengo womwe kuchuluka kwake ayenera kuchuluka. Musaiwale kuyika chikwangwani "%" mutalowa mtengo uwu.

Timadina batani la ENTER pa kiyibodi, pambuyo pake zowerengera ziziwonetsedwa.

Ngati mukufuna kuwonjezera fomula iyi kuzikhulupiliro zonse za tebulo, ndiye ingoyimani pamphepete kumanja kwa selo komwe zotsatira zake zikuwonetsedwa. Temberero litembenuke kukhala mtanda. Dinani batani lakumanzere, ndipo batani litasungidwa, "timatambasulira" formula kumapeto kwenikweni kwa tebulo.

Monga mukuwonera, zomwe zimachulukitsa ndi kuchuluka kwina zimawonekeranso maselo ena omwe ali mgulowo.

Tinaona kuti kuwonjezera kuchuluka kwa Microsoft ku Excel sikuvuta. Komabe, ogwiritsa ntchito ambiri sadziwa momwe angachitire izi ndikulakwitsa. Mwachitsanzo, cholakwika chofala kwambiri ndikulemba formula malinga ndi algorithm "= (nambala) + (%_value)%", m'malo mwa "= (nambala) + (nambala) * (peresenti_value)%". Kuwongolera uku kuyenera kuthandiza kupewa zolakwikazo.

Pin
Send
Share
Send