Zamkatimu
Kuzindikira kuchuluka kwa nambala ndi ntchito yodziwika bwino yomwe wogwiritsa ntchito Ecxel yemwe amagwira ntchito ndi manambala amayenera kukumana nayo. Kuwerengera koteroko ndikofunikira kuti mugwire ntchito zambiri: kudziwa kukula kwa kuchotsera, kuyika, misonkho, ndi zina zotero. Lero tiphunzira mwatsatanetsatane zomwe tingachite kuti tichulukitse chiwerengero ndi peresenti.
Momwe mungachulukitsire nambala ndi peresenti mu Excel
Peresenti ndi chiyani? Ichi ndi kachigawo kakang'ono ka 100. Mogwirizana ndi izi, chizindikiro cha peresenti chimamasuliridwa mosavuta kukhala mtengo wochepa. Mwachitsanzo, 10 peresenti ikufanana ndi nambala 0,1. Choncho, ngati tichulukitsa 20 ndi 10% ndi 0,1, tidzakhala ndi chiwerengero chomwecho - 2, popeza ndicho chimodzimodzi chakhumi cha chiwerengero cha 20. Pali njira zambiri zowerengera maperesenti mu spreadsheets.
Momwe mungawerengere peresenti pamanja mu selo imodzi
Njira imeneyi ndi yosavuta. Ndikokwanira kungodziwa kuchuluka kwa nambala inayake pogwiritsa ntchito njira yokhazikika. Sankhani selo lililonse, ndikulemba fomula: uXNUMXd nambala * chiwerengero cha peresenti. Iyi ndi njira yapadziko lonse lapansi. Momwe zimawonekera pochita ndizosavuta kuwona pazithunzi izi.
Tikuwona kuti tagwiritsa ntchito fomula =20*10%. Ndiko kuti, dongosolo la mawerengedwe amalembedwa mu chilinganizo chimodzimodzi monga chowerengera ochiritsira. Ndicho chifukwa chake njira iyi ndi yosavuta kuphunzira. Titalowa fomula pamanja, imatsalira kukanikiza fungulo lolowera, ndipo zotsatira zake zidzawonekera mu cell momwe tidazilemba.
Musaiwale kuti chiwerengerocho chimalembedwa ndi chizindikiro % komanso ngati gawo la decimal. Palibe kusiyana kwakukulu pakati pa njira zojambulira izi, popeza izi ndizofanana.
Chulukitsani nambala mu selo limodzi ndi peresenti mu selo lina
Njira yapitayi ndi yosavuta kuphunzira, koma ili ndi drawback imodzi - sitigwiritsa ntchito mtengo kuchokera ku selo ngati nambala. Chifukwa chake, tiyeni tiwone momwe mungapezere kuchuluka kwa data kuchokera ku cell. Amango nthawi zambiri amakhala ofanana, koma chinthu chimodzi chowonjezera chiyenera kuwonjezeredwa. Kuti muchite izi, tsatirani njira zomwe zafotokozedwa m'bukuli:
- Tiyerekeze kuti tikufunika kudziwa kukula kwa gawolo ndikuwonetsa mugawo la E. Kuti tichite izi, sankhani selo loyamba ndikulemba momwemonso momwe zilili kale, koma m'malo mwa manambala, tchulani maadiresi a selo. Mukhozanso kuchita motsatira ndondomeko zotsatirazi: choyamba lembani chizindikiro cholowetsa fomu =, kenako dinani pa selo yoyamba yomwe tikufuna kupeza deta, kenako lembani chizindikiro chochulukitsa *, kenako dinani pa selo yachiwiri. Mukalowa, tsimikizirani mafomuwo podina batani la "ENTER".
- Mu cell yofunika, tikuwona mtengo wonse.
Kuti muwerengeretu zinthu zina zonse, muyenera kugwiritsa ntchito chikhomo cha autocomplete.
Kuti muchite izi, sunthani cholozera cha mbewa pakona yakumanzere ndikukokera kumapeto kwa gawo la tebulo. Deta yofunikira idzagwiritsidwa ntchito yokha.
Pakhoza kukhala vuto lina. Mwachitsanzo, tifunika kudziwa kuti gawo limodzi mwa magawo anayi azinthu zomwe zili mugawo lina lidzakhala zingati. Ndiye muyenera kuchita chimodzimodzi monga chitsanzo chapitachi, ingolembani 25% ngati mtengo wachiwiri m'malo mwa adiresi ya selo yomwe ili ndi gawo ili la chiwerengero. Chabwino, kapena gawani ndi 4. Njira zogwirira ntchito ndizofanana pankhaniyi. Pambuyo kukanikiza chinsinsi cha Enter, timapeza zotsatira zomaliza.
Chitsanzochi chikusonyeza mmene tinadziwira kuchuluka kwa zolakwikazo potengera kuti tikudziwa kuti pafupifupi kota ya njinga zonse zopangidwa zili ndi zolakwika. Palinso njira ina momwe imawerengera mtengo ngati peresenti. Kuti tiwonetse, tiyeni tiwone vuto ili: pali gawo C. Nambala zili mmenemo. Kufotokozera kofunikira - kuchuluka kwake kumangowonetsedwa mu F2. Choncho, posamutsa chilinganizocho, sichiyenera kusintha. Zotani pankhaniyi?
Nthawi zambiri, muyenera kutsatira njira zomwezo monga momwe zidalili kale. Choyamba muyenera kusankha D2, ikani = chizindikiro ndi kulemba chilinganizo kuchulukitsa selo C2 ndi F2. Koma popeza tili ndi gawo limodzi lokha mu selo limodzi, tiyenera kukonza. Kwa izi, mtundu wa adilesi wathunthu umagwiritsidwa ntchito. Sichisintha pokopera selo kuchokera kumalo ena kupita kwina.
Kuti musinthe mtundu wa adilesi kuti ukhale mtheradi, muyenera dinani F2 mtengo mumzere wolowetsa fomula ndikusindikiza batani F4. Pambuyo pake, chizindikiro cha $ chidzawonjezedwa ku chilembo ndi nambala, zomwe zikutanthauza kuti adiresi yasintha kuchoka ku chiyanjano kupita ku mtheradi. Njira yomaliza idzawoneka motere: $ F $ 2 (m'malo mokanikiza F4, mukhoza kuwonjezera chizindikiro cha $ ku adilesiyo nokha).
Pambuyo pake, muyenera kutsimikizira zosinthazo mwa kukanikiza batani la "ENTER". Pambuyo pake, zotsatira zake zidzawonekera mu selo loyamba la gawo lofotokoza kuchuluka kwa ukwati.
Tsopano chilinganizocho chimasamutsidwa ku maselo ena onse, koma kutchulidwa mtheradi sikunasinthe.
Kusankha momwe mungasonyezere kuchuluka mu selo
Zakambidwa kale kuti maperesenti amabwera m'mitundu iwiri yoyambira: ngati gawo la decimal kapena mu mawonekedwe a % apamwamba. Excel imakupatsani mwayi wosankha yomwe mumakonda kwambiri munthawi inayake. Kuti muchite izi, muyenera kudina kumanja pa selo lomwe lili ndi kachigawo kakang'ono ka nambala, ndiyeno sinthani mawonekedwe a selo posankha chinthu choyenera mumenyu yankhani.
Kenako, zenera adzaoneka ndi angapo tabu. Tili ndi chidwi ndi yoyamba, yolembedwa kuti "Nambala". Kumeneko muyenera kupeza mtundu wa kuchuluka kwa mndandanda womwe uli kumanzere. Wogwiritsa ntchito amasonyezedwa pasadakhale momwe selo lidzawonekera litagwiritsidwa ntchito. M'munda womwe uli kumanja, mutha kusankhanso kuchuluka kwa malo omwe amaloledwa mukuwonetsa nambalayi.
Ngati mukufuna kuwonetsa gawo la nambala ngati gawo la decimal, muyenera kusankha mtundu wa nambala. Maperesenti agawika okha ndi 100 kuti apange kagawo kakang'ono. Mwachitsanzo, selo lomwe lili ndi mtengo wa 15% lidzasinthidwa kukhala 0,15.
Muzochitika zonsezi, kuti mutsimikizire zochita zanu mutalowetsa deta pawindo, muyenera kukanikiza OK batani. Tikuwona kuti palibe chovuta kuchulukitsa nambala ndi peresenti. Zabwino zonse.