Ukusebenzisa umsebenzi we-CONVERT kumafomula e-Excel
Umsebenzi we-CONVERT usetshenziselwa ukuguqula izilinganiso kusuka kwesethi eyodwa yamayunithi kuya kwesinye ku-Excel.
Isibonelo, umsebenzi we-CONVERT ungasetshenziswa ukuguqula ama-degrees Celsius kuya kuma-degree Fahrenheit, amahora kuya kumaminithi, noma amamitha kuya ezinyaweni.
QAPHELA Umsebenzi we-Syntax
Lena yi- syntax yomsebenzi we-CONVERT:
= INQUBO ( Inombolo , Kusuka_Ukuthi , Ku_Uku )- = QAPHELA : Lona umsebenzi, ngakho akufanele neze ushintshe uma uguqula amanani.
- Inombolo: Inani elizoguqulwa. Kungaba nenombolo egcinwe ngaphakathi kweseli efanayo nefomula noma eyodwa ekhonjisiwe kwelinye iseli.
- Kusuka_Unit : I-shortform ye-Unit yesilinganiso samanje samanani , ngokucaphuna.
- Uku_Ukuthi : I-shortform yeyunithi yokulinganisa ukuthi iNombolo izoguqulwa ibe, ngamacaphuno.
Uma ukhetha amayunithi wokuguqulwa, yi-shortforms efakwe njengama- From_Unit and To_Unit izingqinamba zomsebenzi. Isibonelo, "ku" isetshenziselwa amasentimitha, "m" ngamamitha, "isekhondi" okwesibili, njll Kunezibonelo eziningi ezingezansi kuleli khasi.
CONVERT Umsebenzi Isibonelo
Qaphela: Le miyalo ayifaki ukufomatha izinyathelo zephepha lokusebenzela njengalokhu ubona esithombeni sethu sesibonelo. Nakuba lokhu kungeke kuphazamise ukuqedela ukufundisa, ishidi lakho lokusebenzela lizobonakala lihlukile kunalesi sibonisi lapha, kepha umsebenzi we-CONVERT uzokunika imiphumela efanayo.
Kulesi sibonelo, sizobheka indlela yokuguqula isilinganiselo samamitha angu-3.4 ukuya endaweni eqondile ezinyaweni.
- Faka idatha kumaseli C1 kuya ku-D4 wephepha lokusebenzela le-Excel njengoba kuboniswa esithombeni ngenhla.
- Khetha iseli E4. Yilapho imiphumela yomsebenzi izoboniswa khona.
- Iya kwimenyu yamafomula bese ukhetha Imisebenzi eminingi> Ubunjiniyela , bese ukhetha CONVERT kusuka kulowo menyu ehlayo.
- Ebhokisini lebhokisi , khetha ibhokisi lombhalo eceleni komugqa "Wezinombolo", bese uchofoza esitokisini E3 kushidi lokufaka ukuze ufake lelo fenethi yeseli ebhokisini lengxoxo.
- Buyela ebhokisini lebhokisi bese ukhetha ibhokisi elithi "From_unit", bese ukhetha iseli D3 kusikripthi sokusebenzela ukuze ufake leyo reference reference.
- Emuva ebhokisini lebhokisi elifanayo, thola bese ukhetha ibhokisi lombhalo eceleni kwe "To_unit" bese ukhetha iseli D4 kushidi lokufaka ukufaka leyo reference yeselula.
- Chofoza OK .
- Impendulo 11.15485564 kufanele ivele esitokisini E4.
- Uma uchofoza ku-cell E4, umsebenzi ophelele = CONVERT (E3, D3, D4) ibonakala kwibha yefomula ngaphezulu kwephepha lokusebenzela.
- Ukuze uguqule amanye amabanga ukusuka kumamitha kuya ezinyaweni, shintsha inani ku-cell E3. Ukuze uguqule amagugu usebenzisa amayunithi ahlukene, faka ubude obukhulu bamayunithi kumaseli D3 no-D4 kanye nenani elizoguqulwa kwiseli E3.
Ukwenza kube lula ukufunda impendulo, inani lezindawo zamadesimali eziboniswa kuseli le-E4 lingancishiswa ngokusebenzisa inketho yokunciphisa i- Decimal etholakalayo ekhasini > Imenyu yemenyu yenombolo .
Enye inketho yezinombolo ezinjengelokhu ukusebenzisa umsebenzi we- ROUNDUP .
Uhlu lwe-Excel luka-CONVERT Lokusebenza Kwezinyathelo Zokulinganisa Nezifinyezo Zaso Ezincane
Lezi zinguqulo ezincane zifakiwe njengengxabano evela ku - From_unit noma To_unit yomsebenzi.
I-shortforms ingahle ifakwe ngqo emgqeni ofanele ebhokisini lengxoxo , noma ireferensi yeseli endaweni yesikhashana esifundeni somsebenzi ingasetshenziswa.
Isikhathi
Unyaka - "Yr" Usuku - "Usuku" Ihora - "hr" Minute - "mn" Okwesibili - "isekhondi"Ukushisa
I-Degree (Celsius) - "C" noma "cel" Degree (Fahrenheit) - "F" noma "fah" Degree (Kelvin) - "K" noma "kel"Ibanga
I-Meter - "m" Mile (isimiso) - "mi" Mile (nautical) - "Nmi" Mile (i-US yokuhlola ukulinganisa umthetho) - "ucwaningo_mi" intshi - "ku" Izinyawo - "ft" Yard - "yd" Umnyaka wokukhanya - "ly" i-Parsec - "pc" noma "i-parsec" I-Angstrom - "ang" i-Pica - "i-pica"Ukulinganiswa kwamanzi
Ithinipuni - "l" noma "lt" - "tsp" I-tablespoon - "tbs" I-ounce ye-Fluid - "oz" "indebe" ye-Pint (US) - "pt" noma "us_pt" I-Pint (UK) - "uk_pt" I-Quart - "qt" Gallon - "gal"Isisindo noMisa
I-Gram - "g" I-Pound mass (aitdupois) - "lbm" I-mass mass (aitdupois) - "ozm" Hundredweight (US) - "cwt" noma "shweight" ama-Hundredweight (umbusi) - "uk_cwt" noma "lcwt" U (i-athomu unit mass) - "u" Ton (umbusi) - "uk_ton" noma "LTON" Slug - "sg"Ukucindezela
Pascal - "Pa" noma "p" I-Atmosphere - "atm" noma "ku-" mm ye-Mercury - "mmHg"Qinisekisa
I-Newton - "N" Dyne - "dyn" noma "dy" Amandla e-Pound - "lbf"Amandla
Amandla amahhashi - "h" noma "HP" Pferdestärke - "PS" Watt - "w" noma "W"Amandla
I-Joule - "J" Erg - "e" Ikholori (i-thermodynamic) - "c" Ikholori (IT) - "ikhal" I-Electron volt - "ev" noma "eV" Ihora lokuhamba ngamahhashi - "hh" noma i- "HPh" ihora le-watt - "wh" noma "Wh" i-foot-pound - "flb" BTU - "btu" noma "BTU"Magnetism
Tesla - "T" Gauss - "ga"Qaphela: Akuzona zonke izinketho ezibalwe lapha. Uma ngabe iyunithi ayidingi ukufinyezwa, ayibonisi kuleli khasi.
I-Metric Unit Shortforms
Amayunithi amamitha, ukuguqulwa okuphela kwegama leyunithi njengoba kunciphisa noma kwanda ngosayizi yisiqalo esisetshenziswe ngaphambili kwegama, njengamitha yamentimitha ngamamitha ayi-0.1 noma imitha yamamitha ayi-1,000.
Njengoba kunikezwe lokhu, ngezansi uhlu lwezingqayizivele zezinhlamvu ezingasetshenziswa ngaphambi kweyunithi yamatriki okufingqiwe okubalwe ngenhla ukushintsha amayunithi asetshenziswe ku- From_unit noma ku- To_unit izingqinamba.
Izibonelo:
- Ngokuhamba, ukuguqula amakhilomitha ukuya amakhilomitha kunokuba ube ngamamitha, sebenzisa i- km esikhundleni se- m
- Isisindo, ukuguqula ama-ounces kuya kuma-milligram esikhundleni samagremu, sebenzisa mg esikhundleni seg
Ezinye ze-prefixes kufanele zingenwe ku-inercercase:
Isiqephu - I-shortform exa - "E" peta - "P" tera - "T" i-giga - "G" igaga - "M" kilo - "k" i-hecto - "h" i-dekao - "e" i - deci - "d" i - centi - "c" - "m" micro - "u" nano - "n" pico - "p" i-femto - "f" atto - "a"