Werengani Maperesenti a Nambala ndikugawana mu Excel

Kuwerengera chidwi ndi chimodzi mwazochita zodziwika bwino mu Excel. Izi zitha kukhala kuchulukitsa nambala ndi gawo linalake, kudziwa gawo (mu%) la nambala inayake, ndi zina zambiri. . Chifukwa chake, tsopano, tisanthula mwatsatanetsatane momwe chidwi chimawerengedwera mu Excel.

Timawerengera gawo la chiwerengero chonse

Poyamba, tiyeni tipende zochitika zodziwika bwino pamene tifunikira kudziwa kuchuluka kwa nambala imodzi (monga peresenti) mu ina. Nayi njira yamasamu yochitira ntchitoyi:

Gawani (%) = Nambala 1/Nambala 2*100%, kumene:

• Nambala 1 - Ndipotu, chiwerengero chathu choyambirira
• Nambala 2 ndi nambala yomaliza yomwe tikufuna kudziwa gawo

Mwachitsanzo, tiyeni tiyese kuwerengera kuchuluka kwa nambala 15 mu nambala 37. Timafunikira zotsatira monga peresenti. Mu ichi, mtengo wa "Nambala 1" ndi 15, ndipo "Nambala 2" ndi 37.

1. Sankhani selo lomwe tiyenera kuwerengera. Timalemba chizindikiro "chofanana" ("=") ndiyeno ndondomeko yowerengera ndi manambala athu: =15/37*100%.
2. Titalemba fomula, timakanikiza fungulo la Enter pa kiyibodi, ndipo zotsatira zake ziziwonetsedwa nthawi yomweyo mu cell yosankhidwa.

Kwa ogwiritsa ntchito ena, mu selo lotsatira, mmalo mwa chiwerengero cha chiwerengero, nambala yosavuta ikhoza kuwonetsedwa, ndipo nthawi zina ndi chiwerengero chachikulu cha manambala pambuyo pa decimal.

Chowonadi ndi chakuti mawonekedwe a cell kuti awonetse zotsatira zake samakonzedwa. Tiyeni tikonze izi:

1. Timadina kumanja pa selo ndi zotsatira (zilibe kanthu tisanalembe fomulamo ndikupeza zotsatira kapena pambuyo pake), pamndandanda wamalamulo omwe akuwonekera, dinani chinthucho "Format Cells ...".
2. Pazenera la masanjidwe, tipeza tabu "Nambala". Apa, pamawonekedwe a manambala, dinani pamzere wa "Percentage" ndipo kumanja kwa zenera ndikuwonetsa nambala yomwe mukufuna yamalo a decimal. Njira yodziwika kwambiri ndi "2", yomwe timayika mu chitsanzo chathu. Pambuyo pake, dinani OK batani.
3. Tamaliza, tsopano tipeza ndendende kuchuluka kwa kuchuluka kwa selo, komwe kumafunikira poyambirira.

Mwa njira, pamene mawonekedwe owonetsera mu selo ayikidwa ngati peresenti, sikoyenera kulemba "100%“. Zidzakhala zokwanira kuchita kugawa kosavuta kwa manambala: =15/37.

Tiyeni tiyesetse kugwiritsa ntchito zomwe taphunzirazo. Tiyerekeze kuti tili ndi tebulo logulitsa ndi zinthu zosiyanasiyana, ndipo tiyenera kuwerengera gawo la chinthu chilichonse muzopeza zonse. Kuti zitheke, ndi bwino kuwonetsa deta mugawo lapadera. Komanso, tiyenera kukhala tidawerengeratu ndalama zonse zomwe timapeza pazinthu zonse, zomwe tidzagawanitsa malonda pa chinthu chilichonse.

Kotero, tiyeni titsike ku ntchito yomwe ili pafupi:

1. Sankhani selo loyamba lazagawo (kupatula mutu wa tebulo). Monga mwachizolowezi, kulemba fomula iliyonse kumayamba ndi chizindikiro "=“. Kenako, timalemba chilinganizo chowerengera chiwerengerocho, chofanana ndi chitsanzo chomwe takambirana pamwambapa, ndikungosintha manambala ena ndi ma adilesi a cell omwe amatha kulowetsedwa pamanja, kapena kuwonjezera pa formula ndikudina mbewa. Kwa ife, mu selo E2 muyenera kulemba mawu otsatirawa: =D2/D16. Zindikirani: musaiwale kukonzekereratu mtundu wa cell wagawo lotsatira posankha kuwonetsa ngati maperesenti.
2. Dinani Enter kuti mupeze zotsatira mu cell yomwe mwapatsidwa.
3. Tsopano tiyenera kupanga mawerengedwe ofanana pa mizere yotsala ya ndime. Mwamwayi, kuthekera kwa Excel kumakupatsani mwayi wopewa kulowetsa pamanja fomula ya selo iliyonse, ndipo izi zitha kupangidwa mongotengera (kutambasula) formulayo kumaselo ena. Komabe, pali kagawo kakang'ono apa. Mu pulogalamuyo, mwachisawawa, pokopera mafomu, ma adilesi a cell amasinthidwa molingana ndi kuchotsera. Zikafika pakugulitsa kwa chinthu chilichonse, ziyenera kukhala choncho, koma zolumikizira za selo ndi ndalama zonse ziyenera kukhala zosasinthika. Kuti mukonze (kupanga mtheradi), muyenera kuwonjezera chizindikiro "$“. Kapena, kuti musalembe chikwangwani ichi pamanja, powonetsa adilesi ya foni mu fomula, mutha kungodina batani. F4. Mukamaliza, dinani Enter.
4. Tsopano yatsala kutambasula chilinganizo ku maselo ena. Kuti muchite izi, sunthani cholozera kumunsi kumanja kwa selo ndi zotsatira zake, cholozeracho chiyenera kusintha mawonekedwe kukhala mtanda, pambuyo pake, tambasulani ndondomekoyi pansi pogwiritsira ntchito batani lakumanzere.
5. Ndizomwezo. Monga momwe timafunira, ma cell a gawo lomaliza adadzazidwa ndi gawo lazogulitsa zamtundu uliwonse pazopeza zonse.

