Momwe mungawerengere kuchuluka kwa nambala mu Excel. Momwe mungawerengere share mu Excel

Zochita zokhala ndi magawo nthawi zambiri zimachitika mu Microsoft Excel, ndizosavuta komanso zothandiza. Kuti tichite izi, pulogalamuyi imagwiritsa ntchito njira zapadera ndi ntchito. M'nkhaniyi, tikambirana mwatsatanetsatane njira zonse zopezera chiwerengero cha chiwerengero.

Kuwerengera gawo kuchokera pa nambala yoperekedwa

Nthawi zina ndikofunikira kudziwa kuchuluka kwa nambala imodzi mumzake. Kuti muchite izi, gwiritsani ntchito njira iyi: Gawani (%) = Nambala 1/Nambala 2*100%. Nambala 1 ndiyo yoyamba, Nambala 2 ndi imodzi yomwe gawo la nambala 1 limapezeka. Tiyeni tiganizire ntchito ya masamu ndi chitsanzo. Tangoganizani kuti muyenera kupeza gawo la nambala 18 mu nambala 42. Muyenera kuchita masitepe awiri:

1. Sankhani cell yopanda kanthu ndikulemba fomula pamenepo ndi manambala omwe mwapatsidwa. Chizindikiro chofanana chimafunika chisanachitike chilinganizo, apo ayi kuwerengera kodziwikiratu sikudzachitika.

2. Dinani batani la "Enter", selo lidzawonetsa mtengo wa kuwerengera monga peresenti kapena nambala yokhazikika.

Zofunika! Sikoyenera kulemba gawo la "* 100" mu formula. Kagawo kakang'ono kangadziwike mwa kungogawa nambala imodzi ndi ina.

Ngati zotsatira zake ndi nambala, osati peresenti, muyenera kusintha mawonekedwe a maselo. Izi zitha kuchitika pogwiritsa ntchito gawo loyenera pazida za Excel.

1. Dinani pa selo ndi batani lakumanja la mbewa. Menyu idzatsegulidwa pomwe muyenera kusankha chinthu cha "Format Maselo".

Mutha kupezanso njira iyi pa tabu Yanyumba. Kumeneko ili mu gawo la "Maselo" (kachigawo "Format").

2. Menyu yokhala ndi zosankha zosinthira mawonekedwe idzawonekera pazenera. Mu tabu "Nambala" pali mndandanda wa mawonekedwe a nambala - muyenera kusankha "Percentage". Mwachikhazikitso, malo awiri a decimal amaikidwa, koma izi zikhoza kukhazikitsidwa ndi mabatani a mivi. Mukamaliza zoikamo, dinani "Chabwino". Tsopano selo yosankhidwa nthawi zonse imakhala ndi deta mumtundu wa chiwerengero.

Tiyeni tigwiritse ntchito chidziwitso chomwe tapeza pa chitsanzo chovuta kwambiri. Mwachitsanzo, muyenera kudziwa gawo la mtundu uliwonse wazinthu pazopeza zonse. Kuti tikwaniritse ntchitoyi, tipanga tebulo lomwe tikuwonetsa mtengo wazinthu zingapo, kuchuluka kwa malonda ndi ndalama. Muyeneranso kuwerengera ndalama zonse pogwiritsa ntchito SUM. Pamapeto pa tebulo, tipanga gawo la magawo onse omwe amapeza ndi maselo mumtundu wamtundu. M'pofunika kuganizira mawerengedwe a chizindikiro ichi sitepe ndi sitepe:

1. Sankhani selo loyamba laulere mugawo lomaliza ndikulowetsa fomula yowerengera gawo m'mundamo. Nambala 1 idzakhala ndalama kuchokera ku malonda a chinthu chimodzi, ndipo chachiwiri - chiwerengero cha ndalama zonse.

2. Dinani batani la "Enter", chiwerengerocho chidzawonekera mu selo.

Kenako, muyenera kudzaza ndime yonse ndi deta yotere. Sikofunikira kuyika fomula pamanja nthawi iliyonse - timangodzaza kudzaza ndikusintha pang'ono kwa mawuwo.

1. Chigawo chimodzi cha chilinganizo chimasintha kuchokera ku mzere kupita ku mzere, chinacho chimakhala chimodzimodzi. Tiyeni tiwonetsetse kuti ntchitoyi ikasamutsidwa ku selo lina, mkangano umodzi wokha umasinthidwa. Muyenera kudina pa cell yodzazidwa ndikuyika zikwangwani za dollar kutsogolo kwa chilembo ndi nambala pofotokozera ndalama zonse kudzera mu bar ya formula. Mawuwo ayenera kuwoneka motere: =D2 / $D$ 10.
2. Kenako, sankhani ma cell onse omwe ali mugawo mpaka pamzere wa "Total" pogwira ngodya yakumanja ya foni yoyamba. Mzere uliwonse uli ndi chidziwitso chokhudza gawo la katundu mu ndalama zonse.

