Shaqada TYPE waa shaqada macluumaadka ee Microsoft Excel , ujeeddadeeduna waa soo celinta lambar tilmaamaysa nooca xogta ee qiimaha. Isticmaaluhu ma isticmaali karo shaqada TYPE si uu u go'aamiyo in unugu ka kooban yahay qaacido sababtoo ah shaqada TYPE ayaa kaliya go'aamisa nooca qiimaha la soo bandhigay.

^{(Excel TYPE)}Qaabka shaqada TYPE ee Excel^(Formula) iyo Syntax

Foomamka shaqada TYPE^(Formula) waa TYPE (qiimaha)^{(TYPE(value))} .

Syntax ee shaqada TYPE waa hoos:

Qiimaha^(Value) : Qiimaha Microsoft Excel , tusaale ahaan, nambar, qoraal, qiimo macquul ah, iyo in ka badan. Waa loo baahan yahay. Shaqada TYPE waxa ay soo celisaa nambarada nambarada ee matala noocyada qiyamka, waxaana jira shan qaybood oo kala ah: Number = 1 ,  Text = 2 , Logical value = 4, Error value = 16 and  Array = 64.

Sida loo isticmaalo shaqada TYPE^{(TYPE Function)} ee Excel

Si aad u isticmaasho shaqada TYPE , raac hababka hoose.

1. Fur Excel
2. Samee miis ama isticmaal miiska jira
3. Ku qor qaacidada shaqada TYPE unugga aad rabto inaad natiijada dhigto.
4. Riix Gelida si aad u aragto natiijada

Bilaw Microsoft Excel .

Samee miis ama isticmaal miiska jira.

Ku qor shaqada =TYPE(A2) unugga aad rabto inaad natiijada dhigto.

Kadib riix furaha geli si aad u aragto natiijada.

A2 waxaa ku jira qiimaha aan rabno inaan helno xogta.

Natiijada A2 waxay soo celinaysaa koodka nambarka laba, taas oo macnaheedu yahay nooca waa Qoraal^(Text) .

Si aad u aragto natiijada kale ee miiska, hoos u soo jiid gacanta buuxinta.

Waxaa jira laba hab oo kale oo loo isticmaalo shaqada TYPE ee Excel .

Habka koowaad waa inaad gujiso badhanka fx ee bidix ee sare ee xaashida shaqada ee Excel.

Sanduuqa wada hadalka Gelida ayaa soo bixi doona^{(Insert Function)} .

Gudaha sanduuqa wada hadalka ee qaybta, Dooro Qaybta^{(Select a Category)} , ka dooro macluumaadka^{(Information)} sanduuqa liiska.

Qaybta Dooro Function^{(Select a Function)} , ka dooro shaqada TYPE liiska.

Kadib dhagsii OK .

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

Qaybta Qiimaha^{(Value )} , geli sanduuqa gelitaanka unugga   A2 .

Kadib guji OK si aad u aragto natiijada.

Habka labaad waa in la gujiyo Formulas tab oo guji badhanka Functions More ee kooxda ^{(More Functions )}Library Function^{(Function Library)} .

Liistada, ku dul-kor-meerka xogta^{(Information)} oo dooro nooca^{( Type )} Function.

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

Waxaan rajeyneynaa in casharkaan uu kaa caawiyo inaad fahamto sida loo isticmaalo shaqada TYPE ee Excel .

How to use the TYPE Function in Excel

The TYPE function is an information function in Microsoft Excel, and its purpose is to return a number indicating the data type of a value. The user cannot use the TYPE function to determine if the cell contains a formula because the TYPE function only determines the type of displayed value.

Excel TYPE function Formula and Syntax

The Formula for the TYPE function is TYPE(value).

The Syntax for the TYPE function is below:

Value: A Microsoft Excel value, for instance, number, text, logical value, and more. It is required. The TYPE function returns numeric codes that represent the types of values, and there are five categories, namely: Number = 1,  Text = 2, Logical value = 4, Error value = 16 and  Array = 64.

How to use the TYPE Function in Excel

To use the TYPE function, follow the methods below.

1. Launch Excel
2. Create a table or use an existing table
3. Type the formula for the TYPE function into the cell you want to place the result.
4. Press Enter to see the result

Launch Microsoft Excel.

Create a table or use an existing table.

Type the function =TYPE(A2) into the cell you want to place the result.

Then press the enter key to see the result.

A2 contains the value that we want to find the data.

The result for A2 returns the numeric code two, which means the type is Text.

To see the other result in the table, pull the fill handle down.

There are two other methods to use the TYPE function in Excel.

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

An Insert Function dialog box will appear.

Inside the dialog box in the section, Select a Category, select Information from the list box.

In the section Select a Function, choose the TYPE function from the list.

Then click OK.

A Function Arguments dialog box will open.

In the Value section, input into the entry box the cell  A2.

Then click OK to see the result.

Method two is to click the Formulas tab and click the More Functions button in the Function Library group.

In the list, hover the cursor over Information and select the Type Function.

A Function Arguments dialog box will appear.

We hope this tutorial helps you understand how to use the TYPE function in Excel.

Related posts

• Sida loo isticmaalo sifada Nooca Xogta tooska ah ee Excel

• Sida loo isticmaalo Muddada Dhaqaale Function gudaha Excel

• Sida loo isticmaalo Rept Function gudaha Excel

• Sida loo isticmaalo DCOUNT iyo DCOUNTA Function gudaha Excel

• Sida loo isticmaalo RANDBETWEEN Function gudaha Excel

• Sida loo geliyo shaxda firfircoon ee xaashida Excel

• Sida loo isticmaalo shaqada COOSE ee Excel

• Sida loo midoobo oo loo kala saaro unugyada Excel

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

• Sida loo isticmaalo shaqada HLOOKUP ee Microsoft Excel

• Microsoft Excel waxay isku dayaysaa inay soo ceshato macluumaadkaaga

• Sida loo isticmaalo shaqada ISODD ee Excel

• Sida loo qaboojiyo oo loo kala qaybiyo xaashida shaqada ee Excel

• Sida Loo Isticmaalo Shaqada PMT ee Excel

• Sida loo abuuro Shaxda Radar gudaha Windows 11/10

• Sida Loo Isticmaalo Shaqada YEARFRAC gudaha Excel

• Sida loo isticmaalo PMT Function gudaha Excel

• Casharka Microsoft Excel, ee Bilowga ah

• Sida loo isticmaalo INT iyo Functions LCM gudaha Excel

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