Nhungamiro Yokutora-Nhanho Kushandisa Kushandiswa kweExcel Basa

01 ye 02

Kusarudza Data neCOOSE Basa

SARUDZA Basa Basa Rokutanga

Excel's Lookup mabasa, iyo inosanganisira CHOOSE function, inoshandiswa kuwana nekudzorera dheta kubva pakurongwa kana patafura zvichienderana nenhare yekuona kana nhamba ye index.

Muchiitiko cheCHOOSE, inoshandisa nhamba ye index kuti iwane uye inodzorera huwandu hunokosha kubva pane zvakakodzerwa nedata.

Nhamba yenhamba inoratidza chinzvimbo chekukosha mune urongwa.

Semuenzaniso, basa racho rinogona kushandiswa kudzorera zita remwedzi chaiwo wegore zvichienderana nenhamba yenyorwa kubva kuna 1 kusvika kusvika 12 yakapinda mumutambo.

Kufanana nemamwe mabasa eExcel, CHOOSE ndiyo inonyanya kushanda kana ichibatanidzwa nemamwe maitiro kana mabasa kuti adzokere mhinduro dzakasiyana.

Muenzaniso unenge uri wekuti basa racho risarudze kuita zviyero kuburikidza neExcel SUM , AVERAGE , kana MAX mabasa pane imwechete iyo zvichienderana nenhamba yenzorani yakasarudzwa.

ICHOOSE Function Syntax uye Arguments

Mutsara webasa unoreva kurongeka kwebasa uye rinosanganisira zita rebasa, mabheji, uye nharo .

Mutsara weCOOSE basa ndeyu:

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

Index_num - (inodikanwa) Inosarudza kuti Chiiko chinodzorerwa nemabasa. Index_num inogona kuva nhamba pakati pe1 ne254, chimiro, kana kutaridzirwa kune sero ine nhamba pakati pe1 ne254.

Kukosha - (Value1 inotarisirwa, mamwe maitiro kusvika kune 254 anosarudza) Mazita ehutano huchadzorerwa nebasa zvichienderana ne Index_num argument. Mitemo inogona kuva nhamba, masero ekufambisa , mazita akasiyana-siyana , mazano, mabasa, kana mavara.

Muenzaniso Kushandisa Excel CHOOSE Basa rekuwana Data

Sezvo zvinogona kuonekwa mumufananidzo uri pamusoro, muenzaniso uyu uchishandisa CHOOSE basa kubatsira kubatsira kuverenga bhayasi yebasa yevashandi.

Bhonasi iyi inopera muzana yemari yavo yegore uye purogiramu yakavakirwa pahutano hwekuita pakati pe1 ne4.

Iyo CHOOSE basa rinoshandura hutano hwekushanda muzvikamu zvakakwana:

chiyero - zvikamu 1 3% 2 5% 3 7% 4 10%

Iko muzana yehuwandu inowanzowedzererwa nemutengo wegore negore kuti uwane bhonasi yegore yevashandi.

Muenzaniso unosvika kupinda CHOOSE basa muchikamu cheG2 uye unoshandisa chigadziro chokuzadza kukopa basa kumasero G2 kusvika kuG5.

Kupinda Tutorial Data

1. Isa data inotevera inhengo D1 kusvika kuG1
2. 
   Mushandi weZvashandi Mubhadharo Bonus J. Smith 3 $ 50,000 K. Jones 4 $ 65,000 R. Johnston 3 $ 70,000 L. Rogers 2 $ 45,000

Kupinda CHOOSE Basa

Ichi chikamu chekudzidzisa chinopinda CHOOSE basa muchikamu cheG2 uye inotora mazana emabhonasi zvichienderana nehutano hwekushandira kune mushandi wekutanga.

1. Dzvanya pane cell G2 - iyi ndiyo iyo migumisiro yebasa icharatidzwa
2. Dzvanya paMafomu yebhu yebhoni yebhoni
3. Sarudza Kuona uye Kutarisa kubva kubhoni kuti uzarure basa rinoderera pasi
4. Dzvanya pa CHOOSE mune urongwa kuti ubudise bhokisi rebasa rebasa.
5. Mubhokisi rebhokisi, tora pane Index_numurongo
6. Dzvanya pane cell E2 mubasa rekushandisa kuti uise seferensi yesero mubhokisi rebhokisi
7. Dzvanya paIndaneti1 mutsara mubhokisi rebhokisi
8. Pinda 3% pamutsara uyu
9. Dzvanya paIndaneti2 mutsara mubhokisi rebhokisi
10. Pinda 5% pamutsara uyu
11. Dzvanya paIn Value3 mutsara mubhokisi rebhokisi
12. Pinda 7% pamutsara uyu
13. Dzvanya paIndaneti4 mutsara mubhokisi rebhokisi
14. Pinda 10% pamutsara uyu
15. Dzvanya OK kuti upedze basa uye uvhare bhokisi rebhokisi
16. Ikoshi "0.07" inofanira kuonekwa muchitokisi G2 iyo ndiyo yepamusoro ye 7%

02 of 02

SARUDZA Basa Rakaitwa (rakapfuurira)

Kuverenga Bhizimusi Bhizimusi

Ichi chikamu chekudzidzisa chinoshandura CHOOSE basa muchikamu cheG2 nekuwedzera zvibereko zvebasa nguva yemushandi wegore rega wega wekuverenga mabhesi ake gore negore.

Izvi zvinoshandiswa kuburikidza kushandisa F2 key yekugadzira fomu.

1. Dzvanya pachitokisi G2, kana zvichidiwa, kuti uite sero rinoshanda
2. Chenjerera F2 key pane keyboard kuti uise Excel mu edit mode - basa rakakwana
   = CHOOSE (E2, 3%, 5%, 7%, 10%) inofanira kuonekwa muchitokisi pamwe nekuisa pfungwa iko mushure mekuvhara kwebasa
3. Tora asterisk ( * ), iyo iyo chiratidzo chokuwedzera mu Excel, mushure mekuvhara bhokoni
4. Dzvanya pane seferi F2 mune pepa rekushandisa kuti uise sero rinoreva kumushandi wegore rega rega muyamu
5. Dhinda pikicha inopinda mubhobhoyo kuti upedze fomu uye usiye edit mode
6. Kukosha "$ 3,500.00" kunofanira kuonekwa muchitokisi G2, iyo inenge 7 muzana yemushandi wegore wega we $ 50,000.00
7. Dzvanyira pane cell G2, yakakwana formula = CHOOSE (E2, 3%, 5%, 7%, 10%) * F2 inowanikwa mubha yemufananidzo iri pamusoro pebasa

Kukopa Mubhizimisi WemaBhonasi Formula neFill Handle

Ichi chikamu chekudzidzisa chinopihwa muchechi G2 kumasero G3 kusvika kuG5 uchishandisa chizadzikiso .

1. Dzvanya pane sejeri G2 kuti uite sero rinoshanda
2. Isa iyo pointer yeguru pamusoro pekona musha pane imwe nechezasi kwekona yegeri G2. Iyo pointer ichashandura kune imwe chiratidzo "+"
3. Dzvanya kumusana webhenekeri mutsara uye wedhonzai kuzadza tsvimbo pasi kumusero G5
4. Bvisa mutsara. Mitsara G3 kuG5 inofanira kuva nemabhonasi mafananidzo evashandi vasara sezvinoonekwa mumufananidzo uri papeji 1 yeyikudzidzisa