Mafomu Omwe Amajambula Malamulo

Kuwonjezera maonekedwe ovomerezeka mu Excel amakulolani kugwiritsa ntchito njira zosiyana siyana zomwe mungapangire maselo kapena maselo osiyanasiyana omwe amakumana ndi zikhalidwe zina zomwe mumayika.

Zosankha zojambula zimagwiritsidwa ntchito pamene maselo osankhidwa amakwaniritsa zinthu izi.

Zokonzekera zomwe mungathe kuzigwiritsa ntchito ndizojambula ndi maonekedwe a mtundu wa m'mbuyo, mafashoni a mazenera, malire a maselo, ndi kuwonjezera chiwerengero cha nambala ku deta.

Kuchokera mu Excel 2007, Excel yakhala ndi njira zingapo zokhazikitsidwa zomwe zimagwiritsidwa ntchito kawirikawiri monga kupeza ziwerengero zazikulu kuposa zochepa kapena zochepa kapena kupeza manambala omwe ali pamwamba kapena pansi pa mtengo wapatali .

Kuphatikiza pa izi zisanachitike, zingatheke kukhazikitsa malamulo ovomerezeka ndi machitidwe ogwiritsa ntchito Excel maulendo kuti ayese machitidwe omwe akugwiritsidwa ntchito.

Kugwiritsa Ntchito Malamulo Ambiri

Malamulo oposa angagwiritsidwe ntchito pa deta yomweyi kuti ayese zosiyana. Mwachitsanzo, chiwerengero cha bajeti chikhoza kukhala ndi zinthu zomwe zimagwiritsidwa ntchito posintha maonekedwe pamene zigawo zina - monga 50%, 75%, ndi 100% - za bajeti zonse zatha.

Zikatero, Excel poyamba amadziwa ngati malamulo osiyanasiyana amatsutsana, ndipo, ngati zili choncho, pulogalamuyi ikutsatira ndondomeko yoyenera kuti adziwe kuti ndi lamulo liti lomwe limagwiritsidwa ntchito pa deta.

Chitsanzo: Kupeza Dongosolo lomwe limaposa 25% ndi 50% Kuwonjezeka ndi Kulemba Machitidwe

Mu chitsanzo chotsatira, miyambo iwiri yokhala ndi maimidwe yovomerezeka idzagwiritsidwa ntchito ku maselo osiyanasiyana B2 mpaka B5.

• lamulo loyambirira likufufuza kuti muwone ngati deta m'maselo A2 mpaka A5 ndi wamkulu kusiyana ndi mtengo wofanana mu B2 mpaka B5 ndi oposa 25%.
• lamulo lachiwiri likufufuza kuti liwone ngati deta yomweyo mu A2: A5 iposa mtengo wofanana mu B2: B5 ndi zoposa 50%.

Monga momwe tingawonere pa chithunzi pamwambapa, ngati chimodzi mwazimenezo ndi zoona, mtundu wa selo kapena maselo omwe ali pa B1: B4 udzasintha.

• kwa deta kumene kusiyana kuli kwakukulu kuposa 25%, mtundu wa chigawo cha selo udzasintha.
• ngati kusiyana kuli kwakukulu kuposa 50% mtundu wa chigawo cha selo udzasintha kukhala wofiira.

Malamulo ogwira ntchitoyi,

= (A2-B2) / A2> 25% = (A2-B2) / A2> 50%

Adzalowamo pogwiritsira ntchito zolemba zatsopano zolemba mauthenga .

Kulowa Datorial Data

1. Lowani deta mu maselo A1 mpaka C5 monga momwe mukuwonera pa chithunzi pamwambapa

Zindikirani: Gawo 3 la phunzirolo lidzawonjezera ma fomu kumaselo C2: C4 omwe amasonyeza kusiyana kwenikweni pakati pa miyezo m'maselo A2: A5 ndi B2: B5 kuti awonetse molondola malamulo omwe ali nawo.

Kuyika Malamulo Okhazikitsa Malemba

Monga tafotokozera, malamulo ovomerezeka omwe akutsatiridwa pazigawo ziwiri adzalowamo pogwiritsira ntchito ndondomeko yatsopano yopanga Mauthenga otsogolera .

