Imisebenzi engama-30 ye-Excel ngezinsuku ezingama-30: KHETHA

Izolo kumarathon 30 Excel isebenza ngezinsuku ezingama-30 sithole imininingwane yendawo esisebenza kuyo ngomsebenzi INFO (KWAZISA) futhi uthole ukuthi ngeke esakwazi ukusisiza ngezinkinga zenkumbulo. Akuyona eyethu, noma inkumbulo ye-Excel!

Ngosuku lwesihlanu lwemarathon, sizofunda umsebenzi KHETHA (UKUKHETHA). Lo msebenzi ungowesigaba Izinkomba kanye nezinhla, ibuyisela inani ohlwini lwezinketho ezingase zibe khona ngokuya ngenkomba yezinombolo. Kuyaphawuleka ukuthi ezimweni eziningi kungcono ukukhetha omunye umsebenzi, isibonelo, INDEX (INDEX) kanye MATCH (KUDANWE KAKHULU) noma I-VLOOKUP (VPR). Sizofaka lezi zici ngokuhamba kwesikhathi kule marathon.

Ngakho-ke, ake siphendukele olwazini esinalo nezibonelo zomsebenzi KHETHA (UKUKHETHA), asikubone kusebenza, futhi siphawule nobuthakathaka. Uma unamanye amathiphu nezibonelo zalesi sici, sicela wabelane ngazo kumazwana.

Umsebenzi 05: KHETHA

Umsebenzi KHETHA (KHETHA) ibuyisela inani ohlwini, ilikhethe ngokuya ngenkomba yezinombolo.

Ungawusebenzisa kanjani umsebenzi othi KHETHA?

Umsebenzi KHETHA (KHETHA) ingabuyisela into esohlwini enombolweni ethile, kanje:

  • Ngenombolo yenyanga, buyisela inombolo yekota yezimali.
  • Ngokusekelwe kwidethi yokuqala, bala idethi yangoMsombuluko olandelayo.
  • Ngenombolo yesitolo, bonisa inani lokuthengisa.

I-syntax KHETHA

Umsebenzi KHETHA (KHETHA) ine-syntax elandelayo:

CHOOSE(index_num,value1,value2,…)

ВЫБОР(номер_индекса;значение1;значение2;…)

  • inombolo_yenkomba (inombolo_yenkomba) kumelwe ibe phakathi kuka-1 no-254 (noma 1 kuye ku-29 ku-Excel 2003 nangaphambili).
  • inombolo_yenkomba (inombolo_yenkomba) ingafakwa kumsebenzi njengenombolo, ifomula, noma ireferensi yelinye iseli.
  • inombolo_yenkomba (inombolo_yenkomba) izofinyezwa phansi ibe inamba eseduze.
  • izingxabano Inani (inani) kungaba izinombolo, izinkomba zamaseli, ububanzi obuqanjwe igama, imisebenzi, noma umbhalo.

Ama-Traps KHETHA (CHOICE)

Ku-Excel 2003 nangaphambilini, umsebenzi KHETHA (KHETHA) kusekelwe izimpikiswano ezingu-29 kuphela Inani (incazelo).

Kulula kakhulu ukucinga uhlu ekhasini lokusebenza kunokufaka zonke izakhi efomini. Ngemisebenzi I-VLOOKUP (VLOOKUP) noma MATCH (MATCH) Ungabheka uhlu lwamanani atholakala kumakhasi okusebenzela e-Excel.

Isibonelo sokuqala: Ikota yezimali ngenombolo yenyanga

Umsebenzi KHETHA (KHETHA) isebenza kahle ngohlu olulula lwezinombolo njengamanani. Isibonelo, uma iseli B2 iqukethe inombolo yenyanga, umsebenzi KHETHA (KHETHA) ingabala ukuthi iyiphi ikota yezimali okungeyayo. Esibonelweni esilandelayo, unyaka wezimali uqala ngoJulayi.

Ifomula ibala amanani ayi-12 ahambisana nezinyanga 1 kuya ku-12. Unyaka wezimali uqala ngoJulayi, ngakho izinyanga 7, 8, no-9 ziwela engxenyeni yokuqala. Kuthebula elingezansi, ungabona inombolo yekota yezimali ngaphansi kwenombolo yenyanga ngayinye.

