Percentage Kukura Formula muExcel

Vashandisi veExcel vanowanzobata neruzivo rwezana. Kune akawanda mabasa uye maopareta anotendera iwe kuti utore maperesenti. Muchinyorwa ichi, isu tichaongorora zvakadzama maitiro ekushandisa iyo muzana yekukura formula mupepeti yespredishiti.

Kuverenga zvikamu muspredishiti

Iyo spreadsheet mupepeti yakanaka nekuti inoita akawanda ekuverenga ari ega, uye mushandisi anongoda kuisa maitiro ekutanga uye kuratidza musimboti wekuverenga. Kuverenga kunoitwa seizvi: Chikamu/Yese = Percent. Detailed mirairo inoita seizvi:

Paunenge uchishanda nehuwandu hwemashoko, sero rinofanira kuumbwa zvakakodzera.

1. Dzvanya pane sero yaunoda nebhatani rekurudyi rembeva.
2. Mune diki yakakosha menyu inooneka, sarudza bhatani rinonzi "Format Cells".

3. Pano iwe unofanirwa kudzvanya-kuruboshwe pane "Format" chinhu, uye wozoshandisa iyo "OK" chinhu, chengetedza shanduko dzakaitwa.

Ngatitarisei muenzaniso mudiki kuti tinzwisise maitiro ekushanda nehuwandu hweruzivo mupepeti yespredishiti. Detailed mirairo inoita seizvi:

1. Tine makoramu matatu mutafura. Yokutanga inoratidza zita rechigadzirwa, yechipiri inoratidza zviratidzo zvakarongwa, uye yechitatu inoratidza izvo chaizvo.

2. Mumutsara D2 tinoisa inotevera fomula: = C2 / B2.
3. Tichishandisa mirairo iri pamusoro, tinoshandura ndima yeD2 kuita fomu yezana.
4. Tichishandisa yakakosha kuzadza marker, tinotambanudza yakapinda formula kune iyo column yese.

5. Ready! Mupepeti wespredishiti pachawo akaverenga chikamu chekushandiswa kwechirongwa chechigadzirwa chega chega.

Kuverenga Mazana Shanduko Uchishandisa Kukura Formula

Uchishandisa mupepeti wespredishiti, unogona kuita maitiro ekuenzanisa zvikamu zviviri. Kuita chiitiko ichi, fomura yekukura yakanaka. Kana mushandisi achida kuenzanisa nhamba dzeA uye B, iyo fomula ichaita senge: =(BA)/A=musiyano. Ngatitarisei pane zvese zvakadzama. Detailed mirairo inoita seizvi:

1. Column A ine mazita emidziyo. Column B ine kukosha kwayo kwaNyamavhuvhu. Column C ine kukosha kwayo kwaGunyana.
2. Ese maverengero anodiwa achaitwa mukoramu D.
3. Sarudza sero D2 neruboshwe mbeva bhatani uye isa inotevera fomula ipapo: =(C2/B2)/B2.

4. Fambisa chinongedzo kukona yekurudyi yesero. Yakatora chimiro chechidiki plus chiratidzo cherima ruvara. Tichishandisa bhatani rekuruboshwe regonzo rakadzvanywa, isu tinotambanudza iyi fomula kune iyo column yese.
5. Kana iyo inodiwa yakakosha iri muchikamu chimwe chechimwe chigadzirwa kwenguva yakareba, saka fomura inochinja zvishoma. Semuenzaniso, koramu B ine ruzivo rwemwedzi yese yekutengesa. Muchikamu C, unofanirwa kuverenga shanduko. Iyo formula ichaita seizvi: =(B3-B2)/B2.

6. Kana nhamba dzenhamba dzichida kuenzaniswa nedata chairo, saka iyo element referensi inofanirwa kuitwa yakakwana. Semuenzaniso, zvinodikanwa kuenzanisa mwedzi yese yekutengesa naNdira, ipapo fomula inotora fomu rinotevera: =(B3-B2)/$B$2. Nereferensi yakakwana, kana iwe uchifambisa fomula kune mamwe maseru, macoordinates anozogadziriswa.

