Yuav ua li cas hloov phaus rau kilograms hauv Excel?
Yuav ua li cas hloov phaus rau kilograms hauv Excel?

Video: Yuav ua li cas hloov phaus rau kilograms hauv Excel?

Video: Yuav ua li cas hloov phaus rau kilograms hauv Excel?
Video: Военные тактические часы-Топ-10 самых жестких военных ч... 2024, Kaum ib hlis
Anonim

Hloov nruab nrab mus kg

Xaiv ib lub xov tooj dawb nyob ib sab ntawm koj phaus cov ntaub ntawv, thiab ntaus cov qauv no = Hloov pauv (A2, "lbm", " kg ") mus rau hauv nws, thiab nias Enter tus yuam sij, tom qab ntawd luag tus autofill tuav mus rau cov kab ntau yam uas koj xav tau hloov kg rau phaus , thov siv cov qauv no = Hloov pauv (A2, " kg ", "lbm").

Ib yam li ntawd, kuv yuav hloov cov grams rau kilograms hauv Excel li cas?

Muaj 1,000 grams hauv ib kilogram . Qhov no txhais tau tias convert grams rau kilograms yog ib qho yooj yim: justdivide tus naj npawb ntawm grams los ntawm 1,000.

Method 1 Converting With Math

  1. Sau tus naj npawb ntawm grams. Sau nws "grams" lossis "g."
  2. Faib 1,000.
  3. Sau npe rau koj cov lus teb.
  4. Txhawm rau rov qab mus rau grams, muab 1,000.

Ib sab saum toj no, koj ua li cas xam tus nqi ib phaus hauv Excel? Rau xam tus nqi ntawm tej yam khoom perpound , faib kos cov yam khoom los ntawm nws qhov hnyav hauv phaus : nqi ÷ phaus = nqi perpound.

Ua kom pom qhov no, koj puas tuaj yeem hloov cov units hauv Excel?

Cov Excel CONVERT muaj nuj nqi converts tus lej inone ntsuas system rau lwm tus. Piv txwv li, koj ua tau siv Hloov pauv rau hloov ko taw mus rau hauv meters, phaus intokilograms, Fahrenheit mus rau Celsius, gallons rau litres, thiab rau ntau yam chav tsev hloov dua siab tshiab.

Koj siv units hauv Excel li cas?

Xaiv ib lub xovtooj dawb ntawm ib sab ntawm lub nrig ntawm daim ntawv teev npe, thiab sau cov qauv no = B2&"$" (B2 qhia tias lub xovtooj ntawm tes koj xav tau nws tus nqi, thiab $ yog qhov chav tsev koj xav ntxiv rau) rau hauv nws, thiab nias Enter, ces luag tus AutoFill kov rau qhov ntau.

Pom zoo: