Yuav Paub
- Siv no syntax:=CONVERT(Number, From_Unit, To_Unit)
- Number yog tus nqi koj xav hloov; From_Unit yog chav rau tus lej; To_Unit yog chav rau qhov tshwm sim.
Kab lus no piav qhia yuav ua li cas siv CONVERT muaj nuj nqi los hloov ib tus nqi rau nws qhov sib npaug hauv lwm chav ntsuas.
CONVERT Function Syntax
Cov hauv qab no yog cov syntax rau CONVERT muaj nuj nqi:
=CONVERT(Number, From_Unit, To_Unit)
- The function is =CONVERT.
- Number yog tus nqi koj xav hloov. Nws tuaj yeem yog tus lej tuav hauv tib lub xovtooj raws li cov qauv lossis ib qho hais hauv lwm lub xovtooj.
- From_Unit yog chav rau tus lej.
- To_Unit yog chav rau qhov tshwm sim.
Excel xav tau cov ntawv luv, lossis cov ntawv luv, rau ntau qhov ntsuas hauv From_Unit thiab To_Unit sib cav. Piv txwv li, "hauv"yog siv rau ntiv tes, "m" rau metres, "sec" rau qhov thib ob, thiab lwm yam. Muaj ntau ntau yam piv txwv nyob hauv qab ntawm nplooj ntawv no.
CONVERT Function Piv txwv
Cov lus qhia no tsis suav nrog cov kauj ruam formatting rau daim ntawv ua haujlwm zoo li koj pom hauv peb daim duab piv txwv. Thaum qhov no yuav tsis cuam tshuam nrog kev ua tiav cov lus qhia, koj daim ntawv ua haujlwm yuav zoo li txawv dua li qhov piv txwv qhia ntawm no, tab sis CONVERT muaj nuj nqi yuav muab rau koj tib yam.
Hauv qhov piv txwv no, peb yuav saib yuav ua li cas hloov qhov ntsuas ntawm 3.4 meters mus rau qhov sib npaug hauv ko taw.
- Tau cov ntaub ntawv rau hauv hlwb C1 rau D4 ntawm Excel daim ntawv ua haujlwm raws li pom hauv daim duab saum toj no.
- Xaiv tes E4, uas yog qhov uas cov txiaj ntsig ntawm kev ua haujlwm yuav tshwm sim.
- mus rau Formula ntawv qhia thiab xaiv Ntau Txoj Haujlwm > Engineering.
- Xaiv CONVERT los ntawm cov ntawv qhia zaub mov.
- Nyob hauv lub dialog box, xaiv lub thawv ntawv nyob ib sab ntawm kab "Tus lej", thiab tom qab ntawd nyem rau ntawm lub xovtooj E3hauv daim ntawv ua haujlwm kom nkag mus rau lub xovtooj siv rau hauv lub thawv..
- Rov qab mus rau lub dialog box thiab xaiv lub From_unit ntawv lub thawv.
- Xaiv tes D3 hauv daim ntawv ua haujlwm kom nkag mus rau qhov siv ntawm tes.
- Rov qab rau hauv tib lub dialog box, nrhiav thiab xaiv lub thawv ntawv nyob ib sab ntawm To_unit thiab mam li xaiv cell D4 hauv daim ntawv ua haujlwm rau nkag mus rau qhov siv ntawm tes.
- Click OK.
Cov lus teb 11.15485564 yuav tsum tshwm sim hauv cell E4.
Thaum koj nyem rau ntawm tes E4, ua tiav txoj haujlwm =CONVERT(E3, D3, D4) tshwm hauv cov qauv bar saum daim ntawv ua haujlwm.
Txhawm rau hloov lwm qhov kev ncua deb ntawm meters mus rau taw, hloov tus nqi hauv cell E3. Txhawm rau hloov cov txiaj ntsig siv cov chav sib txawv, nkag mus rau daim ntawv luv ntawm cov units hauv hlwb D3 thiab D4 thiab tus nqi koj xav hloov hauv cell E3.
Koj tuaj yeem txo tus lej lej ntawm qhov chaw tso tawm hauv xovtooj E4 kom nws yooj yim rau kev nyeem siv Txuag Decimal kev xaiv muaj nyob rau ntawm Home > Tus lej ntu ntu.
Lwm txoj kev rau cov lej ntev li no yog siv ROUNDUP muaj nuj nqi.
Daim Ntawv Teev Npe ntawm Excel's CONVERT Cov Haujlwm Ntsuas Ntsuas thiab Lawv Cov Ntawv luv
Siv cov ntawv luv luv hauv qab no ua From_unit lossis To_unit sib cav rau txoj haujlwm.
Koj tuaj yeem ntaus cov ntawv luv luv ncaj qha rau hauv kab tsim nyog hauv lub thawv sib tham, lossis siv xovtooj ntawm qhov chaw ntawm daim ntawv luv luv hauv daim ntawv ua haujlwm.
sijhawm
Xyoo - "yr"
Day - "hnub"
Hour - "hr"
Minute - "mn"
Second - "sec"
Kub
Degree (Celsius) - "C" lossis "cel"
Degree (Fahrenheit) - "F" lossis "fah"
Degree (Kelvin) - "K" lossis "kel"
Kev deb
Meter - "m"
Mile (txoj cai) - "mi"
Mile (nautical) - "Nmi"
Mile (US daim ntawv ntsuam xyuas txoj cai mais) - " survey_mi"
Inch - "in"
Foot - "ft"
Yard - "yd"
Light-year - "ly"
Parsec - "pc" or "parsec"
Angstrom - "ang"
Pica - "pica"
ntsuas kua
Liter - "l" lossis "lt"
Teaspoon - "tsp"
Tablespoon - "tbs"
Fluid ounce - "oz"
khob - "khob"
Pint (U. S.) - "pt" or "us_pt"
Pint (U. K.) - "uk_pt"
Quart - "qt"
Gallon - "gal"
Nyhav thiab Mass
Gram - "g"
Pound mass (avoirdupois) - "lbm"
Ounce mass (avoirdupois) - "ozm"
Hundredweight (US) - "cwt "los yog "shweight"
Hundredweight (imperial) - "uk_cwt" lossis "lcwt"
U (atomic mass unit) - "u"
Ton (imperial) - "uk_ton" los yog "LTON"
Slug - "sg"
siab
Pascal - "Pa" lossis "p"
Atmosphere - "atm" lossis "at"
mm ntawm Mercury - "mmHg"
Kev
Newton - "N"
Dyne - "dyn" lossis "dy"
Pound force - "lbf"
Power
Horsepower - "h" or "HP"
Pferdestärke - "PS"
Watt - "w" or "W"
Nyiaj
Joule - "J"
Erg - "e"
calorie (thermodynamic) - "c"
calorie (IT) - "cal"
Electron volt - "ev" lossis "eV"
Horsepower-teev - "hh" lossis "HPh"
Watt-teev - "wh" lossis "Wh"
foot- pound - "flb"
BTU - "btu" or "BTU"
Magnetism
Tesla - "T"
Gauss - "ga"
Tsis yog txhua qhov kev xaiv muaj nyob ntawm no. Yog hais tias chav tsev tsis tas yuav tsum tau sau luv, nws tsis pom nyob rau nplooj ntawv no.
