Shaqada DOORASHADA^(CHOOSE) ee Microsoft Excel waa Raadinta iyo Tixraaca^{(Lookup and Reference)} shaqada, ujeeddadeeduna waa in laga doorto qiimaha liiska qiyamka. DOORASHADA^(CHOOSE) qaacidada shaqadu waa CHOOSE(index_num, value 1, [value 2]..).

• Index_num : Qiimaha la dooranayo, tan ayaa loo baahan yahay.
• Qiimaha 1^(Value1) : Qiimaha ugu horreeya ee la doorto. Waa loo baahan yahay.
• Qiimaha 2^{(Value 2)} : qiimaha labaad ee la doorto. Waa ikhtiyaari.

Sida loo isticmaalo shaqada COOSE^(CHOOSE) ee Excel

Fur Microsoft Excel .

Miis samee ama fur miis jira.

Tababarkan, waxaan ku haynaa miiska dhirta; Waxaan rabnaa inaan helno qiimaha lambarka saddexaad.

Gudaha qolka aad rabto inaad natiijada dhigto, geli:

=CHOOSE(3, "Tree," "Cactus," "Bulbs")

Tirada saddex waa Index_num iyo booska geedka.

Geedka, Cactus, iyo nalalka waa qiyamka^(Values) .

Dabadeed taabo Gelida^(Enter) Keyboard-ka.

Waxaad arki doontaa natiijada.

Waxa jira laba hab oo kale oo loo isticmaalo DOORASHADA^(CHOOSE) shaqada.

Habka koowaad waa inaad gujiso badhanka fx ee korka warqadda shaqada.

Sanduuqa wada hadalka Doorka Function^{(Select Function)} ayaa soo bixi doona.

Sanduuqa wada -hadalka ee Select a Function , guji falaarta hoos-u-dhaca oo dooro Raadinta iyo Tixraaca^{(Lookup and Reference)} qaybta Dooro Qaybta^{(Select a Category)} .

Xulo^(Select) liiska shaqada^(Function) , ka dooro liiska^(CHOOSE) .

Markaa OK .

Sanduuqa wada hadalka doodaha Function^{(Function Arguments)} ayaa soo bixi doona.

Qaybta Index_num , geli lambarka Saddexaad^(Three) ee sanduuqa gelitaanka.

Qaybta Qiimaha ^(Value) Hal^(one) , Geli Geedka^(Tree) sanduuqa gelitaanka.

Qiimaha labaad^{(Value two)} , geli Cactus sanduuqa soo gelista.

Qiimaha saddexaad^{(Value three)} ,  geli nalka^(Bulb) sanduuqa soo galinta.

Markaa OK .

Habka labaad waa in aad gujiso tab Formulas oo aad gujiso ^(Formulas)Lookup and Reference button in the Function Library group.

Liiska hoos-u-dhaca, dooro DOORASHADA^(CHOOSE) .

Sanduuqa wada hadalka doodaha Shaqada^{(Function Arguments)} ayaa furmi doona.

Raac habka koowaad si aad u aragto tillaabooyinka.

Kadib dhagsii OK .

Waxaan rajeyneynaa in casharkan uu kaa caawinayo inaad fahamto sida loo isticmaalo DOORASHADA^(CHOOSE) shaqada ee Excel ; haddii aad wax su'aalo ah ka qabto casharrada, noogu soo sheeg faallooyinka.

TALO^(TIP) : Boostada ayaa ku caawin doonta haddii ikhtiyaarrada Auto Buuxinta aysan ka muuqan Excel^{(Auto Fill options are not showing in Excel)} .

How to use the CHOOSE function in Excel

The CHOOSE function in Microsoft Excel is a Lookup and Reference function, and its purpose is to choose a value from a list of values. The CHOOSE function formula is CHOOSE(index_num, value 1, [value 2]..).

• Index_num:  The value to choose, this is required.
• Value1: The first value to choose. It is required.
• Value 2: the second value to choose. It is optional.

How to use the CHOOSE function in Excel

Open Microsoft Excel.

Create a table or open an existing table.

In this tutorial, we have a table of plants; we want to find which value is at number three.

In the cell where you want to place the result, enter:

=CHOOSE(3, "Tree," "Cactus," "Bulbs")

The number three is the Index_num and the position of the plant.

Tree, Cactus, and Bulbs are the Values.

Then press Enter on the Keyboard.

You will see the result.

There are two other methods of using the CHOOSE function.

Method one is to click the fx button on top of the worksheet.

A Select Function dialog box will pop up.

In the Select a Function dialog box, click the drop-down arrow and select Lookup and Reference in the Select a Category section.

In the Select a Function list, select CHOOSE from the list.

Then OK.

A Function Arguments dialog box will pop up.

In the Index_num section, enter the number Three into the entry box.

In the Value one section, enter Tree into the entry box.

In Value two, enter Cactus into the entry box.

In  Value three, enter Bulb into the entry box.

Then OK.

Method two is to click the Formulas tab and click the Lookup and Reference button in the Function Library group.

In the drop-down list, select CHOOSE.

A Function Arguments dialog box will open.

Follow method one to see the steps.

Then click OK.

We hope this tutorial helps you understand how to use the CHOOSE function in Excel; if you have questions about the tutorial, let us know in the comments.

TIP: This post will help you if the Auto Fill options are not showing in Excel.

Related posts

• Sida loo isticmaalo Percentile.Exc function gudaha Excel

• Sida loo isticmaalo shaqada NETWORKDAYS gudaha Excel

• Sida loo tiriyo lambarka Haa ama Maya ee Excel

• Excel, Word ama PowerPoint ma bilaabi karaan markii ugu dambeysay

• Sida loo isticmaalo sifada Nooca Xogta tooska ah ee Excel

• Sida looga soo saaro magacyada domain URL-yada Microsoft Excel

• Sida loo midoobo oo loo kala saaro unugyada Excel

• Sida loo daabaco unugyada la doortay ee Excel ama Google Sheets hal bog

• Sida loo qoro, loo dhiso, loona isticmaalo shaqada VLOOKUP gudaha Excel

• U beddelo CSV una beddelo Excel (XLS ama XLSX) adoo isticmaalaya khadka taliska ee Windows

• Sida loo abuuro Shaxda Radar gudaha Windows 11/10

• Sida loo beddelo qaabka faylka caadiga ah ee lagu kaydiyo Word, Excel, PowerPoint

• Sida loo bilaabo Word, Excel, PowerPoint, Outlook in Mode Safe

• Sida loo xidho unugyada qaacidada Excel si loo ilaaliyo

• Sida waqti loogu daro ama loogu daro Microsoft Excel

• Sidee loo xisaabiyaa korodhka ama hoos u dhaca boqolkiiba ee Excel?

• Sida loo qaybiyo hal tiir oo loo kala qaybiyo tiirar badan oo Excel ah

• Casharka Microsoft Excel, ee Bilowga ah

• Sida loo dayactiro buug-shaqeedka Excel ee xumaaday

• Sida loo isticmaalo shaqada DISC gudaha Excel