Kushandisa Basa re CONVERT muExcel Formulas
Basa reCONVERT rinoshandiswa kushandura zviyero kubva kune imwe yezvikamu kusvika kune imwe muExcel.
Semuenzaniso, basa reCONVERT rinogona kushandiswa kushandura madigiri Celsius kusvika kune madigiri Fahrenheit, maawa kusvika kumaminiti, kana mamita kusvika patsoka.
CONVERT Function Syntax
Iyi ndiyo mutsara weCONVERT basa:
= CONVERT ( Nhamba , Kubva_Unit , To_Unit )- = KUTENDA : Iri ndiro basa, saka harifaniri kuchinjwa kana uchichinja maitiro.
- Nhamba: kukosha kunoshandurwa. Inogona kuva nhamba inobatwa mukati memusero iwoyo seyemuti kana imwe inotaurwa mune imwe sero.
- Kubva_Unit : Ichinyorwa chemaNhamba yezvinoyera chiyero chezvikwata, muzvinyorwa.
- To_Unit : The shortform ye unit unit kuti Nhamba ichashandurwa, muzvinyorwa.
Pakusarudza mauniti ekutendeuka, ndiwo maitiro mashoma anopinda seKu -Unit uye To_Unit nharo dzebasa racho. Somuenzaniso, "in" inoshandiswa masendimita, "m" emamita, "sec" kwechipiri, nezvimwe. Pane mimwe mimwe mienzaniso iri pasi peji ino.
CONVERT Function Example
Cherechedza: Mirayiridzo iyi haisanganisi maitiro ekufambisa pepa rekushanda sezvamunoona mumufananidzo wedu wemufananidzo. Kunyange zvazvo izvi zvisingagoni kupindira nekuzadzisa tadzidzo, pepa rako rekushanda richave rakasiyana nemuenzaniso wakaratidzwa pano, asi basa re CONVERT richakupa mhinduro imwechete.
Mumuenzaniso uyu, tichaona nzira yekushandura chiyero chemamita 3.4 kusvika kune imwe nzvimbo yakaenzana mumakumbo.
- Isa data mumasero C1 kusvika kuD4 eExpcel sheetsheet sezvinoonekwa mumufananidzo uri pamusoro.
- Sarudza seero E4. Iyi ndiyo iyo migumisiro yebasa icharatidzwa.
- Enda kuMenyu yeFormula uye sarudza Mamwe Mabasa> Engineering , uye osarudza CONVERT kubva mumenyu yakaderera.
- Mubhokisi rebhokisi , sarudza bhokisi rebhokisi riri pedyo ne "Number" line, uye ipapo chengeta pane cell E3 mune pepa rekushandisa kuti uise iyo cell reference mubhokisi rebhokisi.
- Dzokera kubhokisi rebhokisi uye sarudza "Kubva_unit" bhokisi bhokisi, uye sarudza sero D3 mune pepa rekushandisa kuti uise iyo cell reference.
- Dzokera mune imwechete dialog box, tsvaga uye sarudza bhokisi rebhokisi riri pedyo ne "To_unit" uye sarudza sero D4 mune pepa rekushandisa kuti uise iyo cell reference.
- Dzvanya OK .
- Mhinduro 11.15485564 inofanira kuonekwa muchitokisi E4.
- Paunenge uchinge uri pa cell E4, basa rakakwana = CONVERT (E3, D3, D4) rinowanikwa mubhairi yepamusoro pane pepa pepaji.
- Kuti uchinje mamwe marefu kubva pamamita kusvika kune tsoka, shandura kukosha muchitokisi E3. Kuti uchinje mararamiro uchishandisa diyuniti yakasiyana, pinda maitiro mashoma emakamuri mumasero D3 uye D4 uye kukosha kuchinjwa muchitsetse E3.
Kuita kuti zvive nyore kuverenga mhinduro, nhamba yenzvimbo dzepamusoro dzakaratidzwa muchitokisi E4 inogona kuderedzwa kuburikidza nekuderedza kuderedza Decimal sarudzo inowanika paIndaneti > Nhamba yemenyu chikamu.
Imwe nzira yekutora nhamba yakareba seyikushandisa basa ROUNDUP .
Rongedzo rweExcel yeCONVERT Mushandi Wezviyero Zvimwe Zvimwe uye Zvishoma Zvo
Aya maitiro mashoma anopinda seChe_unit kana To_unit nharo yebasa racho.
Izvozvo zvishoma zvinogona kuiswa zvakananga mumugwagwa wakakodzera mubhokisi rebhokisi , kana sero rinoreva panzvimbo yechinyorwa mubasa rekushandisa rinogona kushandiswa.
Nguva
Gore - "yr" Zuva - "zuva" Awa - "hr" Minute - "mn" Chepiri - "sec"Kupisa
Degree (Celsius) - "C" kana "cel" Dhigiri (Fahrenheit) - "F" kana "fah" Dhigirii (Kelvin) - "K" kana "kel"Kureba
Meter - "m" Mile (mutemo) - "mi" Mile (nautical) - "Nmi" Mile (US inotsvakurudza mamiriyoni emurairo) - "survey_mi" Inch - "mu" Foot - "ft" Yard - "yd" Chiedza chegore - "ly" Parsec - "pc" kana "parsec" Angstrom - "ang" Pica - "pica"Muyero Wemvura
Zvinyorwa - "l" kana "lt" Teaspoon - "tsp" Tapepoon - "tbs" Fluid ounce - "oz" Cup - "kapu" Pint (US) - "pt" kana "us_pt" Pint (UK) - "uk_pt" Quart - "qt" Gallon - "gal"Kurema uye Misa
Gram - "g" Pound mass (gotdupois) - "lbm" Ounce mass (gotdupois) - "ozm" Hundredweight (US) - "cwt" kana "shweight" Mazana zana (mutongi) - "uk_cwt" kana "lcwt" U (atomic mass unit) - "u" Ton (mutongi) - "uk_ton" kana "LTON" Slug - "sg"Kushingaira
Pascal - "Pa" kana "p" Atmosphere - "atm" kana "pa" mm ye Mercury - "mmHg"Simba
Newton - "N" Dyne - "dyn" kana "dy" Pound simba - "lbf"Simba
Horsepower - "h" kana "HP" Pferdestärke - "PS" Watt - "w" kana "W"Simba
Joule - "J" Erg - "e" Calorie (thermodynamic) - "c" Calorie (IT) - "cal" Electron volt - "ev" kana "eV" Hondo yeHondo -Hh "kana" HPh "Watt-awa - "wh" kana "Wh" Foot-pound - "flb" BTU - "btu" kana "BTU"Magnetism
Tesla - "T" Gauss - "ga"Cherechedza: Haisi zvose zvingasarudzwa zvakanyorwa pano. Kana chikwata chacho chisingadi kuve chidimbu, hachina kuratidzwa peji ino.
Metric Unit Shortforms
Pamatunhu emataundi, shanduko chete kune zita reyuniti sezvo inoderedza kana kuwedzera muhukuru ndiyo chigamba chinoshandiswa pamberi pezita, semamita mamita emamita mita 0,1 kana kiro mamita 1 000.
Zvichipa izvi, pasi apa pane runyora rwemashoko asina kunyorwa anokwanisa kuiswa pamberi peyuniti yematric shortform yakanyorwa pamusoro apa kuti uchinje mauniti anoshandiswa mune zve- Kubva_uniti kana ku-ku- aritano .
Mienzaniso:
- Kwemharaunda, kuchinja maira kusvika makiromita panzvimbo pemamita, shandisa km pane m
- Pakurema, kutenderera maunundi kusvika kune magiramu, kushandisa mg pane g
Mamwe emashoko ekutanga anofanirwa kupindirwa muchikurukuro:
Prefix - Shortform exa - "E" peta - "P" tera - "T" giga - "G" mega - "M" kilo - "k" hecto - "h" dekao - "e" deci - "d" centi - "c" m "-" m "micro -" u "nano -" n "pico -" p "femto -" f "atto-" a "