Kuyika maonekedwe ovomerezeka kuti mupeze kuchuluka kwa 25%

1. Onetsetsani maselo B2 ku B5 patsamba.
2. Dinani pa tabu la Home la riboni.
3. Dinani pajambula Yokonzera Zokhazikika mu Riboni kuti mutsegule menyu.
4. Sankhani Lamulo Latsopano kuti mutsegule Bokosi la Mauthenga Watsopano la Kukonza Maonekedwe monga momwe taonera pa chithunzi pamwambapa.
5. Pamwamba pa theka la bokosi la bokosi, dinani pamapeto omaliza: Gwiritsani ntchito ndondomeko kuti mudziwe maselo omwe angapangidwe.
6. Pakatikati mwa theka la bokosi la bokosi, dinani muzomwe mumapangidwe momwe chiganizochi chiri chowona: mzere.
7. Lembani fomu : = (A2-B2) / A2> 25% mu malo operekedwa
8. Dinani pa batani la Fomu kuti mutsegule bokosi la mauthenga a mawonekedwe.
9. Mu bokosi ili, dinani pa Lembani tabu ndi kusankha mtundu wa buluu.
10. Dinani KULI kawiri kuti mutseke mabokosi a malingaliro ndi kubwereranso kuntchito.
11. Panthawiyi, mtundu wa maselo B3 ndi B5 uyenera kukhala wabuluu.

Kuyika maonekedwe ovomerezeka kuti mupeze kuwonjezeka kwakukulu kwa 50%

1. Ndi maselo B2 mpaka B5 akadasankhidwa, bweretsani masitepe 1 mpaka 6 pamwambapa.
2. Lembani fomu: = (A2-B2) / A2> 50% mu malo operekedwa.
3. Dinani pa batani la Fomu kuti mutsegule bokosi la mauthenga a mawonekedwe.
4. Dinani pa Lembani tabu ndi kusankha mtundu wofiira.
5. Dinani KULI kawiri kuti mutseke mabokosi a malingaliro ndi kubwereranso kuntchito.
6. Mtundu wa selo B3 uyenera kukhala wabuluu ukusonyeza kuti peresenti ya kusiyana pakati pa manambala mu maselo A3 ndi B3 ndi aakulu kuposa 25% koma osachepera kapena ofanana ndi 50%.
7. Mtundu wa selo B5 uyenera kukhala wofiira wosonyeza kuti peresenti ya kusiyana pakati pa nambala mu maselo A5 ndi B5 ndi oposa 50%.

Kuyang'anitsitsa Malamulo Olemba Malemba

Kuwerengera% Kusiyana

Kuti muwone kuti malamulo ovomerezeka a maofesiwa alowa ndi olondola, titha kulowa ma selo C2: C5 yomwe idzawerengera zenizeni kusiyana pakati pa nambala mu mndandanda A2: A5 ndi B2: B5.

1. Dinani pa selo C2 kuti mupange selo yogwira ntchito.
2. Lembani mu formula = (A2-B2) / A2 ndipo pindani makiyi a Enter mu makina.
3. Yankho la 10% liyenera kuoneka mu selo C2, kusonyeza kuti chiwerengero cha selo A2 chiri 10% kuposa chiwerengero mu selo B2.
4. Zingakhale zofunikira kusintha mawonekedwe pa selo C2 kuti muwonetse yankho peresenti.
5. Gwiritsani ntchito cholembera kuti mufanizire fomuyi kuchokera mu selo C2 kupita ku maselo C3 mpaka C5.
6. Mayankho a maselo C3 mpaka C5 ayenera kukhala: 30%, 25%, ndi 60%.
7. Mayankho mu maselowa amasonyeza kuti malamulo ovomerezeka omwe amapangidwa amakhala olondola chifukwa kusiyana pakati pa maselo A3 ndi B3 ndiposa 25% ndipo kusiyana pakati pa maselo A5 ndi B5 ndiposa 50%.
8. Cell B4 sinasinthe mtundu chifukwa kusiyana pakati pa maselo A4 ndi B4 kuli ofanana ndi 25%, ndipo lamulo lathu lokhazikitsa maonekedwe limatanthawuza kuti peresenti yaikulu kuposa 25% inkafunika kuti mtundu wachikulire ukhale wobiriwira.