Imisebenzi engama-30 ye-Excel ngezinsuku ezingama-30: KHETHA

Kuyasebenza KHETHA (KHETHA) Inombolo yekota kufanele ifakwe ngendlela ezivele ngayo etafuleni. Isibonelo, ohlwini lwamanani omsebenzi KHETHA (KHETHA) ezikhundleni I-7, i-8 ne-9 (July, August and September) kufanele kube inombolo 1.

=CHOOSE(C2,3,3,3,4,4,4,1,1,1,2,2,2)

=ВЫБОР(C2;2;3;3;3;4;4;4;1;1;1;2;2;2)

Faka inombolo yenyanga kuseli C2, kanye nomsebenzi KHETHA (KHETHA) izobala inombolo yekota yezimali kuseli C3.

Imisebenzi engama-30 ye-Excel ngezinsuku ezingama-30: KHETHA

Isibonelo sesi-2: Bala usuku lwangoMsombuluko olandelayo

Umsebenzi KHETHA (KHETHA) ingasebenza ngokuhambisana nomsebenzi NGESONTO (DAYWEEK) ukuze ubale amadethi azayo. Isibonelo, uma uyilungu leklabhu ehlangana njalo ngoMsombuluko kusihlwa, ngokwazi idethi yanamuhla, ungakwazi ukubala idethi yangoMsombuluko olandelayo.

Isibalo esingezansi sibonisa izinombolo ze-serial zosuku ngalunye lweviki. Ikholomu H yosuku ngalunye lweviki iqukethe inani lezinsuku ongazingeza osukwini lwamanje ukuze uthole uMsombuluko olandelayo. Isibonelo, udinga ukwengeza usuku olulodwa kuphela ngeSonto. Futhi uma namuhla kunguMsombuluko, kusasele izinsuku eziyisikhombisa kuze kube uMsombuluko olandelayo.

Imisebenzi engama-30 ye-Excel ngezinsuku ezingama-30: KHETHA

Uma idethi yamanje ikuseli C2, ifomula kuseli C3 isebenzisa imisebenzi NGESONTO (USUKU) kanye KHETHA (KHETHA) ukubala usuku lwangoMsombuluko olandelayo.

=C2+CHOOSE(WEEKDAY(C2),1,7,6,5,4,3,2)

=C2+ВЫБОР(ДЕНЬНЕД(C2);1;7;6;5;4;3;2)

Imisebenzi engama-30 ye-Excel ngezinsuku ezingama-30: KHETHA

Isibonelo sesi-3: Bonisa inani lentengiso yesitolo esikhethiwe

Ungasebenzisa umsebenzi KHETHA (KHETHA) ngokuhambisana neminye imisebenzi efana ISUM (SUM). Kulesi sibonelo, sizothola amanani aphelele okuthengisa esitolo esithile ngokucacisa inombolo yaso kumsebenzi KHETHA (KHETHA) njengempikiswano, kanye nokufaka kuhlu ububanzi bedatha yesitolo ngasinye ukuze kubalwe amanani.

Esibonelweni sethu, inombolo yesitolo (101, 102, noma 103) ifakwe kuseli C2. Ukuze uthole inani lenkomba elifana no-1, 2, noma 3 esikhundleni sika-101, 102, noma 103, sebenzisa ifomula: =C2-100.

Idatha yokuthengisa yesitolo ngasinye ikukholomu ehlukile njengoba kuboniswe ngezansi.

Imisebenzi engama-30 ye-Excel ngezinsuku ezingama-30: KHETHA

Ngaphakathi komsebenzi ISUM (SUM) umsebenzi uzokwenziwa kuqala KHETHA (KHETHA), okuzobuyisela uhla olufiswayo lokuhlanganisa oluhambisana nesitolo esikhethiwe.

=SUM(CHOOSE(C2-100,C7:C9,D7:D9,E7:E9))

=СУММ(ВЫБОР(C2-100;C7:C9;D7:D9;E7:E9))

Imisebenzi engama-30 ye-Excel ngezinsuku ezingama-30: KHETHA

Lesi isibonelo sesimo lapho kusebenza kahle kakhulu ukusebenzisa eminye imisebenzi efana ne INDEX (INDEX) kanye MATCH (SESHA). Kamuva ku-marathon yethu, sizobona ukuthi basebenza kanjani.

shiya impendulo