Isikhokelo Sokunyathela Ngezinyathelo Ukusebenzisa I-Excel's CHOOSE Function

01 ka 02

Ukukhetha Idatha NGOKUSEBENZA Umsebenzi

UKHETHA Uluhlu Lwemisebenzi

Imisebenzi ye-Excel's Lookup , equka umsebenzi we-CHOOSE, isetyenziselwa ukufumana nokubuyisela idatha kwiluhlu okanye kwitafile ngokubhekiselele kwixabiso lookuphambili okanye inombolo yesazisi.

Kwimeko yokukhethwa, isebenzisa inombolo yenkcazo ukufumana nokubuyisela ixabiso elithile kwiluhlu oluthile lwedatha.

Inombolo yenkcazo ibonisa indawo yexabiso kwiluhlu.

Umzekelo, umsebenzi ungasetyenziselwa ukubuyisela igama lenyanga ethile yonyaka ngokusekelwe kwinombolo yenkcazo ukusuka kwi-1 ukuya kwe-12 ingena kwifom.

Njengemisebenzi eminingi ye-Excel, CHOOSE iyona ndlela isebenzayo xa ihlanganiswe namanye amafomula okanye imisebenzi ukubuyisela iziphumo ezahlukeneyo.

Umzekelo uya kuba ngumsebenzi ukhetha ukwenza izibalo usebenzisa i-Excel ye- SUM , AVERAGE , okanye imisebenzi ye- MAX kwidata elifanayo kuxhomekeke kwinombolo yenkcazo ekhethiweyo.

I-CHOOSE Umsebenzi we-Syntax kunye neeArguments

I- syntax yomsebenzi ibhekisela kwisakhiwo somsebenzi kwaye iquka igama lomsebenzi, amabakethi kunye neengxabano .

I-syntax ye-CHOOSE umsebenzi yile:

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

Index_num - (efunekayo) Inquma ukuba ixabiso libuyiselwa ngumsebenzi. Index_nom ingaba yinani phakathi kwe-1 no-254, ifomula, okanye isetyenziswe kwiseli equle inombolo phakathi kwe-1 no-254.

Ixabiso-(Ixabiso1 liyadingeka, ixabiso elongezelelweyo ukuya kuma-254 likhethiweyo) Uluhlu lwexabiso eliya kubuyiselwa ngumsebenzi kuxhomekeke kwi-Index_num argument. Iimilinganiselo zingaba ngamanani, iiferensi zeeselfowuni , iindawo ezikhankanyiweyo , amafomula, imisebenzi, okanye itekisi.

Umzekelo Ukusebenzisa i-Excel YOKUSEBENZA Umsebenzi ukuFumana Iinkcukacha

Njengoko kunokubonwa kumfanekiso ongentla, lo mzekelo uya kusebenzisa umsebenzi we-CHOOSE ukukunceda ukubala ibhonasi yonyaka yabasebenzi.

Ibhonasi yipesenti yomvuzo wabo wonyaka kwaye ipesenti isekelwe kwisilinganiselo sokusebenza phakathi kwe-1 no-4.

Umsebenzi we-CHOOSE uguqula izinga lokusebenza kwipesenti ezichanekileyo:

ukulinganisela - iipesenti 1 3% 2 5% 3 7% 4 10%

Ixabiso leepesenti liyakwandiswa ngumvuzo wonyaka ukufumana ibhonasi yonyaka yomqeshwa.

Umzekelo uquka ukungena kumsebenzi we-CHOOSE kwisitellite G2 uze usebenzise isibambo sokuzalisa ukukopisha umsebenzi kwiiseli G2 ukuya kwi-G5.

Ukufaka i-Tutorial Data

1. Faka idatha elandelayo kwiiseli D1 ukuya ku-G1
2. 
   I-Employee I-Salary Bonus J. Smith 3 $ 50,000 K. Jones $ 6,000,000 R. R. Johnston 3 $ 70,000 L. Rogers 2 $ 45,000

Ukungena kwiCandelo lokuSebenza

Eli candelo le-tutorial lingena kwi-CHOOSE umsebenzi kwi-cell G2 kwaye ibala iipesenti zebhonasi ngokusekelwe kumgangatho wokusebenza kumqeshwa wokuqala.

