Percentage Growth Formula mu Excel

Ogwiritsa ntchito a Excel nthawi zambiri amakumana ndi zidziwitso zamaperesenti. Pali ntchito zambiri ndi ogwiritsa ntchito omwe amakulolani kuti musinthe maperesenti. M'nkhaniyi, tisanthula mwatsatanetsatane momwe tingagwiritsire ntchito fomula yokulirapo mumkonzi wa spreadsheet.

Kuwerengera maperesenti mu spreadsheet

Mkonzi wa spreadsheet ndi wabwino chifukwa amawerengera okha, ndipo wogwiritsa ntchito amangofunika kuyika mfundo zoyambirira ndikuwonetsa mfundo yowerengera. Kuwerengera kumachitika motere: Gawo / Lonse = Peresenti. Malangizo atsatanetsatane amawoneka motere:

Pogwira ntchito ndi zidziwitso zamaperesenti, selo liyenera kusinthidwa moyenera.

1. Dinani pa cell yomwe mukufuna ndi batani lakumanja la mbewa.
2. Pazosankha zazing'ono zapadera zomwe zikuwonekera, sankhani batani lotchedwa "Format Cells".

3. Apa muyenera dinani kumanzere pa chinthu "Format", ndiyeno kugwiritsa ntchito "Chabwino", sungani zosintha zomwe zasinthidwa.

Tiyeni tiwone chitsanzo chaching'ono kuti timvetsetse momwe tingagwiritsire ntchito ndi chiwerengero cha chidziwitso mu spreadsheet editor. Malangizo atsatanetsatane amawoneka motere:

1. Tili ndi mizati itatu patebulo. Yoyamba imasonyeza dzina la mankhwala, yachiwiri imasonyeza zizindikiro zomwe zakonzedwa, ndipo yachitatu imasonyeza zenizeni.

2. Mu mzere D2 timayika fomula ili: = C2 / B2.
3. Pogwiritsa ntchito malangizo omwe ali pamwambawa, timamasulira gawo la D2 kukhala mawonekedwe aperesenti.
4. Pogwiritsa ntchito chikhomo chapadera chodzaza, timatambasula ndondomeko yomwe yalowetsedwa ku gawo lonse.

5. Okonzeka! Mkonzi wa spreadsheet yekha anawerengera kuchuluka kwa kukhazikitsidwa kwa dongosolo pa chinthu chilichonse.

Yerengani Kusintha Kwa Maperesenti Pogwiritsa Ntchito Njira Yakukulirakulira

Pogwiritsa ntchito mkonzi wa spreadsheet, mutha kugwiritsa ntchito njira yofananizira magawo awiri. Kuti muchite izi, njira yakukula ndi yabwino kwambiri. Ngati wogwiritsa ntchito ayenera kufananiza manambala a A ndi B, ndiye kuti njirayo idzawoneka ngati: =(BA)/A=kusiyana. Tiyeni tione zonse mwatsatanetsatane. Malangizo atsatanetsatane amawoneka motere:

1. Mzere A uli ndi mayina a katundu. Mzere B uli ndi mtengo wake wa Ogasiti. Mzere C uli ndi mtengo wake wa September.
2. Mawerengedwe onse ofunikira adzachitika mugawo la D.
3. Sankhani cell D2 ndi batani lakumanzere ndikulowetsamo zotsatirazi: =(C2/B2)/B2.

4. Sunthani cholozera ku ngodya yakumanja ya selo. Zinatenga mawonekedwe ang'onoang'ono kuphatikiza chizindikiro cha mtundu wakuda. Pogwiritsa ntchito batani lakumanzere lakumanzere, timatambasulira fomulayi mpaka pagawo lonse.
5. Ngati zikhalidwe zomwe zimafunikira zili mugawo limodzi lazinthu zina kwa nthawi yayitali, ndiye kuti mawonekedwewo asintha pang'ono. Mwachitsanzo, gawo B lili ndi chidziwitso cha miyezi yonse yogulitsa. Pagawo C, muyenera kuwerengera zosintha. Fomula idzawoneka chonchi: =(B3-B2)/B2.

