Momwe mungawonjezere maperesenti ku nambala mu Excel. Fomula, pamanja, kuwonjezera pamndandanda wonse

Microsoft Excel nthawi zambiri imagwiritsidwa ntchito popanga maperesenti. Iwo ndi ofunikira makamaka pakuwerengera malonda. Mwachitsanzo, muyenera kudziwa zomwe kusintha kwa malonda akukonzedwa. Zida za Excel zimakupatsani mwayi wowonjezera manambala ndi maperesenti ndikupanga mafomu kuti muwerengere kukwera ndi kutsika kwa malonda. Tiyeni tiwone momwe tingawonjezere kuchuluka kwa mtengowo pamtengo womwewo.

Momwe mungawonjezere kuchuluka ndi manambala pamanja

Tangoganizirani kuti pali chiwerengero cha chiwerengero cha chizindikiro, chomwe chimawonjezeka pakapita nthawi ndi maperesenti angapo, kapena makumi angapo peresenti. Kuwonjezeka kumeneku kungawerengedwe pogwiritsa ntchito masamu osavuta. M'pofunika kutenga nambala ndi kuwonjezera kwa izo mankhwala a chiwerengero chomwecho ndi peresenti inayake. Fomula ikuwoneka motere: Chiwerengero cha nambala ndi peresenti=nambala+(nambala*peresenti%). Kuti tiwone zomwe zikuchitika pachitsanzo, tilemba mkhalidwe wavuto. Voliyumu yoyamba yopanga ndi mayunitsi 500, akukula ndi 13% mwezi uliwonse.

1. Muyenera kusankha selo mu tebulo lopangidwa kapena selo lina lililonse laulere. Timalembamo mawu omwe ali ndi deta yochokera ku chikhalidwecho. Musaiwale kuyika chizindikiro chofanana pachiyambi, apo ayi zochita sizingachitike.

2. Dinani batani la "Enter" - mtengo wofunikira udzawonekera mu selo.

Njira yowerengerayi imaphatikizapo kudzaza ma cell a tebulo pamanja. Kukopera sikungathandize, chifukwa mawuwa ali ndi manambala enieni, sakutanthauza selo.

Tanthauzo la kuchuluka kwa manambala

Nthawi zina pamafunika kuti lipotilo liwonetse kuchuluka kwa mtengo wa chizindikiro china osati kuchuluka, koma mumtundu wanthawi zonse. Pankhaniyi, kuchuluka kwa mtengo woyamba kumawerengedwa. Gwiritsani ntchito njira iyi kuti muwerenge kuchuluka kwa nambala: Peresenti=(Nambala*Nambala ya maperesenti mumtundu wa manambala)/100. Tiyeni titengenso manambala omwewo - 500 ndi 13%.

1. Muyenera kulemba mtengo mu selo linalake, choncho sankhani. Timalemba chilinganizo ndi manambala owonetsedwa, patsogolo pake pali chizindikiro chofanana.

2. Dinani "Enter" pa kiyibodi ndikupeza zotsatira.

Zimachitika kuti chizindikirocho chimakula nthawi zonse ndi mayunitsi angapo, koma sichidziwika kuti ndi ndalama zingati. Pakuwerengera kotere, palinso njira: Kusiyana kwamaperesenti=(Kusiyana/Nambala)*100.

Poyambirira zidapezeka kuti kuchuluka kwa malonda kukukulira ndi mayunitsi 65 pamwezi. Tiyeni tiwerengere kuchuluka kwake ngati peresenti.

1. Muyenera kuyika manambala odziwika mu fomula ndikulemba mu cell yokhala ndi chizindikiro chofanana pachiyambi.

2. Mukakanikiza batani la "Enter", zotsatira zake zidzakhala mu cell.

Sikoyenera kuchulukitsa ndi 100 ngati selo likutembenuzidwa kukhala mawonekedwe oyenera - "Percentage". Ganizirani kusintha mawonekedwe a cell pang'onopang'ono:

1. Muyenera dinani pa cell yomwe mwasankha ndi RMB - menyu yankhani idzatsegulidwa. Sankhani "Format Maselo" njira.

