Bukhu lotsogolera potsatira njira yogwiritsira ntchito Excel CHOOSE Function

01 a 02

Kusankha Dongosolo ndi CHOOSE Function

SANKHANI Ntchito Yachidule

Ntchito za Excel's Lookup , zomwe zimaphatikizapo CHOOSE ntchito, zimagwiritsidwa ntchito kupeza ndi kubwezeretsa deta kuchokera mndandanda kapena tebulo pogwiritsa ntchito chiwerengero choyang'ana kapena nambala ya ndondomeko.

Pankhani ya CHISANKHO, imagwiritsa ntchito nambala ya ndondomeko kupeza ndi kubwezera mtengo wapadera kuchokera mndandanda wa deta.

Nambala ya ndondomeko imasonyeza malo a mtengo mundandanda.

Mwachitsanzo, ntchitoyi ingagwiritsidwe ntchito kubwezeretsa dzina la mwezi wapadera wa chaka chotsatira nambala ya nambala kuyambira 1 mpaka 12 yomwe inalowa muyeso.

Mofanana ndi ntchito zambiri za Excel, CHOOSE ndi yogwira mtima kwambiri ngati ikuphatikizidwa ndi njira zina kapena ntchito kuti mubwererenso zotsatira zina.

Chitsanzo chingakhale kuti ntchitoyi ikhale yowerengera pogwiritsa ntchito ntchito ya SUM , AVERAGE , kapena MAX ya Excel pa deta yomweyi malinga ndi nambala ya ndondomeko yosankhidwa.

CHISANKHO Ntchito Yowonjezereka ndi Zokambirana

Syntax ya ntchito imatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabaki, ndi zifukwa .

Chizindikiro cha CHOOSE ntchito ndi:

= CHOOSE (Index_num, Value1, Value2, ... Value254)

Index_num - (zofunikira) Zimalongosola kuti Mtengo uyenera kubwezedwa ndi ntchitoyo. Index_num ikhoza kukhala nambala pakati pa 1 ndi 254, ndondomeko, kapena kutanthauza selo lokhala ndi nambala pakati pa 1 ndi 254.

Mtengo - (Kufunika1 kumafunikanso, zowonjezereka zowonjezera 254 ndizosankha) Mndandanda wa machitidwe omwe adzabwezeretsedwe ndi ntchitoyo malinga ndi Index_num argument. Makhalidwe angakhale nambala, malemba , maina , mayina, ntchito, kapena malemba.

Chitsanzo Pogwiritsa ntchito EXLE CHOOSE Ntchito kuti mupeze Deta

Monga momwe tingawonere pa chithunzi pamwamba, chitsanzo ichi chidzagwiritsa ntchito CHOOSE ntchito kuthandiza kuthandizira bonasi pachaka kwa antchito.

Bhonasi ndi peresenti ya malipiro awo chaka ndi chaka ndipo chiwerengerocho chimachokera pa kachitidwe ka pakati pa 1 ndi 4.

Ntchito YOPHUNZITSIRA imasintha chiwerengero cha ntchitoyi pazifukwa zoyenera:

kuwerengera - peresenti 1 3% 2 5% 3 7% 4 10%

Patsikuli la mtengo wapatali ndikuwonjezeka ndi malipiro a chaka kuti mupeze bonasi ya pachaka.

Chitsanzo chikukhudza kulowa mu CHOOSE ntchito mu selo G2 ndikugwiritsira ntchito chodzaza kuti mufanizire ntchitoyi ku maselo G2 mpaka G5.

Kulowa Datorial Data

1. Lowani deta zotsatirazi mu maselo D1 mpaka G1
2. 
   Ndondomeko ya ogwira ntchito Msonkho wa Bonasi J. Smith 3 $ 50,000 K. Jones $ 4,000 65,000 R. Johnston 3 $ 70,000 L. Rogers 2 $ 45,000

Kulowa Ntchito YOSANKHA