Ndondomeko Yoyamba ya Malamulo Okhazikitsa Malamulo

Kugwiritsa ntchito Malamulo Osemphana Nawo Otsutsana

Pamene malamulo angapo akugwiritsidwa ntchito pa deta yofanana, Excel poyamba amadziwa ngati malamulo amatsutsana.

Malamulo otsutsana ndi omwe machitidwe osankhidwa opangidwira pa malamulo onse sangathe kugwiritsidwa ntchito pa deta yomweyi.

Muchitsanzo chomwe chimagwiritsidwa ntchito mu phunziroli, malamulowa amatsutsana kuyambira pamene malamulo onsewa amagwiritsa ntchito njira yofanana - yosintha mtundu wa selo.

Pomwe malamulo achiwiri ali oona (kusiyana kwa mtengo ndiposa 50% pakati pa maselo awiri) ndiye lamulo loyambalo (kusiyana kwakukulu kuliposa 25%) ndiloona.

Order ya Precelence ya Excel

Popeza selo silikhoza kukhala lofiira ndi lofiira panthawi imodzimodzi, Excel iyenera kudziwa kuti ndi lamulo liti la maonekedwe lomwe liyenera kukhazikika.

Kodi ndi lamulo liti lomwe limagwiritsidwa ntchito likukhazikitsidwa ndi dongosolo la Excel loyambirira, lomwe likunena kuti lamulo lomwe liri pamwamba pa mndandanda wa Malamulo Okhazikitsa Malamulo a Gulu la dialog dialog ali patsogolo.

Monga momwe tawonetsera pa chithunzi pamwambapa, lamulo lachiwiri lomwe likugwiritsidwa ntchito mu phunziroli (= (A2-B2) / A2> 50%) ndilopamwamba pa mndandanda, choncho, limakhala patsogolo pa ulamuliro woyamba.

Zotsatira zake, mtundu wa selo B5 umasinthidwa kukhala wofiira.

Mwachizolowezi, malamulo atsopano amawonjezeredwa pamwamba pa mndandanda ndipo, motero, ali ndi malo apamwamba.

Kusintha ndondomeko yoyamba kugwiritsira ntchito makina a Up ndi Down Down mu bokosi la bokosi monga momwe tawonetsera pa chithunzi pamwambapa.

Kugwiritsa ntchito Malamulo Osagwirizana

Ngati malamulo awiri ovomerezeka ovomerezeka osagwirizana onsewa agwiritsidwa ntchito ngati chikhalidwe chilichonse chikuyesedwa.

Ngati malamulo oyambirira olemba maonekedwe anu muzitsanzo zathu (= (A2-B2) / A2> 25%) adawonetsera maselo ambiri B2: B5 ndi malire a buluu mmalo mwa mtundu wa buluu, malamulo awiri ovomerezeka sakugwirizana Zonsezi zingagwiritsidwe ntchito popanda kusokoneza wina.

Chotsatira chake, selo B5 likhoza kukhala ndi malire a buluu ndi mtundu wofiira, chifukwa kusiyana pakati pa manambala mu maselo A5 ndi B5 kuli wamkulu kuposa 25 ndi 50 peresenti.

Mafomu ovomerezeka ndi Masinthidwe Omwe Nthawi Zonse

Pankhani ya mikangano pakati pa malamulo opanga maonekedwe ndi machitidwe opangidwa ndi machitidwe oyenera, malamulo okhazikitsa machitidwe nthawi zonse amayamba kutsogolo ndipo adzagwiritsidwa ntchito mmalo mwaziganizo zina zoonjezera zojambulidwa.

Ngati mtundu wachikasu unkagwiritsidwa ntchito pamaselo B2 mpaka B5 mu chitsanzo, pokhapokha malamulo ovomerezeka apangidwe adawonjezeredwa, maselo okha B2 ndi B4 angakhale achikasu.

Chifukwa malamulo ovomerezeka amalowetsedwa akugwiritsidwa ntchito ku maselo B3 ndi B5, mitundu yawo ya m'mbuyo imasintha kuchokera ku chikasu kupita ku buluu ndi ofiira.