Umhlahlandlela Wokuzinyathelo Wokusebenzisa Ukusebenzisa i-Excel's CHOOSE Function

01 ngo-02

Ukukhetha idatha nge-CHOOSE Umsebenzi

Khetha ISIGABA SOMSEBENZI

Imisebenzi ye-Excel's Lookup , efaka umsebenzi we-CHOOSE, isetshenziselwa ukuthola nokubuyisela idatha ohlwini noma etafuleni esekelwe inani lokubheka noma inombolo yenkomba.

Endabeni yokukhethwa, isebenzisa inamba yenkomba ukuthola futhi ubuyisele inani elithile kusuka kuhlu oluhambelana nedatha.

Inombolo yenkomba ibonisa isikhundla sexabiso ohlwini.

Isibonelo, umsebenzi ungasetshenziswa ukubuyisela igama lenyanga ethile yonyaka ngokususelwa kwinombolo yenkomba kusuka ku-1 kuya ku-12 efakwe kwifomula.

Njengemisebenzi eminingi ye-Excel, CHOOSE iphumelela kakhulu uma ihlanganiswa namanye amafomula noma imisebenzi ukubuyisela imiphumela ehlukile.

Isibonelo kungaba ukuthi umsebenzi ukhethe ukwenza izibalo usebenzisa i-Excel sika- SUM , AVERAGE , noma imisebenzi ye- MAX kumininingwane efanayo kuye ngokuthi inombolo yenkomba ekhethiwe.

I-CHOOSE Umsebenzi we-Syntax ne-Arguments

I- syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi, amabakaki, nokuphikisana .

I-syntax yomsebenzi we-CHOOSE yilezi:

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

I-index_num - (edingekayo) Inquma ukuthi yiliphi inani elizobuyiselwa umsebenzi. I-index_num ingaba yinombolo ephakathi kuka-1 no-254, ifomula, noma ireferensi yeseli equkethe inombolo ephakathi kuka-1 no-254.

Inani - (Inani1 liyadingeka, amanani angeziwe angaphezu kuka-254 angakhetha) Uhlu lwamagugu azobuyiselwa umsebenzi kuye ngokuthi Index_num argument. Izindinganiso zingaba izinombolo, izingqikithi zeseli , izigaba ezibizwa , amafomula, imisebenzi, noma umbhalo.

Isibonelo Ukusebenzisa i-Excel's CHOOSE Umsebenzi ukuze uthole idatha

Njengoba kungabonakala esithombeni ngenhla, lesi sibonelo sizosebenzisa umsebenzi we-CHOOSE ukusiza ukubala ibhonasi yonyaka yabasebenzi.

Ibhonasi iphesenti yehora yabo yonyaka futhi iphesenti isekelwe isilinganiso sokusebenza phakathi kuka-1 no-4.

Umsebenzi we-CHOOSE uguqula isilinganiso sokusebenza kumaphesenti afanele:

isilinganiso - amaphesenti 1 3% 2 5% 3 7% 4 10%

Inani lamaphesenti liphinde liphindwe ngumholo wonyaka ukuze uthole ibhonasi yonyaka wesisebenzi.

Isibonelo sihlanganisa ukufaka umsebenzi we-CHOOSE esitokisini G2 bese usebenzisa isibambo sokugcwalisa ukukopisha umsebenzi kumaseli G2 kuya ku-G5.

Ukufaka idatha yokufundisa

1. Faka idatha elandelayo kumaseli D1 kuya ku-G1
2. 
   Ibhonasi Yesikhombiso Sabasebenzi I-Smith Smith 3 $ 50,000 K. Jones 4 $ 65,000 R. Johnston 3 $ 70,000 L. Rogers 2 $ 45,000

Ukufaka umsebenzi we-CHOOSE

Lesi sigaba sokufundisa sifaka umsebenzi we-CHOOSE esitokisini G2 futhi sinquma amaphesenti ebhonasi ngokusezingeni lokusebenza kwesisebenzi sokuqala.