6. Ngati manambala amayenera kufananizidwa ndi deta inayake, ndiye kuti mawuwo akuyenera kukhala otsimikizika. Mwachitsanzo, ndikofunikira kufananiza miyezi yonse yogulitsa ndi Januwale, ndiye kuti chilinganizocho chitenga mawonekedwe awa: =(B3-B2)/$B$2. Ndi chitsimikiziro chamtheradi, mukasunthira fomula ku ma cell ena, ma coordinates adzakhazikika.

7. Zizindikiro zabwino zimasonyeza kuwonjezeka, pamene zizindikiro zoipa zimasonyeza kuchepa.

Kuwerengera kuchuluka kwa kukula mumkonzi wa spreadsheet

Tiyeni tiwone mwatsatanetsatane momwe tingawerengere kuchuluka kwa kukula mumkonzi wa spreadsheet. Kukula/kukula kumatanthauza kusintha kwa mtengo wina. Amagawidwa m'mitundu iwiri: yoyambira ndi unyolo.

Kukula kwa unyolo kumatanthawuza chiŵerengero cha kuchuluka kwa chizindikiro cham'mbuyo. Ndondomeko ya kukula kwa chain ndi motere:

Kukula kwa m'munsi kumatanthawuza chiŵerengero cha peresenti ku chiwerengero chapansi. Njira yoyambira kukula ndi motere:

Chizindikiro cham'mbuyomu ndi chizindikiro cha kotala yapitayi, mwezi, ndi zina zotero. Chiyambi ndi chiyambi. Kukula kwa unyolo ndi kusiyana kowerengeka pakati pa zizindikiro za 2 (zakale ndi zam'mbuyo). Ndondomeko ya kukula kwa chain ndi motere:

Mlingo woyambira ndikuwerengera kusiyana pakati pa zizindikiro za 2 (panopa ndi maziko). Njira yoyambira kukula ndi motere:

Tiyeni tiganizire zonse mwatsatanetsatane pa chitsanzo chapadera. Malangizo atsatanetsatane amawoneka motere:

1. Mwachitsanzo, tili ndi mbale yotere yomwe imawonetsa ndalama zomwe zimapeza ndi kotala. Ntchito: Kuwerengera kuchuluka kwa kukula ndi kukula.

2. Poyamba, tidzawonjezera mizati inayi yomwe idzakhala ndi mafomu omwe ali pamwambawa.

3. Tapeza kale kuti zikhalidwe zotere zimawerengedwa ngati peresenti. Tiyenera kukhazikitsa mtundu wamtundu wamaselo oterowo. Dinani pamtundu wofunikira ndi batani lakumanja la mbewa. Pazosankha zazing'ono zapadera zomwe zikuwonekera, sankhani batani lotchedwa "Format Cells". Apa muyenera dinani kumanzere mbewa batani pa "Format" chinthu, ndiyeno ntchito "Chabwino" batani, kusunga zosintha.
4. Timalowetsa ndondomeko yotereyi yowerengera kukula kwa unyolo ndikuyikopera ku maselo apansi.

5. Timalowetsa chilinganizo chotere cha kukula kwa unyolo ndikuchikopera ku maselo apansi.

6. Timalowetsa ndondomeko yotereyi yowerengera kukula kwa unyolo ndikuyikopera ku maselo apansi.

7. Timalowetsa chilinganizo chotere cha kukula kwa unyolo ndikuchikopera ku maselo apansi.

8. Okonzeka! Takhazikitsa kuwerengera kwa zizindikiro zonse zofunika. Kutsiliza kutengera chitsanzo chathu chapadera: mu gawo la 3, mphamvu zake zimakhala zosauka, popeza kukula kwake ndi zana limodzi, ndipo kukula kuli bwino.

Mapeto ndi ziganizo za kuwerengera kwa kukula kwa peresenti

Tapeza kuti mkonzi wa spreadsheet Excel amakulolani kuti muwerenge kuchuluka kwa kukula ngati peresenti. Kuti mugwiritse ntchito njirayi, mumangofunika kuyika mafomu onse ofunikira m'maselo. Ndizofunikira kudziwa kuti ma cell omwe zotsatira zake zidzawonetsedwa ayenera kusinthidwa kukhala mawonekedwe amtundu pogwiritsa ntchito menyu yankhani ndi chinthu cha "Format Cells".