Kugwiritsa ntchito ntchito ya CONVERT mu Excel Formula
Ntchito ya CONVERT imagwiritsidwa ntchito kutembenuza miyeso kuchokera ku chigawo chimodzi cha mayunitsi kupita ku Excel.
Mwachitsanzo, ntchito ya CONVERT ikhoza kugwiritsidwa ntchito kusintha madigiri Celsius mpaka madigiri Fahrenheit, maola ndi mphindi, kapena mamita mpaka mapazi.
Ntchito ya CONVERT Ntchito Syntax
Ichi ndicho chiganizo cha ntchito ya CONVERT:
= CHIKHULUPIRIRO ( Nambala , Kuchokera_Kodi , Ku_kunena )- = CONVERT : Ichi ndi ntchito, kotero siziyenera kusinthidwa pamene mutembenuza miyezo.
- Nambala: Mtengo wotembenuzidwa. Kungakhale nambala yomwe imagwiritsidwa ntchito mu selo yomweyo monga chiganizo kapena chimodzi chomwe chimatchulidwa mu selo ina.
- Kuchokera pa_Kusintha : Kufupika kwa chiwerengero cha chiwerengero chamakono chamakono, mu ndemanga.
- Ku_Kosonyeza : Mphindi yochepa ya unit of measure yomwe Number idzatembenuzidwira, mu ndemanga.
Posankha maunitelo kuti mutembenuzike, ndizozolowera zomwe zimalowa monga zochokera ku_ku_ndipo ndi ku_kutsutsana kwa ntchitoyi. Mwachitsanzo, "mu" amagwiritsidwa ntchito pa inchi, "m" kwa mamita, "sekondi" kwachiwiri, ndi zina. Pali zitsanzo zingapo pansi pa tsamba ili.
Ntchito ya CONVERT Chitsanzo
Zindikirani: Malangizo awa samaphatikizapo kupanga mapangidwe a tsambali monga momwe mukuwonera mu chithunzi chathu. Ngakhale kuti izi sizidzasokoneza kumaliza maphunziro, tsamba lanu la ntchito likhoza kuwoneka mosiyana ndi chitsanzo chowonetsedwa apa, koma ntchito ya CONVERT idzakupatsani zotsatira zomwezo.
Mu chitsanzo ichi, tiyang'ana m'mene tingasinthire chiyero cha mamita 3.4 kufika mtunda wofanana ndi mapazi.
- Lowani deta mu maselo C1 mpaka D4 a pepala la Excel monga momwe taonera pa chithunzi pamwambapa.
- Sankhani selo E4. Izi ndi zomwe zotsatira za ntchitoyi zidzawonetsedwa.
- Pitani ku menyu yamafomu ndikusankha Ntchito Zambiri> Zomangamanga , ndiyeno sankhani CONVERT kuchokera kumtundu wotsikawu .
- Mu bokosi la bokosi , sankhani lembalo pafupi ndi mzere wa "Number", ndiyeno dinani pa selo E3 mu tsamba kuti mulowetse selolo mu bokosi la bokosi.
- Bwererani ku bokosi la bokosi ndikusankha "Kuchokera pa "_ndime" bokosi, ndipo kenako sankhani selo D3 mu tsamba kuti mupange selolo.
- Kubwereranso mu bokosi lomwelo, fufuzani ndi kusankha mndandanda wamkati pafupi ndi "To_unit" ndiyeno sankhani selo D4 mu tsamba kuti mupange selolo.
- Dinani OK .
- Yankho 11.15485564 liyenera kuoneka mu selo E4.
- Mukasinthana pa selo E4, ntchito yonse = CONVERT (E3, D3, D4) ikuwonekera pa bar barolomu pamwamba pa tsamba.
- Kuti mutembenuze mtunda wina kuchokera mamita mpaka mapazi, kusintha mtengo mu selo E3. Kuti mutembenuzire maluso pogwiritsa ntchito magulu osiyanasiyana, lowetsani mfupi mwa maselo mu maselo D3 ndi D4 ndi mtengo woti mutembenuzidwe mu selo E3.
Kuti chikhale chosavuta kuwerengera yankho, chiwerengero cha malo osungirako chiwonetsero chowonetsedwa mu selo E4 chikhoza kuchepetsedwa pogwiritsa ntchito Chotsitsa Chosankha chomwe chilipo > Chigawo cha menyu.
Njira ina yamakono ambiri monga awa ndi kugwiritsa ntchito ntchito ROUNDUP .
Mndandanda wa Zowonongeka Zogwira Ntchito za CONVERT ndi Zolemba Zake Zochepa
Zithunzi zochepazi zikulowetsedwa monga Kutoka_unit kapena To_unit kukangana kwa ntchitoyo.
Zithunzi zochepazi zimatha kufotokozedwa mwachindunji mu mzere woyenera mu bokosi la bokosi , kapena selo yeniyeni yowunikira pa malo ofotokozera mu tsamba lothandizira angagwiritsidwe ntchito.
Nthawi
Tsiku - "Tsiku" - Tsiku "Tsiku" - "Hr" Mphindi - "mn" Wachiwiri - "Mphindi"Kutentha
Degree (Celsius) - "C" kapena "cel" Degree (Fahrenheit) - "F" kapena "fah" Degree (Kelvin) - "K" kapena "kel"Kutalikirana
Miyendo ya Mile (Miley) - Mile Mile - Naimtical - "Nmi Mile Mile" ("US $") - "survey_mi" Inch - "mu" Foot - "ft" Yard - "yd" Kuwala kwa chaka - "ly" Parsec - "pc" kapena "parsec" Angstrom - "ang" Pica - "pica"Kuchuluka kwa Madzi
Liti - "l" kapena "lt" supuni - "tsp" Supuni - "tbs" Madzi otentha - "oz" Cup - "kapu" (US) - "pt" kapena "us_pt" Pint (UK) - "uk_pt" Zitatu - "qt" Gallon - "gal"Kulemera ndi Misa
Gramu - "g" Pound mass (aitdupois) - "lbm" Kulemera kwapakati (aitdupois) - "ozm" Mazana 100 (US) - "cwt" kapena "shweight" Mazana 100 (mfumu) - "uk_cwt" kapena "lcwt" U (atomiki masewera) - "u" Ton (mfumu) - "uk_ton" kapena "LTON" Slug - "sg"Kuthamanga
Pascal - "Pa" kapena "p" Atmosphere - "atm" kapena "pa" mm ya Mercury - "mmHg"Limbikitsani
Newton - "N" Dyne - "Dyn" kapena "Dy" mphamvu ya Pound - "lbf"Mphamvu
Mphamvu yamkono - "h" kapena "HP" Pferdestärke - "PS" Watt - "w" kapena "W"Mphamvu
"" Calorie (thermodynamic) - "c" Kalori (IT) - "cal" Electron volt - "ev" kapena "eV" Ora lachiwombankhanga - "hh" kapena "hh" la Watt-hour - "wh" kapena "Wh" Foot-pound - "flb" BTU - "btu" kapena "BTU"Magnetism
Tesla - "T" Gauss - "ga"Zindikirani: Sizinthu zonse zomwe zilipo pano. Ngati chigawocho sichiyenera kusindikizidwa, sichiwonetsedwa patsamba lino.
Metric Unit Shortforms
Kwa magulu a miyala, kusintha kokha ku dzina lagwirizano pamene kumachepa kapena kuwonjezeka kukula ndiko chiyambidwe chogwiritsiridwa ntchito kutsogolo kwa dzina, ngati mamita a centi kwa mamita 0.1 kapena kilo imodzi mamita 1,000.
Pachifukwa ichi, pansipa pali mndandanda wa zilembo zamakalata zomwe zingagwiritsidwe kutsogolo kwa chigawo chilichonse chachitsulo chophatikizidwa pamwambapa kuti asinthe mayunitsi omwe amagwiritsidwa ntchito kaya kuchokera ku_kuchokera ku_kunena kapena ku_kukambirana .
Zitsanzo:
- Kwa maulendo, kuti mutembenuzire mailosi kupita makilomita osati mamita, gwiritsani ntchito km m'malo m
- Kuti mukhale wolemera, kutembenuza maunyolo kukhala milligrams m'malo mwa magalamu, gwiritsani ntchito mg mmalo mwa g
Zina mwazomwezo ziyenera kulowa muzowonjezereka:
Choyambirira - Shortform exa - "E" peta - "P" tera - "T" giga - "G" mega - "M" kilo - "k" hecto - "h" dekao - "e" deci - "d" centi - "M" "micro" - "u" nano - "n" pico - "p" femto - "f" atto - "a"