Isticmaalidda Qaab-dhismeedka CONVERT ee Foomamka Excel
Qalabka CONVERT waxaa loo isticmaalaa in lagu beddelo cabbirada hal cutub oo ka mid ah cutubyada ilaa Excel.
Tusaale ahaan, adeegga CONVERT waxaa loo isticmaali karaa in lagu beddelo heerarka Celsius ilaa heerka Fahrenheit, saacado ilaa daqiiqado, ama mitir cagaha.
Qaabdhismeedka Qalabka CONVERT
Tani waa ereyga loogu talagalay hawlaha CONVERT:
= CONVERT ( Lambar , From_Unit , To_Unit )- = CONVERT : Tani waa ficilka, markaa waa in aan marnaba la beddelin marka loo beddelayo qiimaha.
- Tirada: Qiimaha lagu beddeli karo. Waxay noqon kartaa lambar ku jira isla unugga qaabka loo yaqaan 'formula' ama midka kale ee loo yaqaan 'cell'.
- From_Unit : Heerka lambarka Tirada qiyaasta iminka ee hadda jira, qiimaha.
- To_Unit : Heerka qaybta qiyaasta ee Tirada ayaa loo rogi doonaa, lagu soo dirayo.
Marka aad dooranayso unugyada bedelka, waa qaababka gaaban ee loo soo gaabiyo as_Unit iyo To_Unit doodaha shaqada. Tusaale ahaan, "gudaha" waxaa loo isticmaalaa inji, "m" mitir, "sec" labaad, iwm. Waxaa jira dhawr tusaale oo kale oo ku yaal bogga hoose.
Hawlgalka CONVERT Tusaale
Fiiro gaar ah: Tilmaamahan kuma jiraan qaabka qaabaynta qaabka waraaqaha sida aad u aragto muuqaalka sawirka. Inkastoo tani aysan faragalin doonin dhamaystirka tababarka, waraaqahaaga shaqada ayaa laga yaabaa inay ka duwan yihiin tusaalaha tusaya halkan, laakiin hawlaha CONVERT ayaa ku siin doona natiijooyin isku mid ah.
Tusaale ahaan, waxaan eegi doonaa sida loo bedelayo qiyaastii 3.4 mitir u dhiganta fogaanta u dhiganta cagaha.
- Ku qor xogta unugyada C1 ilaa D4 ee warqad shaqo ee Excel sida lagu arkay sawirka kore.
- Xulo unugga E4. Tani waa meesha natiijooyinka hawlgalka la soo bandhigi doono.
- Tag liiska Moodelka oo dooro Farsamooyin Kala Duwan> Isku-dubarid , ka dibna dooro CONVERT macaamil -hoosaadkan.
- Ku qor sanduuqka , xulo sanduuqa qoraalka ah ee ku xiga xariijinta "Number", ka dibna ku dheji E3 qolka warqada si aad u gashid tixraaca unugga ee sanduuqa wada-hadalka.
- U laabo sanduuqa wada-hadalada oo dooro sanduuqa "From_unit", ka dibna dooro unugga D3 ee waraaqda shaqada si aad u gashid tixraaca unugga.
- Ku soo celi galka wadahadal isku mid ah, raadso sanduuqa qoraalka ah ee ku xiga "To_unit" kadibna dooro unugga D4 ee waraaqda shaqada si aad u gashid tixraaca unugga.
- Guji OK .
- Jawaabta 11.15485564 waa in ay ka muuqdaan unugyada E4.
- Markaad gujiso unugyada E4, hawsha dhammaystiran = CONVERT (E3, D3, D4) waxay ku muuqdaan miiska qaabka kore ee warqadda shaqada.
- Si aad u bedesho masaafooyinka kale ee mitir iyo cagaha, iska beddel qiimaha E3. Si aad u badasho qiimaha adoo isticmaalaya unugyo kala duwan, geli gaabnaanta unugyada unugyada D3 iyo D4 iyo qiimaha lagu bedeli karo unug E3.
Si aad u sahlanaato inaad akhriso jawaabta, tirada jajab tobanle ah ee lagu soo bandhigay unugyada E4 waxaa lagu yareyn karaa adigoo isticmaalaya xulashada Decrease Decimal oo laga heli karo qaybta " Home> Number ".
Doorasho kale oo tirooyin dheer sida sidan ah waa inaad isticmaashid hawlgalka ROUNDUP .
Liiska Faahfaahinta Qaybaha Qiyaasaha Qaabdhismeedka Qalabka ee CONVERT ee Excel iyo Laabashadooda
Waxyaalahaas gaaban ayaa loo soo gaabiyaa 'From_unit' ama ' To_unit' doodda hawsha.
Gaabisyada waxaa si toos ah loogu qori karaa xariiqda ku habboon sanduuqa wada-hadalka , ama tixraaca unugga ee meesha ku yaalla meesha gaaban ee waraaqaha shaqada ayaa la isticmaali karaa.
Waqti
Sanadka - "sanad" Maalinta - "maalinta" Saacad - "saac" daqiiqo - "mn" labaad - "sec"Heerkulka
Darajo (Celsius) - "C" ama "cel" Degree (Fahrenheit) - "F" ama "fah" Darajada (Kelvin) - "K" ama "kel"Masaafada
Meter - "M" Mile (qaynuunka) - "mi" Mile (nautical) - "Nmi" Mile (mile mareegaha Mareykanka) - "survey_mi" Inch - "in" Foot "ft" Yard - "yd" - "Ly" Parsec - "pc" ama "parsec" Angstrom - "ang" Pica - "pica"Cabirka Liquida
"L" ama "lt" Teaspoon - "tsp" Tablespoon - "Tbs" Soodhadhka "Oz" Cup - "Koob" Pint (US) - "pt" ama "us_pt" Pint (UK) - "uk_pt" Quart - "qt" Gallon - "gal"Miisaanka iyo Mass
Gram - "g" mass-pound mass (avoirdupois) - "lbm" mass ounce (avoirdupois) - "osm" Boqolaal (US) - "cwt" ama "shweight" Boqolaal (imperial) - "uk_cwt" ama "lcwt" U (atomic qaybta weyn) - "u" Ton (imperial) - "uk_ton" ama "LTON" Slug - "sg"Cadaadis
Pascal - "Pa" ama "p" Atmosfeer - "atm" ama "at" mm ee Mercury - "mmHg"Ciid
Newton - "N" Dyne - "dyn" ama "dy" xoogga sigaarka - "lbf"Awooda
Horsepower - "h" ama "HP" Pferdestärke - "PS" Watt - "w" ama "W"Tamarta
Joule - "J" Erg - "e" Calorie (thermodynamic) - "c" Calorie (IT) - "qalab" "Elektro" - "guri" ama "eV" koronto-saac - "hh" ama "HPh" Watt-saac - "wh" ama "Wh" Foot-pound - "flb" BTU - "btu" ama "BTU"Magnetism
Tesla - "T" Gauss - "ga"Fiiro gaar ah: Dhamaan ikhtiyaarrada ma ku qoran halkan. Haddii cutubku uusan u baahnayn in la soo gaabiyo, laguma soo bandhigin boggan.
Qeybta Maqnaanshaha Cutubyada
Halbeegyada mitirka, isbeddelka kaliya ee magaca unugga waa uu hoos u dhacayaa ama kor u kici karaa cabbirka waa horey loogu isticmaalay magaca hore, sida mitirka mitir ee 0.1 mitir ama kilo mitir 1,000 mitir.
Marka la eego tan, hoos ku qoran waa liis ay ku qoran yihiin hal qore oo waraaqo ah oo horay loo sii marin karo gaabnaanta mitirka kor ku xusan si loo beddelo cutubyada loo isticmaalo midka laga soo xigto From_unit ama To_unit .
Tusaale ahaan:
- Meelaha, si aad u badasho mile ilaa kiilo halkii mitir, isticmaal km halkii m
- Miisaanka, si aad ugu beddesho wiqiyadaha milligaraam halkii aad ka qaadan lahayd garaam, isticmaal mg halkii g
Qaar ka mid ah horgalayaasha waa in lagu soo galo:
Prefix - "E" peta - "P" tera - "T" giga - "M" Mega - "M" kilo - "h" hecto - "h" dekao - "e" deci - "d" centi - "C" M "Mic" - "N" Nano - "n" pico - "p" femto - "f" atto - "a"