Gawo ili la phunzirolo limalowa mu CHOOSE ntchito mu selo G2 ndikuyesa maperesenti a bonasi malinga ndi momwe ntchito ikuyendera kwa wogwira ntchito yoyamba.

1. Dinani pa selo G2 - izi ndi zomwe zotsatira za ntchitoyi zidzawonetsedwa
2. Dinani pa Fomu tab ya menyu yowonjezera
3. Sankhani Kutsegula ndi Kutchulidwa kuchokera ku riboni kuti mutsegule ntchito yolemba pansi
4. Dinani pa CHISANKHO mu mndandanda kuti mubweretse bokosi lazokambirana .
5. Mu bokosi la bokosi, dinani pa Index_num line
6. Dinani pa selo E2 mu tsamba lothandizira kuti mulowetse selolo mu bokosi la dialog
7. Dinani pa Value1 mzere mu bokosi la dialog
8. Lowani 3% pamzerewu
9. Dinani pa Value2 mzere mu bokosi la dialog
10. Lowani 5% pamzerewu
11. Dinani pa Value3 mzere mu bokosi la dialog
12. Lowani 7% pamzerewu
13. Dinani pa Value4 mzere mu bokosi la dialog
14. Lowani 10% pamzerewu
15. Dinani OK kuti mutsirize ntchitoyi ndi kutseka bokosi la bokosi
16. Mtengo "0.07" uyenera kuwoneka mu selo G2 yomwe ili mawonekedwe a decimal kwa 7%

02 a 02

SANKHANI Ntchito Yotsatira (anapitiriza)

Kuwerengera Bonus Bonus

Gawo ili la phunziroli limasintha ntchito YOPHUNZIRA mu selo G2 powonjezerapo zotsatira za ntchitoyo nthawi ya malipiro a chaka cha antchito kuti awerengere bonasi yake pachaka.

Kusinthidwa uku kumapangidwa pogwiritsira ntchito F2 key kuti musinthe mawonekedwe.

1. Dinani pa selo G2, ngati kuli koyenera, kuti mupange selo yogwira ntchito
2. Dinani fichi F2 pa kibokosi kuti muike Excel mu kusintha mode - ntchito yonse
   = CHOOSE (E2, 3%, 5%, 7%, 10%) ayenera kuwonedwa mu selo ndi malo olembera omwe amapezeka pambuyo pa kutseka kwa ntchito
3. Lembani asteriski ( * ), yomwe ndi chizindikiro chochulukitsa mu Excel, mutatha kutsekera
4. Dinani pa selo F2 mu tsamba lothandizira kuti mulowetsere selo kwa wothandizira chaka chonse cha wothandizira mu njirayi
5. Lembani fungulo lolowamo mu Enter mubokosilo kuti mukwaniritse ndondomekoyi ndi kusiya njira yosinthira
6. Mtengo "$ 3,500.00" uyenera kuwonekera mu selo G2, yomwe ndi 7% ya malipiro a pachaka a antchito a $ 50,000.00
7. Dinani pa selo G2, yeniyeni yonse = CHOOSE (E2, 3%, 5%, 7%, 10%) * F2 ikuwoneka mu barra yazenera yomwe ili pamwamba pa tsamba

Kujambula Ntchito ya Bonuse Bonus ndi Yodzaza Mankhwala

Gawo ili la phunziroli limasindikiza ndondomekoyi mu selo G2 ku maselo G3 mpaka G5 pogwiritsa ntchito mankhwala odzaza .

1. Dinani pa selo G2 kuti mupange selo yogwira ntchito
2. Ikani pointeru ya mbewa pamtunda wakuda kumbali ya kumanja kwa selo G2. Pointer idzasintha ku chizindikiro chowonjezera "+"
3. Dinani botani lamanzere la mchenga ndi kukokera kukweza kugwiritsira ntchito selo G5
4. Tulutsani batani la mouse. Maselo G3 mpaka G5 ayenera kukhala ndi ziwerengero za bonasi kwa antchito otsala monga momwe tawonera pa chithunzi patsamba 1 la phunziro ili