Ukusebenzisa umsebenzi we-CONVERT kwiifomula ze-Excel
Umsebenzi we-CONVERT usetyenziselwa ukuguqula izilinganiso ukusuka kwisethi enye yeeyunithi ukuya kwelinye kwi-Excel.
Ngokomzekelo, umsebenzi we-CONVERT ungasetyenziselwa ukuguqula i-degrees Celsius ukuya kuma-degrees Fahrenheit, iiyure ukuya kumaminithi, okanye iimitha ukuya kwiinyawo.
QAPHELA Umsebenzi we-Syntax
Le yile syntax yomsebenzi we-CONVERT:
= INQUBO ( Inombolo , Kusuka_Unit , U_Unit )- = QAPHELA : Lo ngumsebenzi, ngoko akufanele kushintshwe xa uguqula amaxabiso.
- Inani: Ixabiso lokuguqulwa. Ingaba yinombolo egcinwe ngaphakathi kwiseli enye njengoko ifomula okanye enye iboniswe kwelinye iseli.
- Ukusuka_Unit : I- short format yeNombolo yeeyunithi zamanje, kwiingcaphuno.
- U_Unit : I- short format yeyunithi yokulinganisa ukuba inani liya kuguqulwa, kwiingcaphuno.
Xa ukhetha iiyunithi zokuguqulwa, ziimfomfutshane ezifakwe njenge- From_Unit and_Unit arguments for the function. Umzekelo, "in" isetyenziselwa amasentimitha, "m" ngamamitha, "sec" okwesibini, njl. Kukho imizekelo emininzi engezantsi kweli phepha.
UMSEBENZI WOMsebenzi Umzekelo
Qaphela: Le miyalelo ayifaki ukufomatha amanyathelo kwiphepha lokusebenzela njengoko ubona kumfanekiso wethu. Nangona oku kungayi kuphazamisa ukugqiba uqeqesho, iphepha lokusebenzela lakho liya kubonakala lihlukile kunomzekelo oboniswe apha, kodwa umsebenzi we-CONVERT uza kukunika iziphumo ezifanayo.
Kulo mzekelo, siza kujonga indlela yokuguqula umlinganiselo weemitha ezi-3.4 ukuya kumgama olinganayo kwienyawo.
- Faka idatha kwiiseli C1 ukuya kwi-D4 kwiphepha lokusebenzela lase Excel njengoko kuboniswe kumfanekiso ongentla.
- Khetha iseli E4. Yilapho iziphumo zomsebenzi ziza kuboniswa.
- Yiya kwimenyu yefomula kwaye ukhethe iMisebenzi yeMisebenzi> Ubunjineli , kwaye ukhethe i- CONVERT kwimenyu ehlayo.
- Kwibhokisi yencoko , khetha ibhokisi yombhalo ecaleni kwinqanaba "Inombolo", uze uklikha kwifowuni E3 kwiphepha lokusebenzela ukuze ufake ifowuni yencoko kwibhokisi yencoko.
- Buyela kwibhokisi yencoko kwaye ukhethe ibhokisi elithi "From_unit", bese ukhetha iseli D3 kwiphepha lokusebenzela ukufaka eso saziso seeseli.
- Emuva kwibhokisi yencoko yencoko, khangela kwaye ukhethe ibhokisi yombhalo ecaleni kwe "To_unit" uze ukhethe iseli D4 kwiphepha lokusebenzela ukufaka eso saziso seeseli.
- Chofoza OK .
- Impendulo ye-11.15485564 ifanele ivele kwiseli ye-E4.
- Xa ucofa kwiseli E4, umsebenzi opheleleyo = UKUQHUBEKA (E3, D3, D4) kubonakala kwibha yefomula ngaphezulu kwephepha lokusebenzela.
- Ukuguqula ezinye iimitha ukusuka kumamitha ukuya kwiinyawo, utshintshe ixabiso kwi-cell E3. Ukuguqula amaxabiso usebenzisa iiyunithi ezahlukeneyo, faka iifutshane zeeyunithi kwiiseli D3 ne-D4 kunye nexabiso eliya kuguqulwa kwiseli E3.
Ukwenza kube lula ukufunda impendulo, inani leendawo zokugqibela eziboniswe kwiseli ye-E4 zingancitshiswa ngokusebenzisa i- Decrease Decimal option ekhoyo kwiKhaya> Icandelo lemenyu yenombolo.
Enye inketho yamanani amade anjengaloku ukusebenzisa umsebenzi weROUNDUP .
Uludwe lwe-Excel ye-CONVERT Imisebenzi yokulinganisa iiNyunithi kunye neeNqununu zazo
Ezi zifutshane zifakwe njenge- From_unit okanye i- To_unit ingxabano yomsebenzi.
Iifomfutshane ziyakucelwa ngokuthe ngqo kumgca ofanelekileyo kwibhokisi yencoko , okanye isalathisi yendawo yesalathisi kwindawo yesikhashana kwifom yokusebenzela ingasetyenziswa.
Ixesha
Unyaka - "yr" Usuku - "imini" Ihora - "hr" Minute - "mn" Okwesibini - "sec"Ukushisa
I-Degree (Celsius) - "C" okanye "cel" I-Degree (Fahrenheit) - "F" okanye "fah" Degree (Kelvin) - "K" okanye "kel"Umgama
Imitha - "m" Mile (ummiselo) - "mi" Mile (i-nautical) - "Nmi" Mile (i-US survey survey mile) - "uphando_mi" intshi - "kwi" Inyawo - "ft" Yard - "yd" Umnyaka wokukhanya - "ly" iParsec - "pc" okanye "parsec" Angstrom - "ang" Pica - "pica"Ukulinganiswa kwamanzi
I-Liter - "l" okanye "lt" iTaspoon - "tsp" iTablespoon - "tbs" I-Funid ounce - "oz" Cup - "indebe" I-Pint (US) - "pt" okanye "us_pt" I-Pint (UK) - "uk_pt" I-Quart - "qt" Gallon - "gal"Ubunzima kunye noMisa
I-Gram - "g" I-Pound mass (eudupois) - "lbm" I-mass mass (aitdupois) - "ozm" i-Hundredweight (i-US) - "cwt" okanye "shweight" Amakhulu amakhulu (ubukhosi) - "uk_cwt" okanye "lcwt" U (i-athomu unyunithi) - "u" Ton (imperial) - "uk_ton" okanye "LTON" Slug - "sg"Uxinzelelo
Pascal - "Pa" okanye "p" I-Atmosphere - "atm" okanye "kwi" mm ye-Mercury - "mmHg"Amandla
I-Newton - "N" Dyne - "dyn" okanye "dy" Amandla ePound - "lbf"Amandla
Amandla amahhashi - "h" okanye "HP" iPferdestärke - "PS" Watt - "w" okanye "W"Amandla
I-Joule - "J" Erg - "e" I-calorie (i-thermodynamic) - "c" I-calorie (IT) - "itol" I-electron volt - "ev" okanye "eV" Iholide yehora - "hh" okanye "i-HPh" yeeyure - "wh" okanye "Wh" Iinyawo-iipilithi - "flb" BTU - "btu" okanye "BTU"Magnetism
Tesla - "T" Gauss - "ga"Qaphela: Azikho zonke iinketho ezidweliswe apha. Ukuba iyunithi ayifuni ukuba ifumanekisiwe, ayibonakali kweli khasi.
Iyunithi yeMetric
Kwiiyunithi zamatrikhi, utshintsho kuphela kwigama leyunithi njengoko linciphisa okanye linyuka ngobukhulu liqalo elisetyenziswe phambi kwegama, njengemitha yamentimitha yeimitha ezili-0.1 okanye iimitha ezili-1,1 zamitha.
Oku kunikwe apha, ngezantsi uluhlu lweengqungquthela zetekisi elilodwa ezingafakwa phambi kweyunithi yeetrikthi ezifakwe apha ngasentla ukutshintsha iiyunithi ezisetyenziswe kwi- From_unit okanye kwi- To -unit arguments.
U mzekelo:
- Kwiimimandla, ukuguqula umgama ukuya kwiikhilomitha kuneemitha, sebenzisa iikhilomitha endaweni ye- m
- Isisindo, ukuguqula ii-ounces ukuya kuma-milligrams kunokuba amagramu, sebenzisa mg esikhundleni se g
Ezinye zeenkcazo ezifunekayo mazifakwe kwisigxina:
Isiqendu - Iifutshane ze-exa- "E" ipeta - "P" itera - "T" i-giga - "G" i-mega- "M" i-kilo - "k" i-hecto- "h" i-dekao- "e" i-deci - "d" i - centi - "m" - "m" emfutshane - "u" nano - "n" pico - "p" i-femto - "f" atto - "a"