3. Mutha kupeza gawo muzopeza zomaliza popanda kuwerengera ndalama. Tiyeni tigwiritse ntchito SUM - mawu omwe ali nawo alowa m'malo mwa mtsutso wachiwiri.
4. Tiyeni tipange fomula yatsopano: =Zopeza pamtundu umodzi wazinthu/SUM(Zopeza pazogulitsa zonse). Chifukwa cha kuwerengera, timapeza nambala yofanana ndi yomwe timagwiritsa ntchito njira yapitayi:

Kuwerengera kuchuluka kwa nambala yoperekedwa

Ntchito yosinthira - kuchotsa chiwerengero cha nambala mumtundu wokhazikika wa nambala - imakhalanso yofunikira. Tiyeni tiwone momwe tingachitire kuwerengera koteroko. Fomula yowerengera ndi: Nambala 2 = Peresenti (%) * Nambala 1. Tanthauzo la mawu awa: kuchuluka kwake kumatsimikiziridwa kuchokera ku Nambala 1, zomwe zimapangitsa Nambala 2. Tiyeni tiyese ndondomekoyi pa chitsanzo chenicheni. Ndikofunikira kudziwa kuchuluka kwake - 23% ya 739.

1. Timasankha selo laulere ndikulemba ndondomeko mmenemo ndi deta yodziwika.

2. Dinani "Enter", zotsatira za kuwerengera zikuwonekera pa pepala.

Tcherani khutu! Pamenepa, simuyenera kusintha mtundu wa selo chifukwa mukufuna nambala, osati peresenti.

Kwa chitsanzo cha deta, mungagwiritse ntchito tebulo lopangidwa kale. Tangoganizani kuti mwezi wamawa mukukonzekera kugulitsa mayunitsi 15% a chinthu chilichonse. Ndikofunikira kudziwa kuti kuchuluka kwa zopanga zamitundu yosiyanasiyana kumafanana ndi 15%.

1. Timapanga gawo latsopano ndikulowetsa chilinganizo chogwirizana ndi deta yodziwika mu selo loyamba laulere.

2. Dinani batani la "Enter" ndikupeza zotsatira.
3. Timasamutsa fomuyo ku maselo onse a chigawocho pogwiritsa ntchito chogwirira chodzaza.

Mutha kuchotsa malo a decimal posintha mawonekedwe a cell. Sankhani maselo onse okhala ndi zotsatira, tsegulani menyu yamitundu ndikusankha Nambala. Muyenera kuchepetsa chiwerengero cha malo a decimal kukhala ziro ndikudina "Chabwino", pambuyo pake ndimeyi imakhala ndi manambala okha.

Kuonjezera ndi kuchotsa chidwi

Kutengera njira zomwe zili pamwambazi, mutha kuchita masamu osavuta ndi maperesenti.

Kuwerengera kuchuluka kwa nambala ndi kuchuluka kwake kuli motere: Nambala=Nambala+(Pesenti (%)*Nambala). Kusiyanaku kumasiyana ndi chizindikiro chokha: Difference=Nambala-(Pesenti (%)*Nambala).

Ganizirani za izi ndi zitsanzo - onjezani 530% mpaka 31, kenaka chotsani chiwerengero chomwecho pa chiwerengero choyambirira. Muyenera kusankha foni yaulere ndikuyika fomula, kenako dinani "Lowani".

Zida za Excel zimakupatsani mwayi wowerengera kusiyana pakati pa manambala awiri omwe amafotokozedwa ngati peresenti. Njira yochitira izi ndi: Kusiyana=(Nambala 2-Nambala 1)/Nambala 1*100%. 

Timagwiritsa ntchito chilinganizochi mu chitsanzo: kugulitsa katundu kwawonjezeka, ndipo tifunika kudziwa kuti ndi magawo otani azinthu zamitundu yosiyanasiyana zomwe zidagulitsidwa.

1. Mugawo lopangidwa mwapadera, sankhani selo lapamwamba ndikulemba fomula mmenemo. Nambala 1 ndi 2 ndizogulitsa zakale komanso zatsopano.

2. Dinani "Enter" ndikupeza zotsatira zoyamba.
3. Sankhani ma cell onse amzawo okhala ndi cholembera chodziyimira pawokha - chilinganizocho chimakopedwa ndi chotsitsa.

Kutsiliza

Kugwira ntchito ndi maperesenti mu Excel ndikosavuta, chifukwa mafomuwa ndi ofanana ndi zomwe ambiri amazidziwa pamaphunziro a masamu. Komabe, ndikosavuta kwambiri kuwerengera chidwi ndi pulogalamuyi, chifukwa ndizotheka kuwerengera mawerengedwewo.