Sida Loo Beddelayo Cabbiraadaha ee Excel

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 )

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

Ku bedel Cabbiraadaha Excel. © Ted Faransiis

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.

  1. Ku qor xogta unugyada C1 ilaa D4 ee warqad shaqo ee Excel sida lagu arkay sawirka kore.
  2. Xulo unugga E4. Tani waa meesha natiijooyinka hawlgalka la soo bandhigi doono.
  3. Tag liiska Moodelka oo dooro Farsamooyin Kala Duwan> Isku-dubarid , ka dibna dooro CONVERT macaamil -hoosaadkan.
  4. 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.
  5. U laabo sanduuqa wada-hadalada oo dooro sanduuqa "From_unit", ka dibna dooro unugga D3 ee waraaqda shaqada si aad u gashid tixraaca unugga.
  6. 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.
  7. Guji OK .
  8. Jawaabta 11.15485564 waa in ay ka muuqdaan unugyada E4.
  9. Markaad gujiso unugyada E4, hawsha dhammaystiran = CONVERT (E3, D3, D4) waxay ku muuqdaan miiska qaabka kore ee warqadda shaqada.
  10. 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:

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"