Excel hloov pauv ua haujlwm ("= CONVERT ()") hloov pauv ntsuas los ntawm ib chav mus rau lwm qhov. Txhawm rau siv txoj haujlwm no, koj yuav nkag mus rau cov ntaub ntawv thiab chav nyob rau hauv tus lej: = Hloov (tus lej, "from_unit", "to_unit"). Ua ntej kawm paub yuav ua li cas nkag mus hloov pauv tus kheej lossis nrog Excel's Formula builder tom qab ntawd tshawb pom yuav ua li cas thov siv qhov kev hloov pauv ntawd rau tag nrho kab ntawm cov ntaub ntawv. Tsis txhob hnov qab tias cov npe hauv chav yog cov ntaub ntawv-rhiab!
Cov kauj ruam
Txoj Kev 1 ntawm 3: Nkag Mus Siv Hloov Ua Tus Kheej
Kauj Ruam 1. Sau kab ntawv A nrog rau chav tsev qub
Txog lub hom phiaj ntawm qhov piv txwv no, cia peb xav tias qhov ntsuas uas koj xav hloov pauv yog nyob hauv kab A thiab koj xav pom qhov hloov pauv tau tshwm sim hauv kab B (tab sis tiag tiag txoj kev no yuav ua haujlwm rau ob kab lus). Txhawm rau sau kab ntawv A, nyem rau ntawm cell A1 thiab ntaus hauv thawj chav (qhov koj xav tau hloov dua siab tshiab, piv txwv li ntiv tes, ntsuas, lossis mev). Qhov no tseem hu ua "from_unit."
- Piv txwv li: nyem rau ntawm cell A1 thiab ntaus “Inches”. Hauv qhov piv txwv no, peb yuav hloov 12 (tus lej) ntiv tes (from_unit) mus ko taw (to_unit).
- Excel qhov kev hloov pauv hloov pauv "los ntawm chav nyob," mus rau "rau ib chav" (chav uas koj tab tom hloov qhov ntsuas rau).
- Sau koj kab ntawv yuav pab koj npaj koj cov ntaub ntawv.
Kauj Ruam 2. Sau kab ntawv B
Nyem rau ntawm cell B1. Qhov no yuav yog koj "to_unit" kem. Ntaus hauv chav tsev koj tab tom hloov qhov ntsuas mus rau. Qhov no tseem hu ua "to_unit".
Piv txwv li: nyem rau ntawm cell B1 thiab ntaus "Feet"
Kauj Ruam 3. Sau koj qhov kev ntsuas thawj hauv cell A2
Ntaus thawj qhov ntsuas hauv tus lej nkaus xwb. Tsis txhob nkag mus rau hauv chav nyob.
Piv txwv li: hauv cell A2, sau “12” (zoo li hauv 12 ntiv tes)
Kauj Ruam 4. Ntaus “= Hloov (” hauv cell B2
Kev ua haujlwm hauv Excel tsis yog teeb meem loj. Ntaus "= CONVERT (" muaj qhov tshwm sim zoo ib yam li ntaus "= hloov ("
Kauj Ruam 5. Sau lub npe ntawm tes uas muaj qhov ntsuas thawj
Excel hloov pauv ua haujlwm hu tus nqi no "tus lej".
- Piv txwv li: "= Hloov (A2"
- Thaum koj tab tom hloov pauv ib qho kev ntsuas, zoo li hauv qhov piv txwv saum toj no, Nws kuj tseem tuaj yeem ntaus tus lej tiag (tsis yog siv xovtooj ntawm tes) hauv qhov chaw no. Hloov chaw "= Hloov (A2", koj yuav nkag mus "= Npog (12".
Kauj Ruam 6. Ntxiv tus lej
Piv txwv li, koj lub xov tooj tam sim no yuav zoo li no: "= Hloov (A2," lossis "= Hloov (12,")
Kauj Ruam 7. Nkag mus rau hauv “from_unit
"Tam sim no nkag mus rau hauv daim ntawv luv luv pom zoo ntawm thawj chav. Qhov "from_unit" tau nyob ib puag ncig los ntawm kab lus hais thiab ua raws los ntawm tus lej cim.
- Piv txwv li: "= Hloov (A2," hauv "," lossis "= Hloov (12," hauv ",".
- Qee qhov kev pom zoo ntawm cov ntawv luv yog "hauv" "cm" "ft" thiab "m".
- Excel muab cov npe tag nrho ntawm cov ntawv luv ntawm chav nyob ntawm no.
Kauj Ruam 8. Nkag mus rau hauv “to_unit
"Tam sim no nkag mus rau hauv cov ntawv luv pom zoo rau" to_unit. " Qhov "to_unit" tau muab los ntawm cov lus hais los ua ke los ntawm kab lus kaw.
- Piv txwv li, koj lub xov tooj yuav tsum zoo li: “= Hloov (A2,“in”,“ft”)” lossis “= Hloov (12,“hauv”,“ft”)”.
- Qhov ua piv txwv no yuav hloov cov ntsiab lus ntawm cell A2 los ntawm ntiv tes mus rau taw.
Kauj Ruam 9. Ntaus ↵ Enter kom ua tiav txoj haujlwm
Kev ntsuas hloov pauv yuav tshwm hauv koj lub cell (qhov no, cell B2).
- Piv txwv li: B2 yuav muaj “1” (zoo li hauv 1 ko taw).
- Yog tias qhov ua haujlwm rov qab "#N/A" yuam kev, txheeb xyuas chav ntawv luv dua. Xyuas kom tseeb tias cov ntawv luv yog qhov raug thiab tias ob chav nyob hauv tib pab pawg (piv txwv tias nws tsis tuaj yeem hloov pauv loj mus rau qhov ntev). Thov nco ntsoov, cov npe tsev thiab cov ntawv ua ntej yog cov ntaub ntawv nkag siab.
- Yog tias muaj nuj nqi rov qab "#VALUE!" yuam kev, qhov no txhais tau tias koj tau nkag mus rau "tus lej" tsis raug. Xyuas kom tseeb tias koj tsuas yog nkag rau ib tus lej lossis siv xov tooj ntawm tes.
Txoj Kev 2 ntawm 3: Nkag Mus Hloov Ua Haujlwm nrog Formula Builder
Kauj Ruam 1. Sau kab ntawv A
Txog lub hom phiaj ntawm qhov piv txwv no, cia peb xav tias qhov ntsuas koj xav hloov pauv yog nyob hauv kab A thiab koj xav pom qhov hloov pauv tau tshwm sim hauv kab B (tab sis qhov tseeb, txoj hauv kev no yuav ua haujlwm rau ob kab lus). Nyem rau ntawm cell A1 thiab ntaus hauv thawj chav (qhov koj xav hloov dua siab tshiab, piv txwv li vib nas this, teev, lossis hnub). Qhov no tseem hu ua "from_unit."
- Piv txwv li: ntaus “feeb” rau hauv cell A1. Hauv qhov piv txwv no, peb yuav hloov 21 (tus lej) feeb (from_unit) mus rau vib nas this (to_unit).
- Excel hloov pauv kev ua haujlwm hloov pauv ntsuas los ntawm nws lub tsev qub, lossis "los ntawm chav tsev," mus rau "rau ib chav" (chav uas koj tab tom hloov qhov ntsuas rau).
- Sau koj kab ntawv yuav pab koj npaj koj cov ntaub ntawv.
Kauj Ruam 2. Sau kab ntawv B
Nyem rau ntawm cell B1. Qhov no yuav ua haujlwm li koj "to_unit" kem. Ntaus hauv chav uas koj tab tom hloov qhov ntsuas mus rau (piv txwv li vib nas this lossis hnub).
Piv txwv li: sau "Seconds" rau hauv cell B1
Kauj Ruam 3. Sau koj qhov kev ntsuas thawj hauv cell A2
Ntaus thawj qhov ntsuas hauv tus lej nkaus xwb. Tsis txhob nkag mus rau hauv chav nyob.
Piv txwv li: hauv cell A2, sau “21” (zoo li hauv 21 feeb)
Kauj Ruam 4. Qhib "Formula Builder
Hloov chaw ntawm kev nkag mus rau kev hloov pauv ntawm tes, koj tuaj yeem siv Excel tus qauv tsim los pab koj tsim cov qauv.
- Xaiv lub tab "Formula".
- Nyem rau "Formula Builder".
- Xaiv cell B2.
- Xaiv "CONVERT."
Kauj Ruam 5. Sau lub npe ntawm tes (tsab ntawv ua raws tus lej) uas muaj qhov ntsuas thawj hauv kab ntawv "tus lej"
Excel hloov pauv ua haujlwm hu tus nqi no "tus lej."
- Piv txwv li: sau "A2".
- Txog rau kev hloov pauv ib leeg, zoo li hauv qhov piv txwv no, koj kuj tseem tuaj yeem ntaus qhov ntsuas tseeb ("21") tsis yog lub npe ntawm tes.
Kauj Ruam 6. Nkag mus rau chav tsev qub hauv kab ntawv "from_unit"
Nkag mus rau hauv daim ntawv pom zoo ntawm thawj chav.
- Piv txwv li: ntaus “mn” (cov ntawv luv rau feeb).
- Excel muab cov npe tag nrho ntawm cov ntawv luv ntawm chav nyob ntawm no.
Kauj Ruam 7. Nkag mus rau "to_unit
"Ntaus hauv qhov ntawv luv pom zoo rau" to_unit."
Piv txwv li: ntaus “sec” (cov ntawv luv rau vib nas this)
Kauj Ruam 8. Nias ↵ Enter kom ua tiav txoj haujlwm
Kev ntsuas hloov pauv yuav tshwm hauv koj lub cell (qhov no, cell B2).
- Piv txwv li: hauv cell B2, koj yuav pom "1260" (zoo li hauv 1260 vib nas this).
- Yog tias koj tau txais qhov yuam kev "#N/A", txheeb xyuas chav ntawv luv dua. Xyuas kom tseeb tias cov ntawv luv yog qhov raug thiab tias ob chav nyob hauv tib pab pawg (piv txwv li, nws tsis tuaj yeem hloov sijhawm mus rau qhov ntev). Thov nco ntsoov, cov npe tsev thiab cov ntawv ua ntej yog cov ntaub ntawv nkag siab.
- Yog tias koj tau txais "#VALUE!" yuam kev, koj yuav tau nkag mus rau “tus lej” tsis raug. Xyuas kom tseeb tias koj tsuas yog nkag rau ib tus lej lossis siv xov tooj ntawm tes.
Txoj Kev 3 ntawm 3: Ua Ntawv Thov Hloov Ua Haujlwm rau Ntau Lub Cells
Kauj Ruam 1. Xaiv B2 (qhov twg koj qhov kev ua haujlwm CONVERT qub yog)
Txog lub hom phiaj ntawm qhov piv txwv no, cia xav tias ntxiv rau nkag mus rau qhov ntsuas thawj hauv cell A2, koj kuj tau sau cov cell A3 thiab A4 nrog ntsuas. Koj twb tau hloov pauv qhov ntsuas hauv cell A2 los ntawm kev nkag mus rau cov lej hloov pauv hauv cell B2. Koj tuaj yeem hloov pauv qhov seem ntawm koj qhov kev ntsuas (qhov ntsuas hauv A3 thiab A4) los ntawm kev rub cov mis rau hauv cov cell hauv kab B.
- Piv txwv li: hauv cell A2, koj nkag mus rau “1”; hauv cell A3, koj nkag mus rau “5”; hauv cell A4, koj nkag mus rau “10”. Kev hloov pauv koj tau nkag mus rau hauv cell B2 nyeem: "= Hloov (A2," hauv "," cm ")".
- Thaum koj tab tom hloov pauv ntau qhov kev ntsuas, koj yuav tsum nkag mus rau lub npe ntawm tes tsis txhob siv koj qhov kev ntsuas hauv qhov chaw "tus lej".
Kauj Ruam 2. Nyem thiab tuav ntawm lub xwmfab grey hauv kaum sab xis
Thaum koj xaiv lub xovtooj, ib lub xwmfab me, grey tshwm nyob rau hauv kaum sab xis.
Kauj Ruam 3. Luag koj tus cursor hauv kab B kom xaiv ntau lub cell
Tsuas yog xaiv ntau lub hlwb hauv kab B raws li tau sau nrog kev ntsuas thawj hauv kab A.
- Piv txwv li: txij li koj nkag mus ntsuas hauv hlwb A3 thiab A4, koj yuav xaiv cov cell B3 thiab B4.
- Hloov pauv, koj tuaj yeem siv txoj haujlwm hloov pauv mus rau ntau lub cell siv "sau" txoj hauv kev. Tom qab koj tau xaiv cell B2, tuav tseg ⇧ Shift thiab xaiv koj lub cell los ntawm Kab B. Koj yuav tsum xaiv txhua lub cell uas muaj kev ntsuas sib xws hauv kab A. Nyem rau "Tsev" tab. Xaiv "Sau" ces xaiv thiab "Down." Cov kev ntsuas hloov pauv yuav tshwm nyob rau hauv kab B.
Kauj Ruam 4. Tso tus cursor ib zaug koj tau xaiv tag nrho cov cell uas koj xav siv los hloov ua haujlwm rau
Cov kev ntsuas teev tseg hauv kab A yuav raug hloov dua siab tshiab thiab tshwm hauv kab B.
- Piv txwv li: koj yuav pom “2.54” hauv cell B2; "12.7" hauv cell B3; thiab "25.4" hauv cell B4.
- Yog tias qhov ua haujlwm rov qab "#N/A" yuam kev, txheeb xyuas chav ntawv luv dua. Xyuas kom tseeb tias cov ntawv luv yog qhov raug thiab tias ob chav nyob hauv tib pab pawg (piv txwv tias nws tsis tuaj yeem hloov pauv loj mus rau qhov ntev). Thov nco ntsoov, cov npe tsev thiab cov ntawv ua ntej yog cov ntaub ntawv nkag siab.
- Yog tias muaj nuj nqi rov qab "#VALUE!" yuam kev, qhov no txhais tau tias koj tau nkag mus rau "tus lej" tsis raug. Xyuas kom tseeb tias koj tsuas yog nkag rau ib tus lej lossis siv xov tooj ntawm tes.