1. Cofa kwiseli G2 - yilapho iziphumo zomsebenzi ziza kuboniswa
2. Cofa kwiTrafom ithebhu yemenyu yebhondi
3. Khetha uLookup kunye neNkcukacha kwi-Ribbon ukuvula uluhlu lokuhla kwehla
4. Chofoza kwi- CHOOSE kwoluhlu ukukhupha ibhokisi yencoko yencoko yomsebenzi.
5. Kwibhokisi yencoko, nqakraza kwi Index_num line
6. Cofa kwiseli E2 kwiphepha lokusebenzela ukuze ufake ifowuni yesibini kwibhokisi yencoko
7. Cofa kwi- Value1 line kwibhokisi yencoko
8. Faka 3% kulo mgca
9. Cofa kwi- Value2 line kwibhokisi yencoko
10. Faka i- 5% kulo mgca
11. Cofa kwi- Value3 line kwibhokisi yencoko
12. Faka i- 7% kulo mgca
13. Cofa kwi- Value4 umgca kwibhokisi yencoko
14. Faka 10% kulo mgca
15. Cofa u-OK ukugqiba umsebenzi kwaye uvale ibhokisi yencoko
16. Ixabiso "0.07" kufuneka livele kwiseli ye-G2 leyo ifom ye-decimal ye-7%

02 we 02

KHETHA UMsebenzi woMzekelo (ukuqhubeka)

Ukubala iBhonus Employee

Eli candelo le-tutorial liguqula umsebenzi we-CHOOSE kwiseli ye-G2 ngokuphindaphinda iziphumo zomsebenzi ngexesha lomvuzo wonyaka womqeshwa ukubala ibhonasi yakhe yonyaka.

Olu lungiso lwenziwa ngokusebenzisa iF2 key ukwenza ifom.

1. Cofa kwi-cell G2, ukuba kuyimfuneko, ukwenza iseli esebenzayo
2. Cinezela iqhosha le-F2 kwikhibhodi ukubeka i-Excel kwimodi yokuhlela - umsebenzi opheleleyo
   = CHOOSE (E2, 3%, 5%, 7%, 10%) kufuneka ibonakale kwiseli kunye nenqaku lokufaka elikulo emva kokuvala kokusebenza komsebenzi
3. Thayipha i-asterisk ( * ), okuyiyo impawu yokuphindaphinda kwi-Excel, emva kwebhokisi lokuvala
4. Cofa kwifayile F2 kwiphepha lokusebenzela ukuze ufake iselferensi yeseli kumvuzo womqeshwa womnyaka kwindlela
5. Cinezela ukhiye wokungena kwikhibhodi ukugqiba ifomula uze ushiye imodi yokuhlela
6. Ixabiso "$ 3,500.00" limele livele kwiseli ye-G2, eyi-7% yomvuzo wonyaka we-$ 50,000.00
7. Cofa kwiseli G2, ifom epheleleyo = CHOOSE (E2, 3%, 5%, 7%, 10%) * F2 ibonakala kwifom yefomula esekelwe kwiphepha lokusebenzela

Ukukopisha iFormula yeBhonasi yeBhonasi kunye neSigxina sokuzalisa

Eli candelo lesifundo likopisha ifomu kwi-cell G2 kwiiseli G3 ukuya kwi-G5 usebenzisa isibambo sokuzalisa .

1. Cofa kwiseli G2 ukuze wenze iseli esebenzayo
2. Beka isikhombisi semouse phezu kwesikwere esimnyama kwicala eliphantsi lasezantsi yefowuni G2. I-pointer izakuguqula kwisibonakaliso esibandakanya "+"
3. Cofa iqhosha lesinxele le mouse kwaye udibanise isibambo sokugcwalisa phantsi kwiseli G5
4. Ukukhupha iqhosha le mouse. Iiselingi G3 ukuya kwi-G5 kufuneka ziqulethe amanani ebhonasi kubasebenzi abaseleyo njengoko kubonwe kumfanekiso kwiphepha 1 yale khokelo