Sida loo isticmaalo shaqada TYPE ee Excel
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.
- Fur Excel
- Samee miis ama isticmaal miiska jira
- Ku qor qaacidada shaqada TYPE unugga aad rabto inaad natiijada dhigto.
- 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 .
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