Siv lub CONVERT Function hauv Excel qauv
Txoj kev ua CONVERT siv los hloov cov kev ntsuam xyuas los ntawm ib pawg ntawm cov pawg rau lwm tus hauv Excel.
Piv txwv, CONVERT kev ua haujlwm yuav siv tau los hloov cov degrees Celsius mus rau theem Fahrenheit, cov xuab moos mus rau feeb, lossis cov meters rau cov taw.
CONVERT Function Syntax
Qhov no yog lub syntax rau txoj kev ua CONVERT:
= TUS NEEG ( Naj npawb , From_Unit , To_Unit )- = CONVERT : Qhov no yog qhov ua haujlwm, yog li nws yuav tsum tsis txhob hloov thaum hloov tus txiaj ntsig.
- Piv txwv: Tus nqi yuav hloov dua siab tshiab. Yuav yog ib tus lej muaj nyob rau hauv tib lub cell raws li tus qauv los yog ib qho tau hais hauv lwm lub xov tooj.
- From_Unit : Tus qauv ntawm cov leb ntsuas tam sim no, cov lus hais.
- To_Unit : Qhov luv ntawm chav ntsuas kev uas tus lej yuav hloov dua siab tshiab rau, cov lus hais.
Thaum xaiv cov units rau kev hloov dua siab tshiab, nws yog lub luvforms uas tau muab ntaus tawm raws li From_Unit thiab To_Unit lus rau txoj haujlwm. Piv txwv, "hauv" yog siv rau nti, "m" rau cov meters, "sec" rau ob, thiab lwm yam. Muaj ntau ntau cov piv txwv nyob hauv qab ntawm nplooj ntawv no.
CONVERT Function Piv txwv
Lus Cim: Cov lus qhia no tsis yog muab tso tawm cov kauj ruam rau daim ntawv ua haujlwm xws li koj pom hauv peb tus qauv duab. Thaum lub sij hawm no yuav tsis cuam tshuam nrog kev ua kom tiav cov ntawv nyeem, koj daim ntawv ua haujlwm yuav zaum txawv dua li tus piv txwv ntawm no, tab sis CONVERT ua haujlwm yuav muab rau koj tib yam kev tshwm sim.
Hauv qhov ua piv txwv no, peb yuav pom tias yuav ua li cas hloov ib qho kev ntsuas ntawm 3.4 meters mus rau ib qho sib txawv deb ntawm taw.
- Sau cov ntaub ntawv rau hauv hlwb C1 rau D4 ntawm tsab ntawv khom nqi Excel raws li pom hauv daim duab saum toj no.
- Xaiv ntawm E4. Qhov no yog qhov twg qhov kev tshwm sim ntawm qhov kev ua hauj lwm yuav raug muab tso tawm.
- Mus rau ntawm cov qauv ntawv qhia zaub mov thiab xaiv Ntau Cov Haujlwm> Engineering , thiab tom qab ntawd ces xaiv CONVERT los ntawm lub tshuab raj tshuaj ntsuam.
- Nyob rau hauv lub thawv ntawv , xaiv lub thawv ntawv ntawm kab lus "Number", thiab tom qab ntawd ces nias rau ntawm E3 nyob rau hauv daim ntawv ua haujlwm sau cov xov tooj ntawm tes mus rau hauv lub thawv.
- Rov qab mus rau ntawm lub thawv ntawv thiab xaiv "From_unit" lub thawv ntawv, thiab tom qab ntawd ces xaiv D3 hauv daim ntawv ua haujlwm sau cov xov tooj ntawm tes.
- Rov qab rau tib lub thawv ntawv, nrhiav thiab xaiv lub thawv ntawv ntawm "To_unit" thiab ces xaiv cell D4 nyob rau hauv daim ntawv ua haujlwm kom nkag rau tus xov tooj ntawm tes.
- Nyem OK .
- Cov lus teb 11.15485564 yuav tsum tshwm nyob hauv cell E4.
- Thaum koj nias ntawm tes E4, txoj kev ua tiav = CONVERT (E3, D3, D4) tshwm nyob rau ntawm qhov formula formula saum toj ntawv sau.
- Los hloov lwm txoj kev los ntawm kev ntsuas mus rau kauj ruam, hloov tus nqi ntawm E3. Los hloov qhov tseem ceeb uas siv cov chav sib txawv, nkag mus rau hauv cov chav nyob hauv hlwb D3 thiab D4 thiab tus nqi hloov dua siab tshiab ntawm E3.
Ua kom yooj yim nyeem cov lus teb, cov zauv ntawm cov zauv ntawm E4 tuaj yeem raug txo kom tsawg dua los ntawm kev siv Decrease Decimal xaiv nyob rau ntawm Home> Number menu.
Lwm qhov kev xaiv rau cov lej ntev li qhov no yog siv cov kev ua haujlwm ROUNDUP .
Daim ntawv teev cov Excel CONVERT Function Measurement Cim thiab Lawv Cov Shortforms
Cov shortforms no yog nkag los ntawm As_unit lossis To_unit sib cav rau txoj haujlwm.
Tus luv luv yuav muab ntaus ncaj qha mus rau hauv kab uas tsim nyog hauv lub thawv txuas , los yog lub xov tooj ntawm tes rau qhov chaw nyob ntawm daim ntawv ua haujlwm tau siv.
Lub sijhawm
Xyoo - "xyoo" Hnub - "hnub" Teev - "hr" feeb - "mn" Second - "sec"Kub
Degree (Celsius) - "C" los sis "cel" Degree (Fahrenheit) - "F" los sis "fah" Degree (Kelvin) - "K" los yog "kel"Nrug
"M" Mais (txoj cai) - "mi" Mais (nautical) - "Nmi" Mais (Tebchaws Asmeskas kev tshawb fawb txoj cai mais) - "survey_mi" Inch - "in" Foot - "ft" Yard - "yd" - "ly" Parsec - "pc" los yog "parsec" Angstrom - "ang" Pica - "pica"Kev Ntsuas Ua Ntej
"L" los sis "lt" Teaspoon - "tsp" Tablespoon - "tbs" Fluid ounce - "oz" khob - "khob" Pint (US) - "pt" los sis "us_pt" Pint (UK) - "uk_pt" Quart - "qt" Gallon - "gal"Nyuj thiab pawg
Gram - "g" Pound mass (avoirdupois) - "lbm" Ounce pawg (avoirdupois) - "osm" Pej (US) - "cwt" lossis "shweight" Pejxeem (imperial) - "uk_cwt" lossis "lcwt" U (atomic chav tsev) - "u" Tug (imperial) - "uk_ton" los sis "LTON" Slug - "sg"Siab
Pascal - "Pa" los sis "p" cua - "atm" lossis "ntawm" lub hli ntawm Mercury - "mmHg"Force
Newton - "N" Dyne - "dyn" lossis "dy" Pound force - "lbf"Lub zog
Horsepower - "h" los sis "HP" Pferdestärke - "PS" Watt - "w" lossis "W"Zog
Calorie (thermodynamic) - "c" Calorie (IT) - "Cal" Electron hluav taws xob - "tsev" los sis "eV" Horsepower-teev - "hh" los sis "HPh" Watt-teev - "wh" lossis "Wh" Foot-pound - "flb" BTU - "btu" lossis "BTU"Magnetism
Tesla - "T" Gauss - "ga"Lus Cim: Tsis yog txhua txoj hauv kev xaiv tau teev nyob ntawm no. Yog tias chav tsev tsis tas yuav muab sau, nws tsis muaj nyob hauv nplooj ntawv no.
Metric Unit Shortforms
Rau cov xaim metric, tsuas yog hloov mus rau ib chav tsev lub npe raws li nws txo lossis nce nyob rau hauv loj yog lub prefix siv nyob rau hauv pem hauv ntej ntawm lub npe, xws li centi meter rau 0.1 meters los yog kilo meter rau 1,000 meters.
Muab qhov no, hauv qab no yog ib daim ntawv teev cov tsiaj ntawv ua ntej uas tuaj yeem muab tso rau hauv pem hauv ntej ntawm txhua lub tsev metric shortform saum toj no los hloov cov kev siv los ntawm In_unit lossis To_unit cov lus.
Piv txwv:
- Rau ncua kev, hloov cov mais mus rau pes tsawg meters, siv km tsis m
- Rau qhov hnyav, hloov cov ooj rau milligrams es tsis txhob siv cov grams, siv mg tsis yog g
Ib txhia ntawm cov lus siv ua ntej yuav tsum muab nkag rau hauv uppercase:
Ua ntej tshaj plaws - Ncauj ncua kev ua si - "E" peta - "P" tera - "T" giga - "G" mega - "M" kilo - "k" hecto - "h" dekao - "e" deci - "d" "c" lub cev - "m" micro - "u" nano - "n" pico - "p" femto - "f" atto - "a"