Inde, mu mawerengedwe sikofunikira konse kuwerengera ndalama zomaliza pasadakhale ndikuwonetsa zotsatira zake mu selo losiyana. Chilichonse chikhoza kuwerengedwa nthawi yomweyo pogwiritsa ntchito chilinganizo chimodzi, chomwe cha selo E2 zikuwoneka chonchi: =D2/СУММ(D2:D15).

Pamenepa, tinawerengera nthawi yomweyo ndalama zonse mu fomula yowerengera gawo pogwiritsa ntchito ntchitoyi SUM. Werengani za momwe mungagwiritsire ntchito m'nkhani yathu - "".

Monga njira yoyamba, tifunika kukonza chiwerengero cha malonda omaliza, komabe, popeza selo linalake lomwe liri ndi mtengo wofunikira silimawerengera, tiyenera kulemba zizindikiro "$” asanatchulidwe mizere ndi mizati mumaadiresi amtundu wa kuchuluka kwake: =D2/СУММ($D$2:$D$15).

Kupeza chiwerengero cha nambala

Tsopano tiyeni tiyese kuwerengera kuchuluka kwa nambala monga mtengo wokwanira, mwachitsanzo ngati nambala yosiyana.

Masamu a masamu powerengera ali motere:

Nambala 2 = Peresenti (%) * Nambala 1, kumene:

• Nambala 1 ndi nambala yoyambirira, peresenti yomwe mukufuna kuwerengera
• Peresenti - motero, mtengo wa peresenti yokha
• Nambala 2 ndiye nambala yomaliza yopezeka.

Mwachitsanzo, tiyeni tipeze kuti 15% ya 90 ndi nambala iti.

1. Timasankha selo momwe tidzasonyezera zotsatira ndikulemba ndondomeko pamwambapa, ndikulowetsamo mfundo zathu: =15%*90.Zindikirani: Popeza zotsatira zake ziyenera kukhala mwatsatanetsatane (mwachitsanzo ngati nambala), mtundu wa selo ndi "general" kapena "manambala" (osati "peresenti").
2. Dinani batani la Enter kuti mupeze zotsatira mu cell yomwe mwasankha.

Kudziwa koteroko kumathandiza kuthetsa mavuto ambiri a masamu, azachuma, akuthupi ndi ena. Tiyerekeze kuti tili ndi tebulo ndi malonda ogulitsa nsapato (awiriawiri) kwa kotala la 1, ndipo tikukonzekera kugulitsa 10% yowonjezera kotala lotsatira. Ndikofunikira kudziwa kuti ndi angati awiriawiri pa chinthu chilichonse chomwe chikugwirizana ndi 10%.

Kuti mumalize ntchitoyi, tsatirani izi:

1. Kuti zitheke, timapanga gawo latsopano, m'maselo omwe tidzawonetsa zotsatira za mawerengedwe. Sankhani selo loyamba la mzati (kuwerengera mitu) ndi kulemba fomula pamwamba pake, m'malo mwa nambala yofanana ndi adilesi ya selo: =10%*B2.
2. Pambuyo pake, dinani batani la Enter, ndipo zotsatira zake zidzawonetsedwa nthawi yomweyo mu selo ndi fomula.
3. Ngati tikufuna kuchotsa manambala pambuyo pa decimal, popeza kwa ife chiwerengero cha nsapato zikhoza kuwerengedwa ngati chiwerengero, timapita kumtundu wa selo (tinakambirana momwe tingachitire izi pamwambapa), kumene timasankha. mtundu wa manambala wopanda malo a decimal.
4. Tsopano mutha kukulitsa chilinganizocho ku ma cell otsala pamndandanda.

Pazochitika zomwe tifunika kupeza maperesenti osiyanasiyana kuchokera ku manambala osiyanasiyana, moyenerera, tiyenera kupanga gawo losiyana osati kusonyeza zotsatira, komanso chiwerengero cha chiwerengero.

1. Tinene kuti tebulo lathu lili ndi gawo "E" (Value%).
2. Timalemba fomula yomweyi mu selo loyamba la mzere wotsatira, pokhapo tikusintha mtengo wamtengo wapatali ku adiresi ya selo ndi mtengo wamtengo wapatali womwe uli mmenemo: =E2*B2.
3. Podina Enter timapeza zotsatira mu cell yomwe yapatsidwa. Zimangokhala kuzitambasula mpaka pansi.

Kutsiliza

Pogwira ntchito ndi matebulo, nthawi zambiri pamafunika kuwerengera ndi maperesenti. Mwamwayi, magwiridwe antchito a pulogalamu ya Excel amakulolani kuti muzichita mosavuta, ndipo ngati tikukamba za mawerengedwe amtundu womwewo pamatebulo akulu, njirayi imatha kukhala yokha, yomwe ingapulumutse nthawi yambiri.