7. Zviratidzo zvakanaka zvinoratidza kuwedzera, asi zviratidzo zvisina kunaka zvinoratidza kuderera.

Kuverengera kweyero yekukura mupepeti yespredishiti

Ngatitarisei zvakanyanya kuti tingaverenge sei mwero wekukura mupepeti yespredishiti. Chiyero chekukura/kukura zvinoreva shanduko mune imwe kukosha. Yakakamurwa kuva marudzi maviri: basic uye cheni.

Chiyero chekukura kweketani chinoreva chiyero cheperesenti kune chiratidzo chekare. Iyo ketani yekukura mwero formula ndeiyi inotevera:

Chiyero chekukura kwehwaro (base growth rate) chinoreva chiyero chechikamu kusvika pachiyero chepasi. Iyo yakakosha chiyero chekukura formula ndeiyi inotevera:

Chiratidzo chekare ndicho chiratidzo mukota yapfuura, mwedzi, zvichingodaro. Iyo yekutanga ndiyo yekutanga. The cheni kukura mwero ndiyo yakaverengerwa musiyano pakati 2 zviratidzo (yazvino uye yapfuura). Iyo ketani yekukura mwero formula ndeiyi inotevera:

Huwandu hwekukura kwehwaro ndiyo mutsauko wakaverengerwa pakati pe2 zviratidzo (ikozvino uye hwaro). Iyo yakakosha chiyero chekukura formula ndeiyi inotevera:

Ngatitarisei zvese zvakadzama pane chaiyo muenzaniso. Detailed mirairo inoita seizvi:

1. Semuenzaniso, tine ndiro yakadaro inoratidza mari nekota. Basa: Verenga mwero wekukura uye kukura.

2. Pakutanga, tichawedzera makoramu mana ayo achange aine mafomula ari pamusoro.

3. Isu takatoona kuti hunhu hwakadai hunoverengerwa sepesenti. Isu tinofanirwa kuseta mafomati emasero akadaro. Dzvanya pane zvinodiwa nebhatani rekurudyi. Mune diki yakakosha menyu inooneka, sarudza bhatani rinonzi "Format Cells". Pano iwe unofanirwa kudzvanya bhatani rekuruboshwe mbeva pane "Format" element, uye wozoshandisa bhatani re "OK", chengetedza shanduko dzakaitwa.
4. Isu tinopinda fomuro yakadaro yekuverenga chiyero chekukura kweketani uye tinoikopa kumasero ezasi.

5. Isu tinopinda fomula yakadaro yeiyo yakakosha cheni yekukura mwero uye tinoikopa kune yakaderera maseru.

6. Isu tinopinda fomuro yakadaro yekuverenga chiyero chekukura kweketani uye tinoikopa kumasero ezasi.

7. Isu tinopinda fomula yakadaro yeiyo yakakosha cheni yekukura mwero uye tinoikopa kune yakaderera maseru.

8. Ready! Isu takaita kuverengerwa kwezviratidzo zvese zvinodiwa. Mhedziso inobva pamuenzaniso wedu chaiwo: muchikamu che3, maitiro ari kuderera, sezvo chiyero chekukura chiri zana muzana, uye kukura kwakanaka.

Mhedziso uye mhedziso pamusoro pekuverenga kwekukura muhuwandu

Isu takaona kuti iyo spreadsheet mupepeti Excel inobvumidza iwe kuverenga chiyero chekukura seperesenti. Kuti uite iyi nzira, iwe unongoda kuisa ese anodiwa mafomula mumaseru. Zvakakosha kucherechedza kuti masero umo mhedzisiro inodiwa icharatidzwa anofanirwa kutanga ashandurwa kuita muzana fomati uchishandisa menyu yemukati uye "Format Cells" chinhu.