1. Chofoza kuseli G2 - yilapho imiphumela yomsebenzi izoboniswa khona
2. Chofoza kuthebhu yefomula yemenyu ye- ribbon
3. Khetha Ukubheka kanye neNkhombandlela kusuka kubhebhoni ukuvula uhlu lwehla lokusebenza
4. Chofoza ku- CHOOSE ohlwini ukuze ukhulise ibhokisi lengxoxo lomsebenzi.
5. Ebhokisini lengxoxo, chofoza ku- Index_numugqa
6. Chofoza ku-cell E2 ekhasini lokusebenzela ukuze ufake ireferensi yeseli ebhokisini lengxoxo
7. Chofoza ku- Value1 line ebhokisini lengxoxo
8. Faka u- 3% kulolu gqa
9. Chofoza ku- Value2 line ebhokisini lengxoxo
10. Faka u- 5% kulolu gqa
11. Chofoza ku- Value3 line ebhokisini lengxoxo
12. Faka i- 7% kulolu gqa
13. Chofoza ku- Value4 line ebhokisini lengxoxo
14. Faka u- 10% kulolu gqa
15. Chofoza OK ukuqedela umsebenzi bese uvala ibhokisi lengxoxo
16. Inani "0.07" kufanele livele esitokisini G2 okuyinto ifomu lesimingcele ye-7%

02 ka 02

Khetha isenzo somsebenzi (ukuqhubeka)

Ukubala iBhonus Employee

Lesi sigaba sokufundisa siguqula umsebenzi we-CHOOSE esitokisini G2 ngokuphindaphinda imiphumela yesikhathi sokusebenza umholo wonyaka wesisebenzi ukubala ibhonasi yakhe yonyaka.

Lokhu kuguqulwa kwenziwa ngokusebenzisa ukhiye we-F2 ukuze uhlele ifomula.

1. Chofoza ku-cell G2, uma kunesidingo, ukwenza iseli esebenzayo
2. Cindezela ukhiye we-F2 ekhibhodi ukubeka i-Excel kumodi yokuhlela - umsebenzi ophelele
   = CHOOSE (E2, 3%, 5%, 7%, 10%) kufanele ibonakale esitokisini ngephoyinti lokufaka elitholakala ngemuva kokukhishwa kokusebenza komsebenzi
3. Thayipha i-asterisk ( * ), okuyisimboli sokuphindaphinda ku-Excel, ngemuva kokubhada kokuvala
4. Chofoza ku- cell F2 ekhasini lokusebenzela ukuze ufake ireferensi yeseli kumholo wonyaka wesisebenzi kwifomula
5. Cindezela ukhiye wokungena kwikhibhodi ukuqedela ifomula bese ushiya imodi yokuhlela
6. Inani "$ 3,500.00" kufanele livele esitokisini G2, okuyi-7% yomholo wonyaka wesisebenzi we $ 50,000.00
7. Chofoza ku-cell G2, ifomula ephelele = CHOOSE (E2, 3%, 5%, 7%, 10%) * F2 ibonakala kwibha yefomula esekelwe ngaphezulu kwephepha lokusebenzela

Ukukopisha i-Formula Bonus Formula ne-Fill Handle

Lesi sigaba sokufundisa sikopisha ifomu ku-cell G2 kumaseli G3 kuya ku-G5 usebenzisa isibambo sokugcwalisa .

1. Chofoza kuseli G2 ukuze wenze iseli esebenzayo
2. Beka isikhombisi segundane phezu kwesikwele esimnyama ngakwesokudla kwesokudla kweselula G2. I-pointer izoshintsha ibe nesibonakaliso esengeziwe "+"
3. Chofoza inkinobho yegundane lesokunxele bese uhudula isibambo sokugcwalisa phansi kweseli G5
4. Khipha inkinobho yegundane. Amaseli G3 kuya ku-G5 kufanele abe nezinombolo zebhonasi zabasebenzi abasele njengoba kuboniswe esithombeni ekhasini 1 lale tutorial