Momwe mungawerengere kuchuluka kwa markup mu Excel

Mu Microsoft Office Excel, ndizotheka kuwerengera kuchuluka kwa zolembera za chinthu china mu nthawi yaifupi kwambiri pogwiritsa ntchito fomula yapadera. Tsatanetsatane wa mawerengedwe adzafotokozedwa m'nkhaniyi.

Markup ndi chiyani

Kuti muwerenge parameter iyi, choyamba muyenera kumvetsetsa kuti ndi chiyani. Markup ndi kusiyana pakati pa mtengo wamtengo wapatali ndi wogulitsa katundu, zomwe zimabweretsa kuwonjezeka kwa mtengo wazinthu kwa ogula omaliza. Kukula kwa malire kumatengera zinthu zambiri, ndipo kuyenera kulipira ndalamazo.

Tcherani khutu! Mphepete mwa malire ndi chizindikiro ndi mfundo ziwiri zosiyana ndipo siziyenera kusokonezedwa wina ndi mzake. Mphepete mwa malire ndi phindu lochokera ku malonda a katundu, omwe amapezeka pambuyo pochotsa ndalama zofunikira.

Momwe mungawerengere kuchuluka kwa Markup mu Excel

Palibe chifukwa chowerengera pamanja. Izi sizoyenera, chifukwa. Excel imakupatsani mwayi wopanga masamu aliwonse, kupulumutsa nthawi ya wogwiritsa ntchito. Kuti muwerengere mwachangu kuchuluka kwa mapulogalamu mu pulogalamuyi, muyenera kuchita izi:

1. Lembani tebulo lachidziwitso choyambirira. Ndikosavuta kugwira ntchito ndi mizati yomwe yatchulidwa kale. Mwachitsanzo, gawo lomwe zotsatira za fomula zidzawonetsedwa zitha kutchedwa "Markup,%". Komabe, mutu wagawo sukhudza zotsatira zomaliza ndipo chifukwa chake ukhoza kukhala chilichonse.
2. Ikani chizindikiro cha "Equals" kuchokera pa kiyibodi kupita ku cell yofunikira, yopanda kanthu pagulu la tebulo ndikulowetsa fomu yomwe yatchulidwa m'gawo lapitalo. Mwachitsanzo, lowetsani "(C2-A2) / A2 * 100". Chithunzi chili m'munsichi chikuwonetsa ndondomeko yolembedwa. M'makoloko muli mayina a maselo omwe amalembedwa phindu ndi mtengo wa katundu. M'malo mwake, ma cell amatha kukhala osiyana.

3. Dinani "Enter" pa kiyibodi ya pakompyuta kuti mumalize fomula.
4. Onani zotsatira. Pambuyo popanga zomwe zili pamwambapa, patebulo pomwe fomula idalowetsedwa, nambala yeniyeni iyenera kuwonetsedwa yomwe ikuwonetsa chizindikiro cha malonda ngati peresenti.

Zofunika! Chizindikirocho chikhoza kuwerengedwa pamanja kuti muwone ngati mtengo wake ndi wolondola. Ngati zonse zili zolondola, ndiye kuti fomula yosankhidwayo iyenera kutambasulidwa ku mizere yotsala ya tebulo kuti ingodzaza zokha.

Momwe margin amawerengedwera mu MS Excel

Kuti mumvetse bwino mutuwo, m'pofunika kuganizira lamulo la kuwerengera malire mu Microsoft Office Excel. Apanso, pasakhale mavuto ngakhale kwa ogwiritsa ntchito osadziwa pulogalamuyo. Kuti mupeze zotsatira zabwino, mutha kugwiritsa ntchito algorithm yatsatane-tsatane:

1. Pangani spreadsheet kuti muwerenge malire. Pamndandanda woyamba wa tebulo, mutha kuyika magawo angapo owerengera, kuphatikiza malire.
2. Ikani cholozera cha mbewa mu selo lolingana la mbale, ikani chizindikiro "Equal" ndikulemba ndondomeko yomwe yasonyezedwa pamwambapa. Mwachitsanzo, tiyeni tilembe mawu otsatirawa: "(A2-C2) / C2 * 100".