2. A zenera adzatsegula kumene mukhoza kusankha yoyenera mtundu. Timapeza "Percentage" pamndandanda womwe uli kumanzere. Ngati mukufuna nambala, muyenera kuyika mtengo wa ziro mugawo la "Nambala ya malo a decimal" pogwiritsa ntchito mabatani a mivi kapena pamanja. Kenako, dinani "Chabwino".

3. Tsopano mawuwa akhoza kuchepetsedwa kukhala chinthu chimodzi.

4. Chotsatira chidzawoneka mumtundu wamtundu.

Kuwonjezera nambala ndi peresenti pogwiritsa ntchito fomula

Kuti muwonjezere kuchuluka kwa nambala ku nambala yomwe, mutha kugwiritsa ntchito fomula. Njirayi ndiyothandiza pazochitika zomwe zotsatira za mawerengedwe ziyenera kudzaza tebulo mwamsanga.

1. Sankhani selo laulere ndikudzaza ndi fomula. Deta iyenera kutengedwa patebulo. Fomula ndi: Nambala+Nambala* Peresenti.
2. Choyamba, timalemba chizindikiro chofanana, kenako sankhani selo ndi nambala, ikani kuphatikizira, ndikudinanso pa selo ndi mtengo woyamba. Timalowetsa nyenyezi ngati chizindikiro chochulukitsa, pambuyo pake - mtengo wamtengo wapatali.

3. Dinani batani la "Enter" kuti mupeze zotsatira za kuwerengera.
4. Lembani maselo otsala a mzati. Kuti muchite izi, muyenera kukopera chilinganizocho ndi chotsitsa - izi zikutanthauza kuti kutchulidwa kwa selo mu ndondomekoyi kudzasintha mukasamukira ku selo pansipa.

Pali chikhomo cha square pakona ya selo yosankhidwa. Ndikofunikira kuigwira pansi ndi kutambasula kusankha ku gawo lonse la tebulo.

5. Tulutsani batani la mbewa - maselo onse osankhidwa adzadzazidwa.

6. Ngati manambala akufunika, mawonekedwewo ayenera kusinthidwa. Sankhani ma cell omwe ali ndi fomula, dinani pomwepa ndikutsegula menyu yamawonekedwe. Muyenera kusankha mtundu wa nambala ndikukhazikitsanso kuchuluka kwa malo a decimal.

7. Makhalidwe m'maselo onse adzakhala ophatikizika.

Momwe mungawonjezere kuchuluka kwa gawo

Pali malipoti mumtundu uwu, pamene imodzi mwa mizati imasonyeza kukula kwa chiwerengero cha chizindikiro pakapita nthawi. Chiwerengerocho sichifanana nthawi zonse, koma n'zotheka kuwerengera kusintha kwa zizindikiro pogwiritsa ntchito kuwerengera.

1. Timalemba ndondomeko molingana ndi mfundo yomweyi, koma popanda kulemba manambala pamanja - deta ya tebulo yokha ndiyofunikira. Timawonjezera kuchuluka kwa malonda ake ndi kuchuluka kwa kukula ndikusindikiza "Enter".

2. Lembani ma cell onse ndi kusankha kukopera. Mukasankhidwa ndi chikhomo cha square, chifanizirocho chidzakopedwa kumaselo ena ndi zochotsera.

Kupanga tchati chokhala ndi maperesenti

Malingana ndi zotsatira za mawerengedwe, ndizotheka kujambula chithunzi chofanana ndi tebulo - chithunzi. Pa izo mutha kuwona chomwe chimatchuka kwambiri pankhani yogulitsa.

1. Sankhani ma cell omwe ali ndi maperesenti ndikuwakopera - kuti muchite izi, dinani kumanja ndikupeza chinthu cha "Copy" pamenyu kapena gwiritsani ntchito kiyi "Ctrl + C".
2. Pitani ku tabu "Ikani" ndikusankha mtundu wa tchati, mwachitsanzo, tchati cha pie.

Kutsiliza

Mutha kuwonjezera chiwerengero cha nambala ku nambalayo m'njira zingapo - pamanja kapena kugwiritsa ntchito fomula. Njira yachiwiri ndiyabwino ngati mukufunika kuwonjezera maperesenti kuzinthu zingapo. Ndikothekanso kuwerengera zikhalidwe zingapo ndi magawo osiyanasiyana akukula ndikupanga tchati kuti lipotilo limveke bwino.