3. Dinani "Enter" kuchokera pa kiyibodi kuti mutsimikizire.
4. Onani zotsatira. Wogwiritsa ntchitoyo awonetsetse kuti selo yomwe yasankhidwa kale ili ndi mtengo womwe umadziwika ndi chizindikiro cha malire. Kuti mutsimikizire, mutha kuwerengeranso mtengowo pamanja ndi zizindikiro zomwe zafotokozedwa. Ngati mayankho aphatikizana, ndiye kuti fomula yosankhidwayo imatha kukulitsidwa ku maselo otsala a tebulo. Pankhaniyi, wogwiritsa ntchito adzipulumutsa kuti asadzazenso chilichonse chofunikira patebulo, ndikupulumutsa nthawi yake.

Zina Zowonjezera! Ngati mutatha kulemba fomuyi, pulogalamu ya Microsoft Office Excel ikupanga zolakwika, ndiye kuti wogwiritsa ntchitoyo ayenera kuyang'anitsitsa kulondola kwa zilembo zomwe zalembedwa m'mawuwo.

Mutatha kuwerengera zizindikiro ndi zizindikiro za m'mphepete mwa nyanja, mukhoza kukonza zikhalidwezi patebulo loyambirira kuti muwone kusiyana pakati pa zomwe zimadalira ziwirizi.

Momwe mungawerengere mtengo wamtengo mu Excel

Ngati wogwiritsa ntchito akufunika kumvetsetsa kuchuluka kwa chiwongolero chomwe chiwerengedwecho chikufanana, ayenera kuchita izi:

1. Mu selo iliyonse yaulere ya tsamba la Excel, lembani chilinganizo "= mtengo wamtengo wapatali * kuchuluka konse." Zambiri pachithunzi pansipa.

2. Dinani "Enter" kuchokera pa kiyibodi ya PC kuti mumalize fomula.
3. Onani zotsatira. M'malo mwa chilinganizo, nambala yeniyeni idzawonekera mu selo, zomwe zidzakhala zotsatira za kutembenuka.

4. Mukhoza kuwonjezera chilinganizo ku mizere yotsala ya tebulo ngati chiwerengero chonse chomwe chiwerengerocho chikuwerengedwa chiri chofanana ndi chikhalidwe chonsecho.

Tcherani khutu! Kuyang'ana mtengo wowerengeka kumachitika mosavuta pamanja pogwiritsa ntchito chowerengera wamba.

Momwe mungawerengere kuchuluka kwa nambala mu Excel

Iyi ndi njira yosinthira yomwe takambirana pamwambapa. Mwachitsanzo, muyenera kuwerengera kuchuluka kwa nambala 9 kuchokera pa nambala 17. Kuti muthane ndi ntchitoyi, muyenera kuchita motere:

1. Ikani cholozera cha mbewa mu cell yopanda kanthu mu Excel worksheet.
2. Lembani ndondomeko "= 9/17 * 100%".

3. Dinani "Enter" kuchokera pa kiyibodi kuti mumalize chilinganizo ndikuwona zotsatira zomaliza mu selo lomwelo. Zotsatira zake ziyenera kukhala 52,94%. Ngati ndi kotheka, chiwerengero cha manambala pambuyo pa decimal mfundo akhoza kuwonjezeka.

Kutsiliza

Chifukwa chake, chizindikiro cham'mphepete mwa chinthu china mu Microsoft Office Excel chimawerengedwa pogwiritsa ntchito njira yokhazikika. Chinthu chachikulu ndikulemba mawuwo molondola, kusonyeza maselo oyenerera omwe amalembedwa mfundo zofunika. Kuti mumvetse bwino mutuwu, muyenera kuwerenga mosamala zomwe zili pamwambapa.